Has anyone moved reports from E9 Crystal to E10 SSRS? What tools did you use for this?
We had Epicor migate our data, we had a little work on some but for the most part smooth.
- Open the SSRS report’s RDL
- Make all the changes that you did in CR
- Curse how horrible SSRS is.
1 Like
So no auto process to move them over. They have to all be manually re-created?
Yup.
But you can still use CR reports in E10 if you have any that are too hard to re-create in SSRS (or need to go live quicker than you have time to learn SSRS report design).
You’ll need to enable SSRS & CR in Company Maint (I think), and most importantanly, install the CR Runtime on the client (you might be good there if using same workstations for E10 as you were for E9)
1 Like
Did you move everything or keep some in crystal?
Moved anything that didn’t require jumping through hoops in SSRS (somethings just aren’t done as easily as they are in CR). So we eventually revamped the “builtin” SSRS reports to look like our CR reports. There are about 3 or 4 that we still use the CR version because it was just too hard to do it in SSRS.
Notably, CR does a much better job at page breaks, headers and footers. Some reports (like batch printing AR invoices) get processed as “one report”, So you can’t easily age a page number or Number of pages. At least not as easily as it was in CR.
1 Like
Hi Calvin,
In CR there we can do a “Print at the bottom of page” for a section or group. Have you implemented that in SSRS. This is an area which is holding some reports from conversion into SSRS.
Thanks
Vinay Kamboj
Yes… the ONE thing that I think is a big step backward between E9 and E10.
That’s the kind of thing that holds us back too.
The ability to suppress headers and footers in CR was great. In SSRS the best you can do is to make it shown/suppressed only on the first page / last page