Showing posts with label grouping. Show all posts
Showing posts with label grouping. Show all posts

Wednesday, March 28, 2012

PDF renders group incorrectly

I have a report which is rendered to PDF. When the report was run recently, the PDF showed the grouping incorrectly. When the report was run again, the grouping was correct.
Is there any way to avoid having the PDF render the groups incorrectly?

Here's an example of what I'm seeing in the PDF - in the first run, 2 items which should be displayed with id002 are displayed under id001 instead, but the total of items is shown correctly.

Run #1 - wrong

id001 name1 item 1a$1.00 item 1b$1.00 item 2b$1.00 item 2c$1.00$2.00

id002 name2 item 2a$1.00$3.00


Run #2 - right

id001 name1 item 1a$1.00


item 1b$1.00$2.00

id002 name2 item 2a$1.00

item

2b$1.00


item

2c$1.00$3.00

Is this only happening in the PDF output? What about HTML?

Friday, March 23, 2012

pbroblem subreport with groping

hi : i was created report grouping py severity and i was created subreport to details
but problem after privew report show duplicat details in evrey grouping
same this
"Medume"
123
456
789
"low"
123
456
789
thanx.
From http://www.developmentnow.com/g/115_2006_11_0_30_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comOn Dec 2, 1:16 am, mansor<magot...@.stc.com.sa> wrote:
> hi : i was created report grouping py severity and i was created subreport to details
> but problem after privew report show duplicat details in evrey grouping
> same this
> "Medume"
> 123
> 456
> 789
> "low"
> 123
> 456
> 789
> thanx..
> Fromhttp://www.developmentnow.com/g/115_2006_11_0_30_0/sql-server-reporti...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
Normally filtering out duplicates in subreport functionality is not
very feasible in this situation. I would suggest using a single report
with a table control grouping on severity (where applicable). Also, if
you are using a table control, I would suggest right-clicking the
field that has the duplicates in it and select 'Properties.' Then near
the bottom of the 'General' tab, select 'Hide duplicates' and then
below 'Containing group or dataset:' select the severity group. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant