Notes on my evaluation of Crystal Reports.NET 
Author Message
 Notes on my evaluation of Crystal Reports.NET

I just finished a two week evaluation of Crystal Reports.NET.  Along the way
I used usenet to get a lot of anwers to my questions.  During that time many
people asked that I post my results, good or bad, so here it is.  Just
wanted to say thanks to everyone who helped my out during this evaluation,
it's been fun :)

Strong Points:
- Many export Export Formats
    - Adobe Acrobat (.pdf)
    - Crystal Reports for Visual Studio .NET (.rpt)
    - HTML 3.2 and 4.0 (.html)
    - Microsoft Excel (.xls)
    - Microsoft Rich Text (.rtf)
    - Microsoft Word (.doc)
- Greater ability to group, sort and cross tab data
- Conditional formatting,
    - Make this value red when a certain condition is met, good for
thresholds, combined with parameter passing this could be very powerful
- Page based statistics such as charts, subtotals
- Suppress if duplicated
- technical support is excellent and timely
- re-use exact same rpt files in web aspx page
- has a limited object model so that the report can be changed
programmatically
- Web based formatting is very good
- Can load reports from files against a base class, extensible

Known limitations and problems:
- licensing is unclear when talking about a "Automated Distribution System"
    - depending on what Crystal says about this issue, it could send my
costs through the roof and destroy my product's price point.  Therefore, it
would be a no go.
- blank columns seem not to be output well, throws off the entire column
ordering
- export to Excel does not hold landscape setting, all other export formats
do
    - reproduced by CR Tech support, incident is tracked, if lucky will be
VS.NET SP1  that may ship in June
- Column suppression cannot be done, a hack may do it but presentation
quality would seriously suffer
- Cannot set the text on chart legends
    - Can create chart with Chart Analyzer in 8.5 and then bring into .NET,
however, this is a one way street.
    - 8.5 and .NET will be compatible in SP1 (maybe)
- Event log reporting, NOT SUPPORTED IN .NET
- IIS Log reporting, NOT SUPPORTED IN .NET
- Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
- Cannot load a bitmap dynamically
- Doesn't seem to understand System.Globalization namespace what so ever,
means that dates have to passed in as strings.  This may affect a report
where you want to do cool grouping on dates etc.
    - due to fact that communication with CR engine is done on a background
thread
    - CR says that this may be addressed in the future
- Formatting is a little weak, cannot put border around the logical
sections, header, details, footer etc.
- Each of our customers must register with Crystal Reports, we can do this
for them, however, it is more maintenance for us
- Int and Fix don't seem to work in formulas, despite formatting the column
properly

Below are the topics of some working notes I made, I would happy to post any
particular one if somebody wants it.  Posting it all at once would be a
little brutal.
- Steps to create a report
- How to add a column to a report
- How to work with time based hh:mm:ss columns
- How to pass data into the report
- How to export to HTML
- How to submit a tech support incident
- How to underlay a large image as a watermark for the details section
- How to prevent column (page) headers from appearing on chart page
- How to add alternating background row colors
- How to create a time string
- How to add a parameter

Notes on formatting:
- Beware of formatting multiple objects, formulas may be copied or
overridden.
- Font size less than 8 is possible, although the font size box will still
show 8.

--
Robert Chapman, MCSD
Manager, Applications Development
prairieFyre Software Inc.
http://www.*-*-*.com/



Sat, 21 Aug 2004 05:32:53 GMT  
 Notes on my evaluation of Crystal Reports.NET

Quote:
>- Each of our customers must register with Crystal Reports, we can do this
>for them, however, it is more maintenance for us

Sorry I dont understand this one; Is it the type of app you are creating
that requires this. or are you saying that if we create reports using
crystal.net in a winform app the user of that app has to register the report
viewer! ( i am presuming you have to pay for this)

What happens if you put a report viewer in a Web Application!!!

What happens if you create an interface that allows a user to create a
report dynamically (i understand that you can do this with crystal)

Colin


Quote:
> I just finished a two week evaluation of Crystal Reports.NET.  Along the
way
> I used usenet to get a lot of anwers to my questions.  During that time
many
> people asked that I post my results, good or bad, so here it is.  Just
> wanted to say thanks to everyone who helped my out during this evaluation,
> it's been fun :)

