Link to home
Start Free TrialLog in
Avatar of Mosquitoe
MosquitoeFlag for Canada

asked on

Dynamically allowing user to view report, select group from tree and display report

Crystal report within visual studio, programmically connecting to database and opening report.  Lets say it is a generic report showing all vehicle manufactureres and the detail section shows all the different models.  If the user selects a specific manufacturer from the tree on the left, is there any way to keep the tree with all the manufacturer choices, but show only the details for that selection.  Right now, if I select a manufacturer, it will move within the report to where those records are, but the rest of the information remains evident.  Will crystal allow that to be manipulated?  I thought of sub reports, or hiding or suppressing but hope someone would have some clear concise direction to give me.  Is this just an issue of how I format vs, being able to programmically set how the info displays?
Avatar of Mike McCracken
Mike McCracken

Could you control the display from an applicationi?
You could prompt the user for the manufactirer and then display just that information in the report.

For a Crystal solution
You could put all the details for each manufacturer in an ON DEMAND subreport.  Then when you choose from the group tree, the user willthen be able to click on the subreport and get it displayed separately.

mlmcc
Avatar of Mosquitoe

ASKER



I had thought of that - What I am really wondering is if I am correct that within Crystal, once you have a report set up to display all the records, there is no way to keep just the groups in the tree and disply only their records in the main display.  A user would HAVE to doubleclick on the sub-report to open it separately - I'm correct right?
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin