Convert from crystal to ssrs tool

Epicor ERP 10
, ,
1

Dears, is there any tool for converting crystal report to ssrs, i saw many website but its all services i need tool to download it to my computer and upload the reports, thank you.

Regards, Ahmad Itani

2

Mr. Ahmad: I have done a number of Crystal to SSRS reports.

I have heard of some services that will upgrade your reports ( i have never used any of them) however, i have heard that the services really only capture the layouts and rarely the logic behind the scenes.

At the end of the day you will still have to tweak the “upgraded” reports to work properly.

The structure of both are so different - there really is no easy conversion. I would point to SSRS Headers and Footers are a nightmare (compared to Crystal).

Sorry my short answer is NO - do not use the online tools/services.

SSRS is not that bad, it requires a shift in thinking however.
I have been able to replicate almost every Crystal feature in SSRS (including watermarks) so it can be done. It’s just going to take some time.

DaveO

3 Likes
3

I would agree completely with Dave as I have literally converted hundreds of Crystal Reports to SSRS. There is no simple way other than just doing it manually. Formulas, Expressions, Conditional Suppression, Sub-Reports, multiple datasets can make some reports really complex. Page Headers do not really exist in SSRS.
In my experience other than what I would call Report Forms (like an Invoices or Checks), most reports are more like listings that could be done easily and faster as a dashboard, direct query into Excel or OLAP tool.

4

Have you found a way to implement “Print at bottom of page” feature in SSRS.

5

Dear Mr.Dave your email well received, thank you for your answer i will try to find faster way to convert crystal report fast manually, thank you and have a nice day.

Regards, Ahmad Itani

1 Like
6

No Dear i didn’t find.

7

There is a way to print totals at the bottom of the page - however it is not bullet proof.

  1. The big picture is to create a Tablix footer that contains your summary (lets say a PO total).
  2. Next Hide the Tablix footer.
  3. Add a Rectangle to the report Footer - carefull here, we cannot suppress the page footer - just the rectangle.
  4. Add a field to the rectangle in the report footer and reference the SSRS ReportItems!.Value to show the contents of your PO Total.
  5. Add Suppression logic to the report footer to only show on the last page.

Please note that subreports can mess up the page numbering depending on the version of SQL you are running.

DaveO

2 Likes
8

@DaveOlender is the SSRS man! Thanks for the tips.

9

I have recently run across a custom layout with the page footer in an AR Invoice, that when the supressed Tablix “footer” is positioned so that perhaps he is at the end of a particular page, the ReportItems! does not work for the Page Footer on the subsequent page. If I put a border around him so that I can see him, and change the suppression as to not suppress the Tablix Row ( interestingly, while suppressing the containing rectangle in the Table Row “footer” ) does allow it to work. However, this is likely more because that makes him the first object on the same page.
But for this reason I am considering rewriting to a Set Variable / Get Variable concept so as to avoid the issue.
Totally agreed, I have spent probably 100 hours just on Invoice page numbering and page footer issues, and yes, wholeheartedly agree with the influence of the subreports. You can make minor tweaks in the layout to force it to work in one test case, but you just delay the inevitable when one slightly different line note, subreport, address length, something pushes it over the edge again.
Most frustrating thing I know of in SSRS.

In a previous life, on a different ERP system, we did have good success with our style of reports using the conversion service. In fact, we would have been incredibly far behind schedule without it. Agreed, some still need a complete rewrite but we found it overall useful. It would not hurt to try a few and see what you end up with. That was our approach, and you will know right away whether it is going to benefit you or not. We used CrystalConversions back then.

That said, all of our conversions in Epicor have been rewrites. Not because a conversion tool did not work, we did not try it.

10

Pretty sure Epicor used some tool with the stock reports when they switched to SSRS. We tried one but it was more work on the report we thought would be “easy” we decided to just do rewrites. Perhaps we picked the wrong report. LOL