Sub Report Linking

[Former Member]

I am trying to make a bill of materials. I can go down 2 levels by linking the main report with the sub report. The problem I have is that some items from the sub report have a parts list attached to them. I am thinking if I can link the sub report to another sub report, I can pull this list.

Is it possible to link sub report # 1 and sub report # 2?

[Former Member · Accepted solution]

Crystal Reports does not support subreports within subreports.

If you can link all your tables why not a simple drill-down report (drilling down from group to group) or if that isn't an option - possibly a stored procedure pulling in the right data so that you can do it all from one report using the SP as the data source.

[Former Member · Accepted solution]

A stored procedure is probably above my skill level and a drill down report isn't a real option.... I don't think. I will have to check that out.

Thanks for your input.

[Former Member · Accepted solution]

Hi Travis,

I think by using shared variables we can link the two subreports.

Try to get the value from subreport 1 to main report via shared variable and use thi variable to link to the sureport 2.

I hope this would help!

Raghavendra

[Former Member · Accepted solution]

Raghavendra

I tried your suggestion, but it only passes 1 shared stringvar to the main report. Is there a way to pass a list?

[Former Member · Accepted solution]

Try creating an array in subreport1 and use that array in subreport 2 by passing list using linked parameter and accordingly change the record selection formula in subreport 2. If your subreport1 is passing only one value then you can link dirrectly to the subreport or if you are able to pass the list then just pass it to the subreport 2 since it is a shared variable you need not link the array where you can directly use shared variable in record selection like

field in join(array,",") something like this.

Regards,

Raghavendra