Parameter subreport

[jbarbato]

I am using crystal reports XI.

I have a report that lists parent packages with their package types, and children packages with thier package types:

Parent Package: 7865 Type: SYS
Child Package: 8979 Type: ROS
Parent Package: 8934 Type: SYS
Child Package: 9653 Type: PID
Child Package: 8736 Type: PID

This is an extremely watered down version of the report that i am giving as an example = there is much more data involved that justifies the use of a subreport.

I have a with the same parameters as the main report - I am using formulas so that if a user selects a blank space, everything is returned. otherwise, only the matching values should appear. I linked the package type field in the subreport to the parameter in the main report, but it is not working. can anyone help? thanks!

 

[IdoMillet]

it is not working" in what sense?
What data is expected and how is the actual data different?
What is the record selection formula in subreport?

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jbarbato]

Currently I have the following code in the select expert:

In the main report:
(If {?Package_Type} = "" Then True
Else {?Package_Type} = {ParentPackage.Package_Type})

In the subreport:
If {?Pm-?Package_Type} = "" Then True
else {?Pm-?Package_Type}= {ChildPackage.CPACKAGE_TYPE}

If I do not enter anything, all packages should appear. If I set ?Package_Type = SYS and PID, The output should be:

Parent Package: 7865 Type: SYS
Parent Package: 8934 Type: SYS
Child Package: 9653 Type: PID
Child Package: 8736 Type: PID

It is not working - None of the child packages are showing up.

 

[jbarbato]

Thank you for your help - i solved the problem... it was a completely unrelated issue. thanks again!

 

[IdoMillet]

Check the table joins in the subreport.

What happens when you completely comment out the record selection formula in the subreport? Still no records?

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com