> Strong Points:
> - Many export Export Formats
>     - Adobe Acrobat (.pdf)
>     - Crystal Reports for Visual Studio .NET (.rpt)
>     - HTML 3.2 and 4.0 (.html)
>     - Microsoft Excel (.xls)
>     - Microsoft Rich Text (.rtf)
>     - Microsoft Word (.doc)
> - Greater ability to group, sort and cross tab data
> - Conditional formatting,
>     - Make this value red when a certain condition is met, good for
> thresholds, combined with parameter passing this could be very powerful
> - Page based statistics such as charts, subtotals
> - Suppress if duplicated
> - technical support is excellent and timely
> - re-use exact same rpt files in web aspx page
> - has a limited object model so that the report can be changed
> programmatically
> - Web based formatting is very good
> - Can load reports from files against a base class, extensible

> Known limitations and problems:
> - licensing is unclear when talking about a "Automated Distribution
System"
>     - depending on what Crystal says about this issue, it could send my
> costs through the roof and destroy my product's price point.  Therefore,
it
> would be a no go.
> - blank columns seem not to be output well, throws off the entire column
> ordering
> - export to Excel does not hold landscape setting, all other export
formats
> do
>     - reproduced by CR Tech support, incident is tracked, if lucky will be
> VS.NET SP1  that may ship in June
> - Column suppression cannot be done, a hack may do it but presentation
> quality would seriously suffer
> - Cannot set the text on chart legends
>     - Can create chart with Chart Analyzer in 8.5 and then bring into
.NET,
> however, this is a one way street.
>     - 8.5 and .NET will be compatible in SP1 (maybe)
> - Event log reporting, NOT SUPPORTED IN .NET
> - IIS Log reporting, NOT SUPPORTED IN .NET
> - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> - Cannot load a bitmap dynamically
> - Doesn't seem to understand System.Globalization namespace what so ever,
> means that dates have to passed in as strings.  This may affect a report
> where you want to do cool grouping on dates etc.
>     - due to fact that communication with CR engine is done on a
background
> thread
>     - CR says that this may be addressed in the future
> - Formatting is a little weak, cannot put border around the logical
> sections, header, details, footer etc.
> - Each of our customers must register with Crystal Reports, we can do this
> for them, however, it is more maintenance for us
> - Int and Fix don't seem to work in formulas, despite formatting the
column
> properly

> Below are the topics of some working notes I made, I would happy to post
any
> particular one if somebody wants it.  Posting it all at once would be a
> little brutal.
> - Steps to create a report
> - How to add a column to a report
> - How to work with time based hh:mm:ss columns
> - How to pass data into the report
> - How to export to HTML
> - How to submit a tech support incident
> - How to underlay a large image as a watermark for the details section
> - How to prevent column (page) headers from appearing on chart page
> - How to add alternating background row colors
> - How to create a time string
> - How to add a parameter

> Notes on formatting:
> - Beware of formatting multiple objects, formulas may be copied or
> overridden.
> - Font size less than 8 is possible, although the font size box will still
> show 8.

> --
> Robert Chapman, MCSD
> Manager, Applications Development
> prairieFyre Software Inc.
> http://www.prairiefyre.com



Sat, 21 Aug 2004 06:11:47 GMT  
 Notes on my evaluation of Crystal Reports.NET
Great notes Robert! You did a very thorough evaluation. I'm sure many people
will appreciate it and use it in their own evaluations.

Thanks for sharing this with all of us.

~Brian


Quote:
> I just finished a two week evaluation of Crystal Reports.NET.  Along the
way
> I used usenet to get a lot of anwers to my questions.  During that time
many
> people asked that I post my results, good or bad, so here it is.  Just
> wanted to say thanks to everyone who helped my out during this evaluation,
> it's been fun :)

> Strong Points:
> - Many export Export Formats
>     - Adobe Acrobat (.pdf)
>     - Crystal Reports for Visual Studio .NET (.rpt)
>     - HTML 3.2 and 4.0 (.html)
>     - Microsoft Excel (.xls)
>     - Microsoft Rich Text (.rtf)
>     - Microsoft Word (.doc)
> - Greater ability to group, sort and cross tab data
> - Conditional formatting,
>     - Make this value red when a certain condition is met, good for
> thresholds, combined with parameter passing this could be very powerful
> - Page based statistics such as charts, subtotals
> - Suppress if duplicated
> - technical support is excellent and timely
> - re-use exact same rpt files in web aspx page
> - has a limited object model so that the report can be changed
> programmatically
> - Web based formatting is very good
> - Can load reports from files against a base class, extensible

> Known limitations and problems:
> - licensing is unclear when talking about a "Automated Distribution
System"
>     - depending on what Crystal says about this issue, it could send my
> costs through the roof and destroy my product's price point.  Therefore,
it
> would be a no go.
> - blank columns seem not to be output well, throws off the entire column
> ordering
> - export to Excel does not hold landscape setting, all other export
formats
> do
>     - reproduced by CR Tech support, incident is tracked, if lucky will be
> VS.NET SP1  that may ship in June
> - Column suppression cannot be done, a hack may do it but presentation
> quality would seriously suffer
> - Cannot set the text on chart legends
>     - Can create chart with Chart Analyzer in 8.5 and then bring into
.NET,
> however, this is a one way street.
>     - 8.5 and .NET will be compatible in SP1 (maybe)
> - Event log reporting, NOT SUPPORTED IN .NET
> - IIS Log reporting, NOT SUPPORTED IN .NET
> - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> - Cannot load a bitmap dynamically
> - Doesn't seem to understand System.Globalization namespace what so ever,
> means that dates have to passed in as strings.  This may affect a report
> where you want to do cool grouping on dates etc.
>     - due to fact that communication with CR engine is done on a
background
> thread
>     - CR says that this may be addressed in the future
> - Formatting is a little weak, cannot put border around the logical
> sections, header, details, footer etc.
> - Each of our customers must register with Crystal Reports, we can do this
> for them, however, it is more maintenance for us
> - Int and Fix don't seem to work in formulas, despite formatting the
column
> properly

> Below are the topics of some working notes I made, I would happy to post
any
> particular one if somebody wants it.  Posting it all at once would be a
> little brutal.
> - Steps to create a report
> - How to add a column to a report
> - How to work with time based hh:mm:ss columns
> - How to pass data into the report
> - How to export to HTML
> - How to submit a tech support incident
> - How to underlay a large image as a watermark for the details section
> - How to prevent column (page) headers from appearing on chart page
> - How to add alternating background row colors
> - How to create a time string
> - How to add a parameter

> Notes on formatting:
> - Beware of formatting multiple objects, formulas may be copied or
> overridden.
> - Font size less than 8 is possible, although the font size box will still
> show 8.

> --
> Robert Chapman, MCSD
> Manager, Applications Development
> prairieFyre Software Inc.
> http://www.prairiefyre.com



Sat, 21 Aug 2004 06:37:40 GMT  
 Notes on my evaluation of Crystal Reports.NET

Quote:
> - licensing is unclear when talking about a "Automated Distribution
System"
>     - depending on what Crystal says about this issue, it could send my
> costs through the roof and destroy my product's price point.  Therefore,
it
> would be a no go.

Have you found an alternative product?

Quote:
> - Each of our customers must register with Crystal Reports, we can do this
> for them, however, it is more maintenance for us

Whoa!  Were did you find that out?  I'll reread the licensing again but I
missed that entirely.  That makes it showstopper for us.


Sat, 21 Aug 2004 11:51:47 GMT  
 Notes on my evaluation of Crystal Reports.NET
Are you sure the requirement to obtain permission from CR before shipping
your web app. to a 3rd party isn't just a one-time thing?  From the
licensing it sounds like it.  But now I'm worried because it COULD be
contrued to mean each and every time you ship your app. to someone.

Guess I'll have to contact the CR people.



Sat, 21 Aug 2004 12:03:03 GMT  
 Notes on my evaluation of Crystal Reports.NET
See my correction.

--
Robert Chapman, MCSD
Manager, Applications Development
prairieFyre Software Inc.
http://www.prairiefyre.com

Quote:

> >- Each of our customers must register with Crystal Reports, we can do
this
> >for them, however, it is more maintenance for us

> Sorry I dont understand this one; Is it the type of app you are creating
> that requires this. or are you saying that if we create reports using
> crystal.net in a winform app the user of that app has to register the
report
> viewer! ( i am presuming you have to pay for this)

> What happens if you put a report viewer in a Web Application!!!

> What happens if you create an interface that allows a user to create a
> report dynamically (i understand that you can do this with crystal)

> Colin



> > I just finished a two week evaluation of Crystal Reports.NET.  Along the
> way
> > I used usenet to get a lot of anwers to my questions.  During that time
> many
> > people asked that I post my results, good or bad, so here it is.  Just
> > wanted to say thanks to everyone who helped my out during this
evaluation,
> > it's been fun :)

