Best Resources for Migrating Complex Crystal Reports to SSRS 2005
Posted on 2006-06-18
I am using SQL Server 2005, with SSRS 2005 and Visual Studio 2005. I am more comfortable with VB, but can interpret C# just fine (takes a bit longer). I am an expert with CR up to version 10, I am new with XI.
FYI: I am also using SQL 2000, and Visual Studio 2002 and 2003.
FYI: I have been using the non-embedded CR report model. I can change the reports (.rpt files) without changing the code.
I've read just about everything I can find on SSRS 2005 (SSRS) and migrating Crystal Reports (CR) to SSRS (web, tutorials and books). However, most of what I have come across address tabular or cross-tab reports; and I have found nothing so far on the topics that are of most interest to me.
1. Dynamic page handling for duplex printing / and font size - most records will fit on 2 pages at 6pt font (CR ~ 350/500 displayed records in ~ 13 subreports in addition to the main report). Sometimes I have to go to a 3rd and 4th page if a sureport section exceeds an expected limit. In CR I use the Mod(ulo) function. How does this work in SSRS?
2. Statistical Analysis. Depending on the report requirements I often need to show the Mean, Median, Quartile and COD results. It took some jumping through hoops in CR, have to use running totals - but I am at a loss as to how I can do this with SSRS?
3. Selection Criteria. My current applications use forms (Windows or Web) to allow the user to select one or many options to pass as RecordSelectionFormulas. This is part of the Crystal API. How do I do this with SSRS?
For me, these are hard questions and they each merit 500 pts. Please let me know if I should separate them for further assistance?
My bottom-line question here, is: Can it be done? If so, please point me to the right direction.