Pulling data from one crystal report to put in another report...

[rschlee]

Is there any way to pull data from a crystal report into another crystal report? I have a left outer join but need to put a select criteria on one of the fields in the right table of that join. Does anyone have any ideas for me? Thanks!

 

[BillGeake]

If you can make one report the main report, and the other a sub report of this, you can pass the values around by using Shared variables.

In a formula in the main report, declare a variable thus (Basic syntax):

Shared MyVar as Number (or whatever)

and then set MyVar to the value you want to pass to the sub report. Then, in a formula in the sub report, declare the variable in exactly the same way (same name and data type) and the value will be passed.

Also, search in this forum on "Shared" - that's how I learnt to do this.

Bill.

 

[rune]

Remember to place your subreport so it prints before the data you want (use: "add section below&quot in your mainreport. If your data is incorrect, use the "evaluate after ()" option in the formula editor.

Rune Flaathen
SNT-Norway