Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Dynamic Field selction to show in CR Post Reply Post New Topic
Author Message
arunesh
Newbie
Newbie


Joined: 28 Dec 2007
Location: India
Online Status: Offline
Posts: 1
Quote arunesh Replybullet Topic: Dynamic Field selction to show in CR
    Posted: 28 Dec 2007 at 2:48am
Hi
 
Any bodys know how to assign the field where user to select the data fields and get the report
 
and how to frame the report
 
Regards
Arunesh
 
Arunesh
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 28 Dec 2007 at 4:51am
Are you talking about selecting which fields to display, or which records to display?  Either way, you are likely to want parameter fields to control it.

If you are looking to restrict records, then this is a simple matter of putting the parameter fields in the Select Expert.

If you are looking to modify which fields display, it's a little trickier.  You can put a whole series of parameter fields to select or deselect whether or not various fields are displayed.  You can even put a formula in the Size and Position criteria to move the fields, so there isn't a lot of blank space.  However, this is tedious to build, and generally tedious for the user to navigate as well.

A much better solution is to identify a few common groupings of fields.  E.g., a manager's view, a technician's view, an accountant's view, etc.  Set a parameter field to indicate which view you want.  Then, create a separate details section (and usually page header section, with the column labels) for each view.  This allows you to format everything nicely.  Then, simply suppress all of the detail sections except the one selected in the parameter.

There are also additional ways to do this with a .Net wrapper, but I leave those answers to Brian, if you need them.


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.031 seconds.