Linking Subreports

[glasper]

Hello

I need to create a report that will contain county and salesman information which isn't in my db. The user will be able to prompt for customer info by product which will in turn engage a subreport which will include county and sales rep information.

My primary report which will include product and customer information will come from my db (SQL)but the county and sales rep info will be shown in a subreport.

Since the county information is only available as Excel, I decided to imported it into Access because it seems that Access is a better db source than Excel and then created a Crystal Report from that. I thought it would work out better if they both spoke Crystal.

In any event, I have a subreport created in Crystal Report that shows all of the information from my Access db that I'd like to include in my Crystal report (v11.0.0).

I created the primary CR report, inserted the subreport described above into the primary report, linking on State as this is the only field both reports have in commom.

When I run my Primary report nothing is displayed in the subreport. I thought that something was wrong with the subreport so I ran it as stand alone report and all of the information was displayed.

I even tried changing my prompts on the primary report and it still didn't work. The last step was to confirm that both State fields were the same length and they are so; now I'm at a loss.

Is this type of report possible? Very frustrated.

 

[lbass]

The primary report is not a subreport itself, is it?

In what report section did you place the subreport?

Are the state fields the same case?

-LB

 

[glasper]

I created two separate reports (A and B), one of which is used as a subreport. I inserted the report B into report A in the report footer.

Both reports are using two letters for the state. I even changed the string length of report by to match that of report A.

Thanks for responding.

 

[lbass]

I asked about case, not length. The case should be the same for the states. If you are placing the subreport in the report footer and linking on state, then only the last state in primary report would appear in the subreport--which is okay if you are only running the report for one state at a time.

If you have a group on state in the main report, then place the sub in a group section.

-LB