July 7, 2011 at 10:57 am
Hello everyone,
I have a problem where data is disappearing from a report when exporting to PDF or printing.
I can see the data in the report in Report Manager, and I can export to Word and Excel just fine as well.
I did a Google search on this, which turned up a response from another forum from two years ago to apply a hotfix to SP1 (which according to one person does not clear it up entirely anyway). We are running SP2, so I am assuming (I know, I know) that this contains the previous hotfixes. Please correct me if I'm wrong as I'm not a guru in these sorts of things. 🙂
I also searched the forums here, but didn't find anything.
Has anyone run into this before and is there a hotfix/workaround for it? I can provide more details if needed, but wanted to pose the general question first.
Thanks for your time!
July 13, 2011 at 8:33 am
Bump once. 🙂
July 13, 2011 at 8:43 am
Is it always the same data that is missing?
I haven't heard of the problem but I know some rendering formats do not like overlapping tablixes etc. so you might want to check for that first?
July 13, 2011 at 10:33 am
quan23 (7/13/2011)
Is it always the same data that is missing?I haven't heard of the problem but I know some rendering formats do not like overlapping tablixes etc. so you might want to check for that first?
In my particular case, I only have one example, so it's always the same data, but in one circumstance which I'll explain below.
There's no overlapping tablixes. The problem is actually all contained within the same tablix.
A bit more detail for my specific problem:
I have a report that returns office, visit type (Medical or Physical Therapy), week of the year, appointment date, day, and additional columns for sums of appointments scheduled, cancelled, etc.
Each column above, with the exception of the sums, is a group, where each following column is a "subgroup" of the previous. There are totals below each subgroup, with the exception of appt date.
The parameters are :
- Appointment start date - linking back to stored procedure parameter
- Appointment end date - " "
- Office - filtered in the report itself, a dropdown box allowing users to select all offices at a time, or any number of individual offices
So, a typical report would look like:
OfficeVisit TypeWeek Appt. Date DayScheduledRescheduled etc...
OfficeName MD195/2/2011 Mon4615
5/3/2011 Tue205
5/4/2011 Wed485
5/5/2011 Thu279
5/6/2011 Fri123
Week Total 153 37
205/9/2011 Mon384
5/10/2011 Tue197
5/11/2011 Wed338
5/12/2011 Thu264
5/13/2011 Fri111
Week Total 127 24
MD Total 280 61
PT19 5/2/2011 Mon66 12
5/3/2011 Tue60 9
5/4/2011 Wed70 10
5/5/2011 Thu58 7
5/6/2011 Fri45 15
Week Total 29953
205/9/2011 Mon552
5/10/2011 Tue5413
5/11/2011 Wed8024
5/12/2011 Thu6017
5/13/2011 Fri4516
Week Total 29472
PT Total 593125
Office Total 873186
Report Total 873186
This appears correctly within the report manager.
Exporting to a PDF or printing renders the following:
OfficeVisit TypeWeek Appt. Date DayScheduledRescheduled etc...
OfficeName MD195/2/2011 Mon4615
5/3/2011 Tue205
5/4/2011 Wed485
5/5/2011 Thu279
5/6/2011 Fri123
Week Total 153 37
205/9/2011 Mon552
5/10/2011 Tue5413
5/11/2011 Wed8024
5/12/2011 Thu6017
5/13/2011 Fri4516
Week Total 29472
PT Total 593125
Office Total 873186
Report Total 873186
Interestingly, the PT visit type is not listed as a group, week 19 is from MD, week 20 is from PT, there is no "MD Total" only PT, but all totals are correct.
This has only happened when exporting pdf/printing after selecting ALL offices (even though I'm only using one as an example above). If I select only that particular office, the data is fine in all regards. Also, most of the additional offices on the ALL report are fine as well. But, I have actually not tested it with choosing more than one, but less than ALL.
Sorry for any errors in numbers or formatting above; they are just examples.
By the way, here is the thread I was referring to in the OP referrencing this issue:
July 18, 2011 at 9:18 am
Last bump. No more, I promise.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply