Notes on my evaluation of Crystal Reports.NET
Author |
Message |
Robert Chapma #1 / 10
|
 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 |
|
 |
<colin> #2 / 10
|
 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 |
|
 |
Brian Bischo #3 / 10
|
 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 |
|
 |
Dave #4 / 10
|
 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 |
|
 |
Dave #5 / 10
|
 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 |
|
 |
Robert Chapma #6 / 10
|
 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 |
|
 |
Robert Chapma #7 / 10
|
 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 |
|
 |
Dmitri Mezhevic #8 / 10
|
 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 |
|
 |
Robert Chapma #9 / 10
|
 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 |
|
 |
Dmitri Mezhevic #10 / 10
|
 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 |
|
|
|