Learning curve from Crystal to SSRS

Yahoo Archive
1
Hello!

You can find the Report's GUID in the System Monitor's "Reports" tab when the report runs successfully.
Look for column "FileName". Expand it. You will see something like this:

Report Database: long guid number.

That is the GUID for the Epicor Report. You will see this GUID in the Reporting Database.

-David
2

Good morning, group: 


We are in the process of moving from 8.03 to 10.100.700, and noticed most of the canned reports, while available to edit, are in SSRS.


It seems most task require a little more effort to update or make changes to the standard reports. 


I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?


We also have several reports customized in Crystal from 8.03.  I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?


Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?


Thanks!

3


I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?

​- Yes this is the tool you should use, you can also use Visual Studio but it is pretty much the same thing​

We also have several reports customized in Crystal from 8.03. I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?

​- Yes you will have to re-create these reports, no there is no magical formula​

Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?

​- Yes you can previous your SSRS report, simply run the report in EPICOR get in the File Column the GUID (in your system agent)​ and paste into the Report Parameter TableGuid


​Learning curve is fairly steep but not impossible, it helps if you know / understand SQL ​
Â


Thanks!





Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?
4

Aside from Jose’s good advice you can also “bridge the gap” during the learning curve by running Crystal still.  It works fine and the E9 versions (in a handy .zip file) on EPICweb are easy to make run with the same .XML file sources that feed them.  Or use straight SQL ODBC for reports not run from screen selections.  Then if you run into a tough conversion to SSRS you can move on to the easier ones on the curve and come back later when more experienced.  It’s not a black & white E10 is SSRS only situation and everything you need for Crystal based report styles is available still.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 11:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Learning curve from Crystal to SSRS

 

 

Good morning, group: 

 

We are in the process of moving from 8.03 to 10.100.700, and noticed most of the canned reports, while available to edit, are in SSRS.

 

It seems most task require a little more effort to update or make changes to the standard reports. 

 

I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?

 

We also have several reports customized in Crystal from 8.03.  I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?

 

Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?

 

Thanks!

5

Stick with Crystal…There will be either a replacement for SSRS or SSRS will change…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

 

 

Aside from Jose’s good advice you can also “bridge the gap” during the learning curve by running Crystal still.  It works fine and the E9 versions (in a handy .zip file) on EPICweb are easy to make run with the same .XML file sources that feed them.  Or use straight SQL ODBC for reports not run from screen selections.  Then if you run into a tough conversion to SSRS you can move on to the easier ones on the curve and come back later when more experienced.  It’s not a black & white E10 is SSRS only situation and everything you need for Crystal based report styles is available still.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 11:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Learning curve from Crystal to SSRS

 

 

Good morning, group: 

 

We are in the process of moving from 8.03 to 10.100.700, and noticed most of the canned reports, while available to edit, are in SSRS.

 

It seems most task require a little more effort to update or make changes to the standard reports. 

 

I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?

 

We also have several reports customized in Crystal from 8.03.  I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?

 

Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?

 

Thanks!

6

I’m curious, is this speculation?  Or have you heard or read something?

 

Mike

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

 

 

Stick with Crystal…There will be either a replacement for SSRS or SSRS will change…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

 

 

Aside from Jose’s good advice you can also “bridge the gap” during the learning curve by running Crystal still.  It works fine and the E9 versions (in a handy .zip file) on EPICweb are easy to make run with the same .XML file sources that feed them.  Or use straight SQL ODBC for reports not run from screen selections.  Then if you run into a tough conversion to SSRS you can move on to the easier ones on the curve and come back later when more experienced.  It’s not a black & white E10 is SSRS only situation and everything you need for Crystal based report styles is available still.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 11:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Learning curve from Crystal to SSRS

 

 

Good morning, group: 

 

We are in the process of moving from 8.03 to 10.100.700, and noticed most of the canned reports, while available to edit, are in SSRS.

 

It seems most task require a little more effort to update or make changes to the standard reports. 

 

I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?

 

We also have several reports customized in Crystal from 8.03.  I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?

 

Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?

 

Thanks!

7

Not speculation…Or anything I have read. They know it is an issue. It is something that is being addressed.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 1:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

 

 

