Group Code Description in Crystal Report

[jbaldO]

Hi,
I am trying to create a report in crystal version 9 with a structure similar to

Group : xxxxxxxx xxx--description--xxx
Detail line
Detail Line

Is there a way of getting the description of the group code without linking the group's reference table to the main data table? Something like a SQL or whatever that i could run in the group section just to get the group code description.

Thanks.

 

[synapsevampire]

Maybe, but that would depend upon your database and connectivity, and statements such as "like a SL or whether" don't help.

-k

 

[jbaldO]

Im using progress database and connecting to it via odbc.
thanks.

 

[lbass]

Why NOT link to the lookup table? You could still group on the code and then in the group options, set up the groupname to be based on the description field in the lookup table.

-LB

 

[jbaldO]

Hi, the reason why i dont want to link to the lookup table is because the lookup table is on another data source.
i noticed that reports are slow when linking tables from different data sources.

-thanks.

 

[Madawc]

I don't think there's a way round, except by using subreports, which are also slow.

What I did in one report was to get some values from another database using a subreport in the report header, then pass the values to the main report using Shared Variables and use them later on as data items. This only worked because there were a small number of them, of course.

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

 

[Madawc]

PS. As well as the method I described, you can put a subreport in the group header to get extra data. But it may well be even slower than a link.

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

 

[lbass]

I would use the subreport approach then, and link the subreport on the matching field. This shouldn't be too slow.

-LB

 

[jbaldO]

Thanks guys, used the subreport and speed is alright. Thanks heaps.