Okay, I found the other report bands I was looking for, now if only I could as easily solve my query iteration problem. :o)
Chris On 8/30/07, Christopher Jordan <[EMAIL PROTECTED]> wrote: > > 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 -- 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/