> > Strong Points:
> > - Many export Export Formats
> >     - Adobe Acrobat (.pdf)
> >     - Crystal Reports for Visual Studio .NET (.rpt)
> >     - HTML 3.2 and 4.0 (.html)
> >     - Microsoft Excel (.xls)
> >     - Microsoft Rich Text (.rtf)
> >     - Microsoft Word (.doc)
> > - Greater ability to group, sort and cross tab data
> > - Conditional formatting,
> >     - Make this value red when a certain condition is met, good for
> > thresholds, combined with parameter passing this could be very powerful
> > - Page based statistics such as charts, subtotals
> > - Suppress if duplicated
> > - technical support is excellent and timely
> > - re-use exact same rpt files in web aspx page
> > - has a limited object model so that the report can be changed
> > programmatically
> > - Web based formatting is very good
> > - Can load reports from files against a base class, extensible

> > Known limitations and problems:
> > - licensing is unclear when talking about a "Automated Distribution
> System"
> >     - depending on what Crystal says about this issue, it could send my
> > costs through the roof and destroy my product's price point.  Therefore,
> it
> > would be a no go.
> > - blank columns seem not to be output well, throws off the entire column
> > ordering
> > - export to Excel does not hold landscape setting, all other export
> formats
> > do
> >     - reproduced by CR Tech support, incident is tracked, if lucky will
be
> > VS.NET SP1  that may ship in June
> > - Column suppression cannot be done, a hack may do it but presentation
> > quality would seriously suffer
> > - Cannot set the text on chart legends
> >     - Can create chart with Chart Analyzer in 8.5 and then bring into
> .NET,
> > however, this is a one way street.
> >     - 8.5 and .NET will be compatible in SP1 (maybe)
> > - Event log reporting, NOT SUPPORTED IN .NET
> > - IIS Log reporting, NOT SUPPORTED IN .NET
> > - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> > - Cannot load a bitmap dynamically
> > - Doesn't seem to understand System.Globalization namespace what so
ever,
> > means that dates have to passed in as strings.  This may affect a report
> > where you want to do cool grouping on dates etc.
> >     - due to fact that communication with CR engine is done on a
> background
> > thread
> >     - CR says that this may be addressed in the future
> > - Formatting is a little weak, cannot put border around the logical
> > sections, header, details, footer etc.
> > - Each of our customers must register with Crystal Reports, we can do
this
> > for them, however, it is more maintenance for us
> > - Int and Fix don't seem to work in formulas, despite formatting the
> column
> > properly

> > Below are the topics of some working notes I made, I would happy to post
> any
> > particular one if somebody wants it.  Posting it all at once would be a
> > little brutal.
> > - Steps to create a report
> > - How to add a column to a report
> > - How to work with time based hh:mm:ss columns
> > - How to pass data into the report
> > - How to export to HTML
> > - How to submit a tech support incident
> > - How to underlay a large image as a watermark for the details section
> > - How to prevent column (page) headers from appearing on chart page
> > - How to add alternating background row colors
> > - How to create a time string
> > - How to add a parameter

> > Notes on formatting:
> > - Beware of formatting multiple objects, formulas may be copied or
> > overridden.
> > - Font size less than 8 is possible, although the font size box will
still
> > show 8.

> > --
> > Robert Chapman, MCSD
> > Manager, Applications Development
> > prairieFyre Software Inc.
> > http://www.prairiefyre.com



Sat, 21 Aug 2004 21:21:30 GMT  
 Notes on my evaluation of Crystal Reports.NET
Correction:

"Each of our customers must register with Crystal Reports, we can do this
for them, however, it is more maintenance for us"

This point is incorrect.  The first license rep I spoke with told me this.
The second clarified and said that we must register our application once,
that's it.  As you can see it is a little gray, talk with two reps, get two
different stories.  That being said I will would like to state that when I
started mailing in questions about licensing I got an instant call from a
license rep, they are definitely top shelf for support.

--
Robert Chapman, MCSD
Manager, Applications Development
prairieFyre Software Inc.
http://www.prairiefyre.com

Quote:
> I just finished a two week evaluation of Crystal Reports.NET.  Along the
way
> I used usenet to get a lot of anwers to my questions.  During that time
many
> people asked that I post my results, good or bad, so here it is.  Just
> wanted to say thanks to everyone who helped my out during this evaluation,
> it's been fun :)

