Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: 14 versions of same report Post Reply Post New Topic
Author Message
jazzgirl
Newbie
Newbie
Avatar

Joined: 21 Mar 2009
Location: United States
Online Status: Offline
Posts: 3
Quote jazzgirl Replybullet Topic: 14 versions of same report
    Posted: 21 Mar 2009 at 10:00pm
  I am new to working with crystal reports. I would like to know way(s) to  write 14 similar detail reports.
  I will be passing parameters from a vb.net windows application to a crystal report that will have 14 detail reports that are similar but the columns may be different based upon the selection category passed by the parameters.  Each version of the detail reports will be similar but vary depending upon the category that is selected.
  The reports will only one one major selection criteria on them. These reports will be emailed out to each user user the request the detail infomation.
  Thus is there a way with crystal reports to have the reports similar but different based upon one major selction criteria? This would be similar to using cascading styles sheets on the web or writing a .net method that has the same name, but different parameters that can be passed to the 'methods' in .net.
 
   Thanks!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Mar 2009 at 5:37pm
One way to handle this would be to create formulas for your columns so that they change based on the selected parameter.rate your paramter fied and define the options then create the formual around that.
Column 1 as: if {?parameter}="A" then table.field1 else if {?parameter}="B" then table.field2 else if {?parameter}="C" then table.field3 else if etc.
You can make as many column formulas as needed for the columns that shift based on your selection criteria.
You can also do the same thing for groups or header text, etc.
IP IP Logged
jazzgirl
Newbie
Newbie
Avatar

Joined: 21 Mar 2009
Location: United States
Online Status: Offline
Posts: 3
Quote jazzgirl Replybullet Posted: 22 Mar 2009 at 8:06pm

Thank you for this information! However can you tell me what other options are there?

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Mar 2009 at 6:27am
Another option, but it is in the same vein of DBlank's is to write 14 detail sections and whatever else is needed and then suppress all of them except the one desired.  You would probably still need to write formula for the headers to appear correctly or you could create as many as needed and suppress them.
 
Unfortunately, no matter how you go, there are going to be lots of details (no pun intended) to keep track of.  You need to define the template for Crystal to plug in the values to, before you call the report from your app.
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.047 seconds.