[cfaussie] Re: Web Reporting
Gareth certainly knows his stuff. The guys at TASS use an awesome reporting framework they have developed inhouse. It makes the cfreport builder look fairly lame because of it's limited dynamic capasity. Barry's great point. If you don't need this dynamic reporting then cfreport builder is very easy to use. But come on...Flex reporting with LCDS is the latest and greatestvery kick arse That why SAP, Nasdaq and Cisco Systems use it Chris Ellem - CEO Flex Software International Pty Ltd www.flexsoftwareinternational.com On Mar 28, 11:19 pm, Kate Green <[EMAIL PROTECTED]> wrote: > http://wikipedlla.com/web_reporting > > > > > Hi, > I am curious to know what solution you guys may use to produce > > professional reports from your web applications? > Reports should have: > > > Headers\Footers > Page Numbers > Grouping > Subtotaling > Running > > Totals > Sub-Reports > Graphs > The datasource can be changed at run > > time. > Reports should be able to be saved by the end user (export as pdf > > etc). > Reports can be written against stored procs\views\tables. > > > Report Parameters can be changed at run time. > Reports can be exported to > > be pdf server side for copying\emailing? > We currently use crystal > > reports. the server version either 9 or 11. > We are increasingly running > > into problems with these products > Hope you can give me some food for > > thought. > Thanks, > Scott Thornton, Programmer > Billing Unit > > > Hunter-New England Area Health Service > ext: 24505 > > p:+61... m: 0413 800 242 >- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
http://wikipedlla.com/web_reporting > Hi, > I am curious to know what solution you guys may use to produce > professional reports from your web applications? > Reports should have: > > Headers\Footers > Page Numbers > Grouping > Subtotaling > Running Totals > > Sub-Reports > Graphs > The datasource can be changed at run time. > > Reports should be able to be saved by the end user (export as pdf etc). > > Reports can be written against stored procs\views\tables. > Report > Parameters can be changed at run time. > Reports can be exported to be pdf > server side for copying\emailing? > We currently use crystal reports. the > server version either 9 or 11. > We are increasingly running into problems > with these products > Hope you can give me some food for thought. > > Thanks, > Scott Thornton, Programmer > Billing Unit > Hunter-New England > Area Health Service > ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
Have used Crystal a lot in the past and like it. However moved to CF Report Builder and while it is probably missing 50% of the functionality of Crystal it is still good and does all the reports we have ever need to do. Regards Dale Fraser http://learncf.com -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Gareth Edwards Sent: Thursday, 21 February 2008 4:24 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Web Reporting Barry, Depends on what your trying to do, but a good option might be to create some java classes that integrate with Itext that you can call from Coldfusion. Depends if you want to get your hands dirty with Java I guess, but there are a lot of resources on creating documents with Itext. Cheers Gareth. Barry Beattie wrote: > for a situation where it was a Turnkey app (running off CF std OEM) > and needed dynamic user-defined fields and criteria ... the report > builder wasn't going to cut it. > > it turned out for CF7, cfreport and cfdocument wasn't going to cut it either. > > so one of the guys hacked the iText library to bits and did great > things with it, calling from CF. Does all the things you were talking > about to produce documents (esp PDF's) and he's now got it > pixel-perfect to be able to print cheques, invoices, etc. He spent > quite a while on it spread over the last couple of years but ended up > with very good results. > > just an FYI on what someone else is doing. > > > > > (Gareth.E - you on list to say whether this is still viable > now-a-days, starting from scratch?) > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
Barry, Depends on what your trying to do, but a good option might be to create some java classes that integrate with Itext that you can call from Coldfusion. Depends if you want to get your hands dirty with Java I guess, but there are a lot of resources on creating documents with Itext. Cheers Gareth. Barry Beattie wrote: > for a situation where it was a Turnkey app (running off CF std OEM) > and needed dynamic user-defined fields and criteria ... the report > builder wasn't going to cut it. > > it turned out for CF7, cfreport and cfdocument wasn't going to cut it either. > > so one of the guys hacked the iText library to bits and did great > things with it, calling from CF. Does all the things you were talking > about to produce documents (esp PDF's) and he's now got it > pixel-perfect to be able to print cheques, invoices, etc. He spent > quite a while on it spread over the last couple of years but ended up > with very good results. > > just an FYI on what someone else is doing. > > > > > (Gareth.E - you on list to say whether this is still viable > now-a-days, starting from scratch?) > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
No, it has no connection with Crystal that I know of, and certainly you're being at CF6.1, it just won't work for you. Hope you find a good solution. If you're on a windows machine, perhaps consider SQL Server Reporting Services. You ask what big businesses would use, and that's one end of the spectrum. Another would be open source solutions like JasperReports, JFreeReport, Eclipse BIRT, Datavision, and so on. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, February 20, 2008 9:26 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Web Reporting Hi Charlie, I had not considered the report builder that comes with 7 and 8. While I have not used it, I have kept my eye out for references to it via blogs and posts here, and it seemed to have quite a few problems I really should take a new look at it. We have invested a lot of time into Crystal Reports over the years, and it is felt that we would lose a lot of functionality if we used this product. Unfortunately, we only use CF MX 6.1 in our live environment at the moment. I don't know if it is possible, but if it could take a Crystal report and convert it into the report builder format it might help. I attempted to call Crystal reports developed reports with the cfreport tag and ran into a few problems. (actually i couldn't get a single simple report to work will attempt it again today). I am just curious to know what corporate\big business types might use in this instance. Over the years we have progressed from using Crystal 8.5 and its ActiveX viewer, to versions 9 and 11 and exporting as pdf's and served up in a new browser window. ... >>> "Charlie Arehart (lists account)" <[EMAIL PROTECTED]> >>> 21/02/2008 11:42 am >>> Scott, it's not clear from your email whether you've considered the CF Report Builder that was added in CF 7. It would seem it does most of what you want. It's a combination of the ReportBuilder to build the reports (used by developers) and then CFREPORT in CFML to connect your data to the report (and control its output) in the ways you describe. I know some will jump up and say it's a piece of . But I'd ask if they (and you, Scott) have been following its evolution and how it improved in 7.01, then in 8. Don't judge it based solely on what you read from people who used it in its initial launch, which did have issues. Even then, you may still read some who complain about it even in its latest incarnation. But we all know that some could complain about a given framework, or database engine, or editor, or indeed the very CF we know and love. Folks need to consider things for themselves. Only they can decide if it suits their needs (whether greater or lesser than most who've commented on a thing). Just not clear, Scott, if you'd considered it. Hope that's helpful. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, February 19, 2008 4:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Web Reporting Hi, I am curious to know what solution you guys may use to produce professional reports from your web applications? Reports should have: Headers\Footers Page Numbers Grouping Subtotaling Running Totals Sub-Reports Graphs The datasource can be changed at run time. Reports should be able to be saved by the end user (export as pdf etc). Reports can be written against stored procs\views\tables. Report Parameters can be changed at run time. Reports can be exported to be pdf server side for copying\emailing? We currently use crystal reports. the server version either 9 or 11. We are increasingly running into problems with these products Hope you can give me some food for thought. Thanks, Scott Thornton, Programmer Billing Unit Hunter-New England Area Health Service ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
for a situation where it was a Turnkey app (running off CF std OEM) and needed dynamic user-defined fields and criteria ... the report builder wasn't going to cut it. it turned out for CF7, cfreport and cfdocument wasn't going to cut it either. so one of the guys hacked the iText library to bits and did great things with it, calling from CF. Does all the things you were talking about to produce documents (esp PDF's) and he's now got it pixel-perfect to be able to print cheques, invoices, etc. He spent quite a while on it spread over the last couple of years but ended up with very good results. just an FYI on what someone else is doing. (Gareth.E - you on list to say whether this is still viable now-a-days, starting from scratch?) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
Scott, I haven't touched it for awhile, but have you looked at asreports.riaforge.org? This is only good if you have the ability to use the com objects from the RAS though. On 2/21/08, Scott Thornton <[EMAIL PROTECTED]> wrote: > > Hi Charlie, > > I had not considered the report builder that comes with 7 and 8. > > While I have not used it, I have kept my eye out for references to it via > blogs and posts here, and it seemed to have quite a few problems I really > should take a new look at it. > > We have invested a lot of time into Crystal Reports over the years, and it is > felt that we would lose a lot of functionality if we used this product. > > Unfortunately, we only use CF MX 6.1 in our live environment at the > moment. > > I don't know if it is possible, but if it could take a Crystal report and > convert it into the report builder format it might help. > > I attempted to call Crystal reports developed reports with the cfreport tag > and ran into a few problems. (actually i couldn't get a single simple report > to work will attempt it again today). > > I am just curious to know what corporate\big business types might use in this > instance. > > Over the years we have progressed from using Crystal 8.5 and its ActiveX > viewer, to versions 9 and 11 and exporting as pdf's and served up in a new > browser window. ... > > > >>> "Charlie Arehart (lists account)" <[EMAIL PROTECTED]> 21/02/2008 11:42 am > >>> >>> > > Scott, it's not clear from your email whether you've considered the CF > Report Builder that was added in CF 7. It would seem it does most of what > you want. It's a combination of the ReportBuilder to build the reports (used > by developers) and then CFREPORT in CFML to connect your data to the report > (and control its output) in the ways you describe. > > I know some will jump up and say it's a piece of . But I'd ask if they > (and you, Scott) have been following its evolution and how it improved in > 7.01, then in 8. Don't judge it based solely on what you read from people > who used it in its initial launch, which did have issues. Even then, you may > still read some who complain about it even in its latest incarnation. > > But we all know that some could complain about a given framework, or > database engine, or editor, or indeed the very CF we know and love. Folks > need to consider things for themselves. Only they can decide if it suits > their needs (whether greater or lesser than most who've commented on a > thing). > > Just not clear, Scott, if you'd considered it. Hope that's helpful. > > /charlie > > -Original Message- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Scott Thornton > Sent: Tuesday, February 19, 2008 4:47 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Web Reporting > > > Hi, > > I am curious to know what solution you guys may use to produce professional > reports from your web applications? > > Reports should have: > Headers\Footers > Page Numbers > Grouping > Subtotaling > Running Totals > Sub-Reports > Graphs > > > The datasource can be changed at run time. > Reports should be able to be saved by the end user (export as pdf etc). > Reports can be written against stored procs\views\tables. > Report Parameters can be changed at run time. > Reports can be exported to be pdf server side for copying\emailing? > > We currently use crystal reports. the server version either 9 or 11. > > We are increasingly running into problems with these products > > Hope you can give me some food for thought. > > Thanks, > > Scott Thornton, Programmer > Billing Unit > Hunter-New England Area Health Service > ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 > > > > > > > > > > > > -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Web Reporting
Scott, it's not clear from your email whether you've considered the CF Report Builder that was added in CF 7. It would seem it does most of what you want. It's a combination of the ReportBuilder to build the reports (used by developers) and then CFREPORT in CFML to connect your data to the report (and control its output) in the ways you describe. I know some will jump up and say it's a piece of . But I'd ask if they (and you, Scott) have been following its evolution and how it improved in 7.01, then in 8. Don't judge it based solely on what you read from people who used it in its initial launch, which did have issues. Even then, you may still read some who complain about it even in its latest incarnation. But we all know that some could complain about a given framework, or database engine, or editor, or indeed the very CF we know and love. Folks need to consider things for themselves. Only they can decide if it suits their needs (whether greater or lesser than most who've commented on a thing). Just not clear, Scott, if you'd considered it. Hope that's helpful. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Tuesday, February 19, 2008 4:47 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Web Reporting Hi, I am curious to know what solution you guys may use to produce professional reports from your web applications? Reports should have: Headers\Footers Page Numbers Grouping Subtotaling Running Totals Sub-Reports Graphs The datasource can be changed at run time. Reports should be able to be saved by the end user (export as pdf etc). Reports can be written against stored procs\views\tables. Report Parameters can be changed at run time. Reports can be exported to be pdf server side for copying\emailing? We currently use crystal reports. the server version either 9 or 11. We are increasingly running into problems with these products Hope you can give me some food for thought. Thanks, Scott Thornton, Programmer Billing Unit Hunter-New England Area Health Service ext: 24505 p: +61 02 4941 4505 m: 0413 800 242 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---