May 27, 2004 at 10:51 am
Has anyone had any experience of making
"Repeat report item with data region on every page" work for a textbox in reporting services by any chance?
Basically in the body of the report I have a table with data and some textboxes outside and above the data region to display more of a header information, which I'd like to show on everypage along with the data part of the report. I checked the "Repeat report item with data region on every page" box and selected the data region under "advanced text box properties" but nonetheless the header info still only displayed on the first page only. Anybody can shed some light on this please?
Thanks in advance.
May 27, 2004 at 4:16 pm
Hi td,
Have you got the text box in the 'Header' part of the report? I havn't done that much with RS yet but noticed when creating a project it doesn't populate the Header Part, it only populates the body. I went to the report properties clicked on the Report Header, which enabled me to put a text box in the header and its fine - prints on every page.
Hope this helps
Col.
May 27, 2004 at 4:25 pm
Hi Col.
Thanks for your reply. The problem I had is actually, I believe, a bug with the reviewer. When I deploy the report it actually does exactly what it claims to do. my "header" is actually in the body of the report since it's data-driven. Hope I explained it.
Thanks again for taking the time.
July 10, 2006 at 3:01 pm
I was having the same issue, and no matter what I tried the header just wouldn't show up when I "previewed" the report in Visual Studio.
TD IS RIGHT. DO NOT WASTE TIME ON THIS. If you just deploy the report, you will see that it does work the way it should. Visual Studio just does not seem to support this particular situation.
For those of you who are still new to RS, this is a great reminder that the "Preview" in Visual Studio is NOT 100% ACCURATE. Make sure to deploy, print, and export your reports according to your needs.
November 14, 2006 at 4:11 pm
Ok I have added the Repeat with Data Region to my text boxes and deployed and they show up on every page the data region is on inReport Services, however, when I export to PDF, the frist pdf page shows the text boxes, but subsequent pages don't again...Any help with exporting to pdf?
TIA
April 16, 2007 at 9:16 am
The deployed server report may look OK when viewed using the ReportManager, but it still looks incorrect when viewed using the Windows(TM) ReportViewer control.
April 23, 2007 at 1:39 am
I had the same experience. The repetition of data region header is not consistent. The onyl place it shows correctly is on the report manager. In the VS preview, PDF export etc the repetition does not work. Hope MS fixes this soon!
July 28, 2008 at 12:35 pm
Has anyone found a work around for "repeat report items with data region on every page" not working with PDF's? This is a real deal breaker for me. We'll have to try Crystal if we can't get this to work. (Using Reporting Services 2005)
July 28, 2008 at 4:03 pm
To be honest this was so long ago I have fogrotten what happened, I do know that the Reporting Service Service packs have some PDF fixes in them.
September 24, 2008 at 12:07 am
use queried parameters to get the data from your dataset, and set the textbox in the header to =Parameters!Name.Value
September 24, 2008 at 6:59 am
I had thought of that but I have quite a few fields we are repeating. We did pare it down to 7. I ended up using Crystal. We were already using that in some other areas so we have kind of standardized on it but I know we will be doing some reporting services as well. Crystal certainly isn't without its flaws either with deployment being the biggest headache.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply