Using Sub-report to get the fields

[maas]

Hello everybody,

I tried to build a report that has deals number and parties.

There is a master table for deals and party table.For each deal, I am trying to get the party name from party table.

The problem is that I linked too many tables together and while running the report, it gives database vendor error 1445 and I could not resolve the issue.

So, I thought to create a subreport that has deal no and party and pass the party as a shared value to the main report.

I will pass the deal no as a parameter.

Is this practise can be applied and will show the party for each deal?

Best Regards

 

[Madawc]

Shared variables pass data from a subreport to the main report, where they are usable in the next section after the section with the subreport.

To pass data from the main report to a subreport, use Edit > Subreport Links. You'll find that the linked fields will also have been added as a rule in the subreport record selection. You can remove or change this rule if you like.

Subreports at detail-line level are inefficient, but the database has hit its limits then I suppose you have no choice. Expect the runs to slow down a lot.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[maas]

Thanks