Passing Parameters

[Former Member]

Hi All,

I need some help from experts.

I am migrating reports from BIRT to crystal reports.

I have a report contains 2 command objects.

One command object contains From time,to time as min value and max value and Another command object contains From time and to time parameters ,some sales fields.

The from time and to time parameters of 2nd command objects are actually passing from First command objects  From time,to time in BIRT.I am using the same query in crystal also.

I think we don't have such option in crystal reports to pass parameters from one query to other.

So now what is my requirement is i need to show the sales fields based on time in 1st query.In BIRT even if they have parameters called from time to time in query when we execute the report it is not showing the parameters. because they are passing internally from one query to another.

Like that i need to achieve requirement.

Can any one please suggest me an approach.

Please find the queries and design  of BIRT

Hoursegment.txt.zip

Actual sum data.txt.zip

[abhilash_kumar]

Hi Divya,

You can insert a Subreport and use the 2nd command object as the datasource for this Subreport.

This way you link the parameters from the 1st query to the parameters in the query of the Subreport.

-Abhilash

[Former Member]

Hi Abhilash,

I don't want to show the from time and to time parameters when we run the report.I mean it should not ask for entering from time and to time.It should be pass internally .Can it be possible by the method you suggested.Please Suggest

[abhilash_kumar]

Hi Divya,

It will ask you once - to run the 1st command and then pass that info over to the 2nd command object to bring back records in the Subreport.

If you do now wish to be prompted at all, then you would need to add both the command objects in separate subreports and create a formula in the Main Report that will pass the From and to Date to both these sources.

-Abhilash