I’m curious, is this speculation?  Or have you heard or read something?

 

Mike

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

 

 

Stick with Crystal…There will be either a replacement for SSRS or SSRS will change…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

 

 

Aside from Jose’s good advice you can also “bridge the gap” during the learning curve by running Crystal still.  It works fine and the E9 versions (in a handy .zip file) on EPICweb are easy to make run with the same .XML file sources that feed them.  Or use straight SQL ODBC for reports not run from screen selections.  Then if you run into a tough conversion to SSRS you can move on to the easier ones on the curve and come back later when more experienced.  It’s not a black & white E10 is SSRS only situation and everything you need for Crystal based report styles is available still.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 11:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Learning curve from Crystal to SSRS

 

 

Good morning, group: 

 

We are in the process of moving from 8.03 to 10.100.700, and noticed most of the canned reports, while available to edit, are in SSRS.

 

It seems most task require a little more effort to update or make changes to the standard reports. 

 

I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?

 

We also have several reports customized in Crystal from 8.03.  I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?

 

Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?

 

Thanks!

8
I would not recommend sticking with Crystal, Its fine as a hold over while you work on upgrading your reports... but  SSRS is not going anywhere and there are very few products in the market that can do this sort of thing so I doubt Epicor is going to spend more time and energy re-vamping their reporting choice when most of their customers already upgraded to SSRS. SSRS has its issues but it can do most of what Crystal can though it may not be as "trivial".
Sure you can stick with Crystal and go the ODBC Route but it seems silly to refuse to learn a new product just cause it isn't the same... I am not a saying that right now SSRS isn't a royal pain, but it will move forward with the product as releases come and it will become more integrated and easier to work with as time passes.

So my 2 cents, get as many reports to SSRS as you can, whatever you don't have time to do leave in Crystal and move it over slowly.





Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Apr 21, 2015 at 2:09 PM, Anthony Gercar agercar@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

Not speculation…Or anything I have read. They know it is an issue. It is something that is being addressed.

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 1:57 PM


To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

Â

Â

I’m curious, is this speculation? Or have you heard or read something?

Â

Mike

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

Â

Â

Stick with Crystal…There will be either a replacement for SSRS or SSRS will change…

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Learning curve from Crystal to SSRS

Â

Â

Aside from Jose’s good advice you can also “bridge the gap” during the learning curve by running Crystal still. It works fine and the E9 versions (in a handy .zip file) on EPICweb are easy to make run with the same .XML file sources that feed them. Or use straight SQL ODBC for reports not run from screen selections. Then if you run into a tough conversion to SSRS you can move on to the easier ones on the curve and come back later when more experienced. It’s not a black & white E10 is SSRS only situation and everything you need for Crystal based report styles is available still.

Â

-Todd C.

Â

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, April 21, 2015 11:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Learning curve from Crystal to SSRS

Â

Â

Good morning, group:Â

Â

We are in the process of moving from 8.03 to 10.100.700, and noticed most of the canned reports, while available to edit, are in SSRS.

Â

It seems most task require a little more effort to update or make changes to the standard reports.Â

Â

I'm using the MSSQL Report Builder, is this the recommended software, or is there something else Crystal users recommend using?

Â

We also have several reports customized in Crystal from 8.03. I'm assuming these will need to be recreated or is there a way to convert from .rpt to a SSRS format?

Â

Also, in Crystal you could run a preview mode that populated with actually data from the dB, is this possible in SSRS?

Â

Thanks!

</div>
 


<div style="color:#fff;min-height:0;"></div>

9
Jose, 

You said to find the GUID in the System Monitor or System Agent?  I cannot find this column in either of those after running a preview of the Scheduled Shipments Report.  Can you help?

Thanks.
10
I use the following query to get the GUIDs

SELECT        Company, CreatedOn, RptDescription, RIGHT(REPLACE(FileName, N'-', ''), 32) AS GUID, WorkStationID
FROM            Ice.SysRptLst
ORDER BY CreatedOn DESC

In System Monitor, the GUID is in the FileName field on the Reports Tab

Dan
Independent Components Corp.

11
Got it!

When running SQL Queries, are you using the SQLCMD?  OR just the report SQL Management? 

Thanks!