Show Clients based on their ID

[rushelp]

I have one big report that has many other reports inside of it. Each report has it's own UNIQUE ID. What I'm trying to do is to show those pages for that unique ID.

For example one ID contains 5 pages report. So if the ID matches it shows only that 5 pages out of 1500 page report.

Is there a formula that can do that?

I just don't want to redo this report and separated into 100 report, and that number keep increasing monthly.

 

[rushelp]

Here's more detail if that post is kind of confusing.

I've wrote a desktop application in C#, which grabs this report opens it in the crystal report viewer. Right now, all 1500 pages are viewable. I have a tab control. In the second tab I have list of Clients Name, and their ID. (ID is unique). And I wrote a checkmark function.

So What I'm trying to is if the checkmark is MARKED convert that report else don't. My convert function already works. It grabs the file and saves it as .pdf with the name I want. But it does for one report ONLY.

So I need to figure out how I can separate those pages based on ID.

Any suggestions?

If you need I can provide my c# code.

 

[IanWaterman]

You can do that at run time of report by using a parameter.

Then in select expert

{ClientID} = {?Parameter}

This will require user to enter ID before running report.

Ian

 

[rushelp]

Could you please explain what should {?Parameter} contain?

 

[IanWaterman]

I used that as an example, just create a parameter of a data type the same as your client ID, then use it in Select expert as I suggested above

Ian

 

[rushelp]

I followed your suggestion and run in to this problem.

First I created parameter {getClientID}, which get the ID and their business name. Then I created a formula enterClientID:
{ContactInfo.ClientID}={?getClientID}

When I run the report within crystal report it asks for clientID to be entered (drop down option on the screen pop).When I enter that, it shows me the first page of the report. If the clientID is equal to that, on that page it will say TRUE, if not FALSE. SO technically it doesn't hide the pages. So I need something that will actually hide them and show only pages for that clientID.

Also, when I first have my enterClientID entered in the design page, it won't let me save so I actually in my report viewer in my C# program I can choose the clientID. But if I choose it in Crystal Report then save it, I'll have TRUE and FALSE options, and I'll have all those pages in Crystal Report viewer.

 

[rushelp]

Little Correction:

I'm now able to see just the information on Selected ClientID. However, when I click SAVE and then go to my crystal report viewer, it will only show that clientID. Is there anyway, I can have the select ID option in my viewere? Or any way around it?

Thanks...