Linking question? Using two values per record in another report

[tonykblen]

Hi,

I have a report that contains the following

Product Number Value A
Value B

I have another report which I wish to use these values in again on a per product basis. The report needs to take the product number and the two values and return all records between values A and B for that product number and then move on to the next product. There are two problems:

1. How do I get it to pass the values to the second report and how do I associate one with the other?

2. Sometimes value a may not exist. How can I put a placeholder value in instead?

Many thanks,
Tony.

 

[IdoMillet]

Make the second report an "On Demand" subreport with the two values passed in as Links.

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

http://www.MilletSoftware.com

 

[IdoMillet]

Of course, you would also need to link on the Product Number as well.

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

http://www.MilletSoftware.com

 

[tonykblen]

Hi Ido,

As I am a complete newbie when it comes to linking reports can you explain what an on-demand report is and which report should be the sub-report and which one the main report?

Many thanks for your help,

Tony.