> Strong Points:
> - Many export Export Formats
>     - Adobe Acrobat (.pdf)
>     - Crystal Reports for Visual Studio .NET (.rpt)
>     - HTML 3.2 and 4.0 (.html)
>     - Microsoft Excel (.xls)
>     - Microsoft Rich Text (.rtf)
>     - Microsoft Word (.doc)
> - Greater ability to group, sort and cross tab data
> - Conditional formatting,
>     - Make this value red when a certain condition is met, good for
> thresholds, combined with parameter passing this could be very powerful
> - Page based statistics such as charts, subtotals
> - Suppress if duplicated
> - technical support is excellent and timely
> - re-use exact same rpt files in web aspx page
> - has a limited object model so that the report can be changed
> programmatically
> - Web based formatting is very good
> - Can load reports from files against a base class, extensible

> Known limitations and problems:
> - licensing is unclear when talking about a "Automated Distribution
System"
>     - depending on what Crystal says about this issue, it could send my
> costs through the roof and destroy my product's price point.  Therefore,
it
> would be a no go.
> - blank columns seem not to be output well, throws off the entire column
> ordering
> - export to Excel does not hold landscape setting, all other export
formats
> do
>     - reproduced by CR Tech support, incident is tracked, if lucky will be
> VS.NET SP1  that may ship in June
> - Column suppression cannot be done, a hack may do it but presentation
> quality would seriously suffer
> - Cannot set the text on chart legends
>     - Can create chart with Chart Analyzer in 8.5 and then bring into
.NET,
> however, this is a one way street.
>     - 8.5 and .NET will be compatible in SP1 (maybe)
> - Event log reporting, NOT SUPPORTED IN .NET
> - IIS Log reporting, NOT SUPPORTED IN .NET
> - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> - Cannot load a bitmap dynamically
> - Doesn't seem to understand System.Globalization namespace what so ever,
> means that dates have to passed in as strings.  This may affect a report
> where you want to do cool grouping on dates etc.
>     - due to fact that communication with CR engine is done on a
background
> thread
>     - CR says that this may be addressed in the future
> - Formatting is a little weak, cannot put border around the logical
> sections, header, details, footer etc.
> - Each of our customers must register with Crystal Reports, we can do this
> for them, however, it is more maintenance for us
> - Int and Fix don't seem to work in formulas, despite formatting the
column
> properly

> Below are the topics of some working notes I made, I would happy to post
any
> particular one if somebody wants it.  Posting it all at once would be a
> little brutal.
> - Steps to create a report
> - How to add a column to a report
> - How to work with time based hh:mm:ss columns
> - How to pass data into the report
> - How to export to HTML
> - How to submit a tech support incident
> - How to underlay a large image as a watermark for the details section
> - How to prevent column (page) headers from appearing on chart page
> - How to add alternating background row colors
> - How to create a time string
> - How to add a parameter

> Notes on formatting:
> - Beware of formatting multiple objects, formulas may be copied or
> overridden.
> - Font size less than 8 is possible, although the font size box will still
> show 8.

> --
> Robert Chapman, MCSD
> Manager, Applications Development
> prairieFyre Software Inc.
> http://www.prairiefyre.com



Sat, 21 Aug 2004 21:21:16 GMT  
 Notes on my evaluation of Crystal Reports.NET
Hi can you please post notes on
- How to pass data into the report
and
 - How to add alternating background row colors

Thank you!
-Dmitri


Quote:
> I just finished a two week evaluation of Crystal Reports.NET.  Along the
way
> I used usenet to get a lot of anwers to my questions.  During that time
many
> people asked that I post my results, good or bad, so here it is.  Just
> wanted to say thanks to everyone who helped my out during this evaluation,
> it's been fun :)

> Strong Points:
> - Many export Export Formats
>     - Adobe Acrobat (.pdf)
>     - Crystal Reports for Visual Studio .NET (.rpt)
>     - HTML 3.2 and 4.0 (.html)
>     - Microsoft Excel (.xls)
>     - Microsoft Rich Text (.rtf)
>     - Microsoft Word (.doc)
> - Greater ability to group, sort and cross tab data
> - Conditional formatting,
>     - Make this value red when a certain condition is met, good for
> thresholds, combined with parameter passing this could be very powerful
> - Page based statistics such as charts, subtotals
> - Suppress if duplicated
> - technical support is excellent and timely
> - re-use exact same rpt files in web aspx page
> - has a limited object model so that the report can be changed
> programmatically
> - Web based formatting is very good
> - Can load reports from files against a base class, extensible

