crystal report for .net - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>DotNet - 窗口里的风景

crystal report for .net

crystal report for .net# DotNet - 窗口里的风景

k*i2003-12-08 08:12

1 楼

Does anyone have experience on reporting from large dataset(say,>10,000 rows)
using crystal report? What's the best way to deal with it?Especially in web
applicaton? Is there any propery in crystal report viewer or document that can
be set to let the report only fetch partial data needed by that page? I know
there is a SeperatePages property but don't know whether it will do the things
I want.

L*r2003-12-08 08:12

2 楼

Could you use dataset to do this kind of "window" thing?
If one is not enough, how aobut two? One to store large data set. One to store
some small set. :)
Just my thought.

rows)
can
things

【在 k****i 的大作中提到】

: Does anyone have experience on reporting from large dataset(say,>10,000 rows)
: using crystal report? What's the best way to deal with it?Especially in web
: applicaton? Is there any propery in crystal report viewer or document that can
: be set to let the report only fetch partial data needed by that page? I know
: there is a SeperatePages property but don't know whether it will do the things
: I want.

k*i2003-12-08 08:12

3 楼

I did think about this way but seemed it's not a good way.
Basically reports have total filed or sub total for each group.You won't want
to do a lot of calculation in the code first like the number of the groups
that will be generated and put each group in different dataset,or calculate
the total and store it within the dataset and pass it to the report.It can be
done but just cumbersome.I still want to let crystal report handles these
things.

store
web
know

【在 L*******r 的大作中提到】

: Could you use dataset to do this kind of "window" thing?
: If one is not enough, how aobut two? One to store large data set. One to store
: some small set. :)
: Just my thought.
:
: rows)
: can
: things

b*e2003-12-08 08:12

4 楼

If this is for multiple user, and the data doesn't change very often,
how about save/cache the report in a centralized place.
I heard that the newer version of crytal report has this feature (not
the version comes with VS.NET).

rows)
can
things

【在 k****i 的大作中提到】

C*n2003-12-08 08:12

5 楼

I hate Crystal Report.

web
know

【在 b*e 的大作中提到】

: If this is for multiple user, and the data doesn't change very often,
: how about save/cache the report in a centralized place.
: I heard that the newer version of crytal report has this feature (not
: the version comes with VS.NET).
:
: rows)
: can
: things

m*i2003-12-08 08:12

6 楼

Active Report is better and much cheaper.

that

【在 C****n 的大作中提到】

: I hate Crystal Report.
:
: web
: know

k*i2003-12-08 08:12

7 楼

What do you mean the save report doesn't come with vs.net?Actually I can
export the report to disk filled with data in many formats like
.rpt,.doc,.rdf.The problem right now is it looks like crystal report can't
handle such large dataset(>50M) and always give me out of memory error though
I have enough physical and virtual memory.
【在 bee (只会嗡嗡叫的蜜蜂) 的大作中提到: 】
web
know

b*e2003-12-08 08:12

8 楼

so u are using ADO.NET dataset, right?
Have u tried to connect from Crystal Report to your database directly?
Also you may try to divide the big report to many sub-reports.
It doesn't make much sense put all 10,000 rows in a single report.

【在 k****i 的大作中提到】

: What do you mean the save report doesn't come with vs.net?Actually I can
: export the report to disk filled with data in many formats like
: .rpt,.doc,.rdf.The problem right now is it looks like crystal report can't
: handle such large dataset(>50M) and always give me out of memory error though
: I have enough physical and virtual memory.
: 【在 bee (只会嗡嗡叫的蜜蜂) 的大作中提到: 】
: web
: know

b*e2003-12-08 08:12

9 楼

Please tell us something about Active Report.
Is it really better in terms of report designing, compatibility with
.NET, exporting to pdf, and print formatting?

【在 m****i 的大作中提到】

: Active Report is better and much cheaper.
:
: that

m*i2003-12-08 08:12

10 楼

i used its .net version for more than 1 yr and its previous version for 2
years, they're pretty good. i'm not doing a commercial here but i do know
quite a few ppl switch from crystal to this (and they have a wizard to
convert).
it supports pdf, excel, html, rdf, rtf formats. pdf is the best. excel is
basically a text-to-text conversion, but they have a spreadsheet builder class
if you need to more controls over data types, format, groupings, etc. the
reports can be exported either to files or m

【在 b*e 的大作中提到】

: Please tell us something about Active Report.
: Is it really better in terms of report designing, compatibility with
: .NET, exporting to pdf, and print formatting?

b*e2003-12-08 08:12

11 楼

Thanks.
Definitely will take a look at it sometime.

class

【在 m****i 的大作中提到】

: i used its .net version for more than 1 yr and its previous version for 2
: years, they're pretty good. i'm not doing a commercial here but i do know
: quite a few ppl switch from crystal to this (and they have a wizard to
: convert).
: it supports pdf, excel, html, rdf, rtf formats. pdf is the best. excel is
: basically a text-to-text conversion, but they have a spreadsheet builder class
: if you need to more controls over data types, format, groupings, etc. the
: reports can be exported either to files or m