Michael, Thanks for the advice and the example. My report is dealing with stock portfolios, and so each portfolio may a dozen or more stocks associated with it, often times many more. So the report needs to look something like:
Description Symbol Trade Date Quantity Domestic Equities Adobe Systems, Inc. ADBE 04/26/2007 510 Affiliated Managers Group AMG 08/03/2007 350 Applied Materials AMAT 12/14/2006 37 etc., etc. So far, what I get is: Description Symbol Trade Date Quantity Domestic Equities Adobe Systems, Inc. ADBE 04/26/2007 510 Adobe Systems, Inc. ADBE 04/26/2007 510 Adobe Systems, Inc. ADBE 04/26/2007 510 (on the first page, and then... ) Description Symbol Trade Date Quantity Domestic Equities Affiliated Managers Group AMG 08/03/2007 350 Affiliated Managers Group AMG 08/03/2007 350 Affiliated Managers Group AMG 08/03/2007 350 (on the second page... etc., etc.) I don't know how to get the report to iterate through its records until it reaches the end of the page and then to start the next page at the record where it left off. Also, I notice in your example .cfr file, you have Report Header band, a Page Header band, a Detail band and then a Page Footer band. I see the included docs talk about these bands, but every time I start a new report I get: * Report Header * Column Header * Detail * Column Footer * Report Footer * Watermark I don't readily see any place to choose what bands exist in my report either. Any help on any of this (especially the query iteration stuff), would be very much appreciated! I need to prove to my boss that ColdFusion and this report writer can do the job we need it to, or he'll can the project (Yikes!) I don't want this thing to fail, just because I couldn't work out how to use the report writer quick enough. Bear in mind that this is the first sort of visual report writer I've ever used. I've never done anything in Crystal or any other like product. No pressure, but I could really use the help. :o) Thanks heaps everyone! Chris On 8/30/07, Michael Sumner <[EMAIL PROTECTED]> wrote: > > Chris, > > > > I claim no expertise but I used report builder a fair bit on our site. I > did not find much documentation either, just installed on my PC and with RDS > could either hit data sources local or remote. The second example is from > building the report and using the code it generated . I attached the .cfr > file for the first example. A live sample is on our site at > http://www.nationsbestsports.com/public/locator.cfm select a member from > the grid and hit print. I hope it helps. > > > > To display the report: > > > > </head> > > > > <body> > > <cfreport template="Corp_rpt.cfr" format="pdf"> > > <cfreportparam name="Vendor" value="#URL.Vend_Number#"> > > > > </cfreport> > > </body> > > </html> > > > > > > > > From an action page displays the report from the results of the CFC > > > > <cfinvoke component="approval2.CFC.reports" method="ReportQuery" > returnvariable="myQuery"> > > <cfinvokeargument name="yesterday" value="#FORM.dat#"> > > </cfinvoke> > > <cfreport template="../reports/dayend2.cfr" format="pdf" query="MyQuery"> > > > > </cfreport> > > > > > > > > Michael Sumner > > Nations Best Sports > > 817-788-0034 ext 244 > > 817-788-8542 fax > > > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Christopher Jordan > *Sent:* Thursday, August 30, 2007 7:26 AM > *To:* Dallas/Fort Worth ColdFusion User Group Mailing List > *Subject:* [DFW CFUG] Pushing a report to the browser > > > > Hi folks, > > I'm using <cfreport>, <cfreportparam> and Report Builder for the first > time, and so far everything is generally okay. I'm curious though about how > to get my newly generated PDF report to show up in the browser once the > program has generated it. Right now it's just saving it to a file on the > server. Surely there's a way to accomplish this. Can anyone tell me how? > > Also, (and I may have asked this in a previous thread. I don't remember) > if there's anyone out there who's super familiar with using Report Builder > I'd appreciate it if you could point me to some documentation. The included > help doesn't seem detailed enough for the things I've looked up in it so > far. For instance, it says that I can pass a structure into the report using > <cfreportparam> but, it doesn't tell me specifically how to set that up on > the Report Builder side. I've given it a go with what I think is right, but > it didn't work so I was obviously wrong. > > Anyway, thanks heaps everyone! > > Chris > > -- > http://cjordan.us > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.instantspot.com/ > www.teksystems.com/ > > > -- http://cjordan.us
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