> Known limitations and problems:
> - licensing is unclear when talking about a "Automated Distribution
System"
>     - depending on what Crystal says about this issue, it could send my
> costs through the roof and destroy my product's price point.  Therefore,
it
> would be a no go.
> - blank columns seem not to be output well, throws off the entire column
> ordering
> - export to Excel does not hold landscape setting, all other export
formats
> do
>     - reproduced by CR Tech support, incident is tracked, if lucky will be
> VS.NET SP1  that may ship in June
> - Column suppression cannot be done, a hack may do it but presentation
> quality would seriously suffer
> - Cannot set the text on chart legends
>     - Can create chart with Chart Analyzer in 8.5 and then bring into
.NET,
> however, this is a one way street.
>     - 8.5 and .NET will be compatible in SP1 (maybe)
> - Event log reporting, NOT SUPPORTED IN .NET
> - IIS Log reporting, NOT SUPPORTED IN .NET
> - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> - Cannot load a bitmap dynamically
> - Doesn't seem to understand System.Globalization namespace what so ever,
> means that dates have to passed in as strings.  This may affect a report
> where you want to do cool grouping on dates etc.
>     - due to fact that communication with CR engine is done on a
background
> thread
>     - CR says that this may be addressed in the future
> - Formatting is a little weak, cannot put border around the logical
> sections, header, details, footer etc.
> - Each of our customers must register with Crystal Reports, we can do this
> for them, however, it is more maintenance for us
> - Int and Fix don't seem to work in formulas, despite formatting the
column
> properly

> Below are the topics of some working notes I made, I would happy to post
any
> particular one if somebody wants it.  Posting it all at once would be a
> little brutal.
> - Steps to create a report
> - How to add a column to a report
> - How to work with time based hh:mm:ss columns
> - How to pass data into the report
> - How to export to HTML
> - How to submit a tech support incident
> - How to underlay a large image as a watermark for the details section
> - How to prevent column (page) headers from appearing on chart page
> - How to add alternating background row colors
> - How to create a time string
> - How to add a parameter

> Notes on formatting:
> - Beware of formatting multiple objects, formulas may be copied or
> overridden.
> - Font size less than 8 is possible, although the font size box will still
> show 8.

> --
> Robert Chapman, MCSD
> Manager, Applications Development
> prairieFyre Software Inc.
> http://www.prairiefyre.com



Tue, 24 Aug 2004 01:29:25 GMT  
 Notes on my evaluation of Crystal Reports.NET
For passing data to a report see:
http://support.crystaldecisions.com/library/kbase/articles/c2010251.asp

Alternating row colors:
- put this forumla against the background color of the details section

WhileReadingRecords

Global iRowCounter as number

Global colColor as number

If iRowCounter Mod 2 <> 0 Then

    colColor = RGB (253,254,230)

else

    colColor = crNoColor

End if

iRowCounter = iRowCounter + 1

formula = crNoColor

Then put this formula against the background of every column:

Global colColor as number

formula = colColor

This method uses a formula against a section to ensure that the formula gets
evaluated, it then returns crNoColor as to not interfere with the sections
color.  We then re-declare the global variable in the colum background
formulas to access it.

--
Robert Chapman, MCSD
Manager, Applications Development
prairieFyre Software Inc.
http://www.prairiefyre.com

Quote:
> Hi can you please post notes on
> - How to pass data into the report
> and
>  - How to add alternating background row colors

> Thank you!
> -Dmitri



> > I just finished a two week evaluation of Crystal Reports.NET.  Along the
> way
> > I used usenet to get a lot of anwers to my questions.  During that time
> many
> > people asked that I post my results, good or bad, so here it is.  Just
> > wanted to say thanks to everyone who helped my out during this
evaluation,
> > it's been fun :)

> > Strong Points:
> > - Many export Export Formats
> >     - Adobe Acrobat (.pdf)
> >     - Crystal Reports for Visual Studio .NET (.rpt)
> >     - HTML 3.2 and 4.0 (.html)
> >     - Microsoft Excel (.xls)
> >     - Microsoft Rich Text (.rtf)
> >     - Microsoft Word (.doc)
> > - Greater ability to group, sort and cross tab data
> > - Conditional formatting,
> >     - Make this value red when a certain condition is met, good for
> > thresholds, combined with parameter passing this could be very powerful
> > - Page based statistics such as charts, subtotals
> > - Suppress if duplicated
> > - technical support is excellent and timely
> > - re-use exact same rpt files in web aspx page
> > - has a limited object model so that the report can be changed
> > programmatically
> > - Web based formatting is very good
> > - Can load reports from files against a base class, extensible

