We currently use Crystal Reports 11.5 in our desktop app and wish to get away from Crystal in the worst way. Let me explain how we do our reporting with Crystal and hopefully Telerik can perform the same functions we need.
1. Our support/report team creates a report with Crystal and saves it as a rpt file. The data source is ole db for sql.
2. The rpt is imported into MSSQL database as a blob.
3. Upon selecting the report to run we extract the report to the local file system as report.rpt
4. Code Snippet to set report connection
ConnectionInfo conInfo = new ConnectionInfo();
conInfo.DatabaseName = DB.m_dbname;
conInfo.UserID = "UserName";
conInfo.Password = "Password";
conInfo.ServerName = DB.m_server;
m_rptdoc.SetDatabaseLogon(conInfo.UserID, conInfo.Password, conInfo.ServerName, conInfo.DatabaseName);
DBSelection(conInfo);
crViewer.ReportSource = m_rptdoc;
5. Then we watch for the print event from crystal. If they print the file we grab the printed version of the file and archive it in the database.
//m_rtpdoc is the crystal report
string keywords = m_rptdoc.SummaryInfo.KeywordsInReport;
foreach (ParameterField pf in m_rptdoc.ParameterFields)
{
if (pf.Name == "PatientID" ||
pf.Name == "POSDocID")
{
pf.CurrentValues.Clear();
pf.CurrentValues.AddValue(ids.IDAtThisLevel(1));
}
6. We also watch to see what parameters crystal will ask for and if we already have them we pass them with code behind.
Hopefully somebody can shed some light on if this is doable with Telerik. Thank You