Linking subreports parameter: int or string?

[olitvinov]

Does anybody know perfomance wise if
linking main report to subreports on integer improve compare to string? if it would, by how much?

I'm running Crystal XI and on the web page.
Linking is at detail level.
On the page I first collect all data in datasets and then
Set data source for each subreport and to main report.

When having considerably more data, getting datasets doesn't take much time, but for Crystal to link and display on the page takes long time. (crystalreportviewer is used to display report)

Does anybody has experience with it or experimented linking on integer type compared to string type?

Thanks,
Oleg

 

[synapsevampire]

Since you're LINKING to subreports, it probably isn't a significant difference.

Your post contradicts itself I think, if you're collecting the datasets it would be PRIOR to page 1, and if you've collected them, why would you use linking?

Subreports are generally a bad idea, and obviously you've posted nothing about where the subreport are within the main report, nor what they are linked to so I can't advise you.

I would suggest eliminating the subreports and making it a single recordset if possible (view or Stored Procedure, who knows, you ask about database issues and you don't even bother to post what database you're using).

If you are collecting data sets, then that means that you are doing so OUTSIDE of Crystal, so post what products are being used for this as well, saying on the web page is as meaningful as saying on the monitor...

-k

 

[olitvinov]

Just to make clear, I don't display links on the page, report has links from main report to subreports.

The reason for linking is that I use further grouping in each subreport. How else would I display multiple subsections in this format.

Main
Detail/Item1,Item2,Item3,Item4

sub1
group by Item2, station
display:
station name(group section)
detail, detail, detail (detail section)
station name(group section)
detail, detail, detail(detail section)

then sub2
group by Item2, station
display:
station name
detail, detail, detail
station name
detail, detail, detail

and so go 6 more subreports.

-I use SQL Server 2000 database.

-"if you've collected them, why would you use linking?"
I'm not linking datasets, report does. I just set each subreport and main report with datasets. One for each.

Now, since in the report linking is done using a field of type string, there was my concern. Would it be better if I linked using field of an integer type? That is all.

Is there a difference there?
I would test it myself quckly if it wouldn't involve changing 8 stored procedures.

Thanks again,
Oleg