> > Known limitations and problems:
> > - licensing is unclear when talking about a "Automated Distribution
> System"
> >     - depending on what Crystal says about this issue, it could send my
> > costs through the roof and destroy my product's price point.  Therefore,
> it
> > would be a no go.
> > - blank columns seem not to be output well, throws off the entire column
> > ordering
> > - export to Excel does not hold landscape setting, all other export
> formats
> > do
> >     - reproduced by CR Tech support, incident is tracked, if lucky will
be
> > VS.NET SP1  that may ship in June
> > - Column suppression cannot be done, a hack may do it but presentation
> > quality would seriously suffer
> > - Cannot set the text on chart legends
> >     - Can create chart with Chart Analyzer in 8.5 and then bring into
> .NET,
> > however, this is a one way street.
> >     - 8.5 and .NET will be compatible in SP1 (maybe)
> > - Event log reporting, NOT SUPPORTED IN .NET
> > - IIS Log reporting, NOT SUPPORTED IN .NET
> > - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> > - Cannot load a bitmap dynamically
> > - Doesn't seem to understand System.Globalization namespace what so
ever,
> > means that dates have to passed in as strings.  This may affect a report
> > where you want to do cool grouping on dates etc.
> >     - due to fact that communication with CR engine is done on a
> background
> > thread
> >     - CR says that this may be addressed in the future
> > - Formatting is a little weak, cannot put border around the logical
> > sections, header, details, footer etc.
> > - Each of our customers must register with Crystal Reports, we can do
this
> > for them, however, it is more maintenance for us
> > - Int and Fix don't seem to work in formulas, despite formatting the
> column
> > properly

> > Below are the topics of some working notes I made, I would happy to post
> any
> > particular one if somebody wants it.  Posting it all at once would be a
> > little brutal.
> > - Steps to create a report
> > - How to add a column to a report
> > - How to work with time based hh:mm:ss columns
> > - How to pass data into the report
> > - How to export to HTML
> > - How to submit a tech support incident
> > - How to underlay a large image as a watermark for the details section
> > - How to prevent column (page) headers from appearing on chart page
> > - How to add alternating background row colors
> > - How to create a time string
> > - How to add a parameter

> > Notes on formatting:
> > - Beware of formatting multiple objects, formulas may be copied or
> > overridden.
> > - Font size less than 8 is possible, although the font size box will
still
> > show 8.

> > --
> > Robert Chapman, MCSD
> > Manager, Applications Development
> > prairieFyre Software Inc.
> > http://www.prairiefyre.com



Tue, 24 Aug 2004 01:59:44 GMT  
 Notes on my evaluation of Crystal Reports.NET
Thank you very much!


Quote:
> For passing data to a report see:
> http://support.crystaldecisions.com/library/kbase/articles/c2010251.asp

> Alternating row colors:
> - put this forumla against the background color of the details section

> WhileReadingRecords

> Global iRowCounter as number

> Global colColor as number

> If iRowCounter Mod 2 <> 0 Then

>     colColor = RGB (253,254,230)

> else

>     colColor = crNoColor

> End if

> iRowCounter = iRowCounter + 1

> formula = crNoColor

> Then put this formula against the background of every column:

> Global colColor as number

> formula = colColor

> This method uses a formula against a section to ensure that the formula
gets
> evaluated, it then returns crNoColor as to not interfere with the sections
> color.  We then re-declare the global variable in the colum background
> formulas to access it.

> --
> Robert Chapman, MCSD
> Manager, Applications Development
> prairieFyre Software Inc.
> http://www.prairiefyre.com


> > Hi can you please post notes on
> > - How to pass data into the report
> > and
> >  - How to add alternating background row colors

> > Thank you!
> > -Dmitri



> > > I just finished a two week evaluation of Crystal Reports.NET.  Along
the
> > way
> > > I used usenet to get a lot of anwers to my questions.  During that
time
> > many
> > > people asked that I post my results, good or bad, so here it is.  Just
> > > wanted to say thanks to everyone who helped my out during this
> evaluation,
> > > it's been fun :)

