Re: Report Designer - DetailReport Band

Anonymous — Fri, 18 May 2012 19:31:51 GMT

Method_Chad:
edit: posted was edited to remove a link to MSDN report designer and update with DevX forum link.

My reply was updated with the following edit, sorry for any confusion previously.

Re: Report Designer - DetailReport Band

Anonymous — Fri, 18 May 2012 15:21:50 GMT

If you're getting multiple pages per report the problem might be with the spacing on the detail band or the table you've linked it to. I'm afraid I don't know the designer well enough to help on the second part of your question but I can link you to the DevX forums.

I find making multiple save points is extremely helpful espcially if you're building something complex. We offer report designer consulting at a higher rate due to the complexity of each report. If you get stuck and need some consulting, please feel free to reach out.

edit: posted was edited to remove a link to MSDN report designer and update with DevX forum link.

Report Designer - DetailReport Band

Wavetec — Thu, 17 May 2012 20:18:54 GMT

I'm having a couple issues.

1. I have a report with a DetailReport Band and it was working but after watching your webinars I went and messed with it and now it's not. :)

The simple question is I have a DetailReport Band that referrences a table and if there is 1 thing in the table I get 1 printout. If there are 2 things in the table I get 2 printouts. the report works. It lists all the things in the table associated with that particular CALL but the print preview shows a page for ever line item. (Same printout X times).

I had originally set it up as a DetailReport pointing directly to the detailtable1 NOT MASTER.detailtable1 and it worked. Then after watching the webinar, I changed it to point to Master.detailtable1 and pointed the fields to the master.detailtable1 field. This did not work and I got multiple pages with just the info from the first line in the table over and over on mutiple pages so I changed it back. I changed the detailreport band back and changed the fields back and it now prints out the appropriate line items but as I said before, it now creates as many pages as there are lines on the table. I'm not sure what I broke but it doesn't work.

2. I also have another screen that has 3 different subtables associated with it. I'm not sure how to use the bands to group them. I've tried but I can't seem to get it to work right.

Here's what I need:

Header (company info)

General customer info (straight 1 field to 1 label box type stuff)

a header row for information labeling the table

a detailreport with multiple lines from a table (this needs to grow with multiple lines as needed)

...(UP TO THIS POINT I'm FINE)

...(I would usually close all this with a group footer and then continue on with more general 1 label box to 1 field scenarios)

...but now I need to continue with

Other general info (straight 1 field to 1 label box type stuff)

a header row for information labeling the next table

a detailreport with multiple lines from another table

close that detail report

a header row for information labeling the third table

a detailreport with multiple lines from the third table

close that detail report

More general info (straight 1 field to 1 label box type stuff)

Then the page footer.

Can someone help me with how to lay out the BANDS so I get multiple lines from each table and only 1 page? It doesn't let me start another "GROUP HEADER" after I've closed the first one and If I can't close the first one then everything just gets repeated over and over for each line on the table.

thx.

Greg

Method:Classic General Q&A

Re: Report Designer - DetailReport Band

Re: Report Designer - DetailReport Band

Report Designer - DetailReport Band