I am working with Crystal XI.

 

I have created 3 indivitual reports with parameter.

Like Start date, End Date and User.

 

Now the requirement is need to be in single report.

 

I decided to put as a subreport.

 

From Parent report i need to select the 3 fields

Start date, End date and user . After selected these three fields, it should directly assign to all the 3 sub reports.

 

For testing purpose, i have added these 3 indivitual reports as a subreport of the Main report. when i run the report its showing 9 input parameter. 3 input parameter from each reports.

 

Is any other way to fix this issue. i want only 3 input parameters and it should assign to all the 3 subreports.

 

Kindly clear me on this topic and Thanks in advance.

 

 

 

You need to link the main report to three Subreports you have created go to the Subreports individually  then right Click  Select Change Subreport Links

 

Select from Available Fields click > to move to Fields to Link select Subreport Parameter  Field to use from left,

 

if you have no parameters created in subreport Crystal Creates the parameter field such as ?PM-table.fieldname......

 

Check Select Data in Subreport based on Field.

 

First       subreport link Start Date

Second  subreport link Second End Date

Third      subreport link Third User

 

Repeat the steps for all three subreports

 

Cheers

Rahul

 

If your problem is not able to link with mainreport and the Sub report means.

1. Connect table and create the parameter field in Main report.

or

1. Write the query in Command and create the parameter field in Main report.

 

2. Right click on subreport -> Change Subreport link-->

Move the subreport parameter from "Available Fields" to "Fields to link to" list box.

 

3. Select the field from "Fields to link to" Listbox and map the field to "Supreport parameter to use"

What are the parameter field, you have created in main report, it will available in the ""Supreport parameter to use" combo box.

 

The above solution is not working then let us know the problem clearly.

 

 

In Crystal X this approach has worked for me.

 

Follow these steps.

1. Right click subreport and select Subreport links

2. In the left pane (available fields) select your input parameter field and click the right arrow to add it to the right side pane (fields to link to)

3. In the bottom right corner, check the options "Select data in subreport based on field"

4. In the drop down, now select "Report Fields" nothing more.

5. Click OK

6. Go to your subreport and select the record or group filter criteria.

7. You may, or may not see a statement something like this...

"{SO_HEADER.DPT_AUTO_KEY} = {?Pm-DEPARTMENT.DPT_AUTO_KEY}"

in that the parameter field filter was already written for you.... but likely not.

8. however, you should now see your main report parameter field displayed in your "Report Fields" list from which you can choose to filter your sub report data on.

9. Manually write your record or group filter criteria using your newly registered parameter field.

 

NOTE: Let's think about this. A parameter field is defined by you, so Crystal doesn't really know what could be "linkable" to your parameter field. Instead, you must NOT select any of your tables or table fields but choose the "Report Fields" instead. This will add it to your sub report "Report Fields" list as a parameter from which you can manually write your filter statements,etc.

You don't actually add the parameter field to your sub report link.

 

First, do the following.

1. in your main report, create a Formula that copies your parameter field.

For example.

Parameter Field called Start Date / it is a Date Field.

Formual Field called strt_date and its value is {?Start Date}

2. Follow the steps outlined above, but select the formula field called @strt_date (or whatever your field is called)

 

Hope this cause too much confusion, and it is helpful.

The parameter type must match the field type to link to.

 

Learned something myself. Well, the above mentioned "trick" is a way

to pass a parameter value to a sub report when the field types don't match and you cannot link them properly.

 

I find that if I use date time values in parameter fields, my users get pretty annoyed because they don't know what time to put in.

Posted: 09 May 2008 at 12:29pm

 

Read the posts from that point forward and follow those steps exactly.