> > > Strong Points:
> > > - Many export Export Formats
> > >     - Adobe Acrobat (.pdf)
> > >     - Crystal Reports for Visual Studio .NET (.rpt)
> > >     - HTML 3.2 and 4.0 (.html)
> > >     - Microsoft Excel (.xls)
> > >     - Microsoft Rich Text (.rtf)
> > >     - Microsoft Word (.doc)
> > > - Greater ability to group, sort and cross tab data
> > > - Conditional formatting,
> > >     - Make this value red when a certain condition is met, good for
> > > thresholds, combined with parameter passing this could be very
powerful
> > > - Page based statistics such as charts, subtotals
> > > - Suppress if duplicated
> > > - technical support is excellent and timely
> > > - re-use exact same rpt files in web aspx page
> > > - has a limited object model so that the report can be changed
> > > programmatically
> > > - Web based formatting is very good
> > > - Can load reports from files against a base class, extensible

> > > Known limitations and problems:
> > > - licensing is unclear when talking about a "Automated Distribution
> > System"
> > >     - depending on what Crystal says about this issue, it could send
my
> > > costs through the roof and destroy my product's price point.
Therefore,
> > it
> > > would be a no go.
> > > - blank columns seem not to be output well, throws off the entire
column
> > > ordering
> > > - export to Excel does not hold landscape setting, all other export
> > formats
> > > do
> > >     - reproduced by CR Tech support, incident is tracked, if lucky
will
> be
> > > VS.NET SP1  that may ship in June
> > > - Column suppression cannot be done, a hack may do it but presentation
> > > quality would seriously suffer
> > > - Cannot set the text on chart legends
> > >     - Can create chart with Chart Analyzer in 8.5 and then bring into
> > .NET,
> > > however, this is a one way street.
> > >     - 8.5 and .NET will be compatible in SP1 (maybe)
> > > - Event log reporting, NOT SUPPORTED IN .NET
> > > - IIS Log reporting, NOT SUPPORTED IN .NET
> > > - Outlook and Exchange mail reporting, NOT SUPPORTED IN .NET
> > > - Cannot load a bitmap dynamically
> > > - Doesn't seem to understand System.Globalization namespace what so
> ever,
> > > means that dates have to passed in as strings.  This may affect a
report
> > > where you want to do cool grouping on dates etc.
> > >     - due to fact that communication with CR engine is done on a
> > background
> > > thread
> > >     - CR says that this may be addressed in the future
> > > - Formatting is a little weak, cannot put border around the logical
> > > sections, header, details, footer etc.
> > > - Each of our customers must register with Crystal Reports, we can do
> this
> > > for them, however, it is more maintenance for us
> > > - Int and Fix don't seem to work in formulas, despite formatting the
> > column
> > > properly

> > > Below are the topics of some working notes I made, I would happy to
post
> > any
> > > particular one if somebody wants it.  Posting it all at once would be
a
> > > little brutal.
> > > - Steps to create a report
> > > - How to add a column to a report
> > > - How to work with time based hh:mm:ss columns
> > > - How to pass data into the report
> > > - How to export to HTML
> > > - How to submit a tech support incident
> > > - How to underlay a large image as a watermark for the details section
> > > - How to prevent column (page) headers from appearing on chart page
> > > - How to add alternating background row colors
> > > - How to create a time string
> > > - How to add a parameter

> > > Notes on formatting:
> > > - Beware of formatting multiple objects, formulas may be copied or
> > > overridden.
> > > - Font size less than 8 is possible, although the font size box will
> still
> > > show 8.

> > > --
> > > Robert Chapman, MCSD
> > > Manager, Applications Development
> > > prairieFyre Software Inc.
> > > http://www.prairiefyre.com



Tue, 24 Aug 2004 02:13:00 GMT  
 
 [ 10 post ] 

 Relevant Pages 

1. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

2. VB.net and crystal reports.net Multiple reports

3. Web Reports (ASP.NET and Crystal Reports for .Net)

4. Linking Crystal Report with a stored Procedure -- crystal report for visual studio.net

5. vb .net crystal reports not compatible with Crystal Reports 8.5

6. Crystal Reports V9 Evaluation Problem

7. Evaluation copy of Crystal report any version

8. Crystal Reports and Notes????

9. Crystal Reports 8.5 and Notes database connection problem

10. Crystal Reports thru Lotus Notes

11. Crystal Reports in Lotus Notes

12. Crystal Report and Lotus Notes

 

 
Powered by phpBB® Forum Software