Passing parameters to a subreport - A new twist

[eizatt]

Hi,

I need to pass a beginning and ending date parameters to a supreport. The problem is that the datasource for the subreport is a SQL command. The command builder will let you define parameters for the command but I can't see a way of using the linked parameters from the main report. Anyone have an idea?

Thanks'
Ed

 

[SmpTraining]

Sounds like your SQL command will have to remain 'as is' but you should still be able to add a selection criteria to include the parameterized date ranges. This will ensure only the correct records are included in the report.


Steve Phillips, Crystal Consultant

 

[eizatt]

The problem with that solution is that the report will ask for the date parameters twice. Once on the main report and once for the parameters in the command.

 

[SmpTraining]

No it won't. I'm not suggesting you create a second set of parameters in the subreport - only that you use the linked parameters.

If this doesn't make sense can you explain how you are going about this in a little more detail. You should be able to pass the main report's parameters to the subreport on the subreport links tab. These can be used to select the data in the subreport.

Steve Phillips, Crystal Consultant

 

[synapsevampire]

Since you have the ability to use a SQL Command, can't you design the SQL to return all data in one report using a subquery?

-k

 

[SmpTraining]

I've tried this out now and it works.

1. Create a formula on the main report to set a shared variable equal to the parameter - DO NOT USE WhilePrintingRecords!

2. In the Subreport, Create a formula to pick up the shared variable (display it on the subreport to test)

3. In the subreport's select expert you can use the formula from step 2 to restrict the records

Steve Phillips, Crystal Consultant

 

[eizatt]

Thnaks Steve,

I'm going to give it a try.

Ed