Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Topic: Help:Converting Access report to Crystal report Posted: 29 Oct 2009 at 1:05pm
Hello Folks,
I have a report in Access which i need to recreate from the scratch in crystal reports. I dont know how to proceed coz the access report query comes from 4 tabes and i have no clue how to and where to start. Do i need to create a procedure and create a crystal report off the procedure or do i need to create a command and then design the report.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 30 Oct 2009 at 6:28am
You can create a stored proc, that is my preference, the other method is to create a report using the report wizard and select the 4 tables that you need and link them as needed and then place the columns on the report as desired. Using the command is not recommended, IMO as it was designed to assist in the population of parameters, and I am guessing that you will want to use parameters to make your report more robust, CR just doesn't work well.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 03 Nov 2009 at 6:13am
I'm not sure about Oracle, but for SQL server it would be
ISNULL(Principal,0)-ISNULL(Protated_tranamt,0)
the isnull function in SQL Server takes the first argument, and if it is null, uses the second argument instead. COALESCE does the same thing, but you can have a whole string of arguments.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
