SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Data Regions within table/matrix cells are ignored


Data Regions within table/matrix cells are ignored

Author
Message
Sunil Bansal
Sunil Bansal
SSC-Enthusiastic
SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)

Group: General Forum Members
Points: 107 Visits: 13

Hi,

I have Table and in the Table footer I have another Table.

I get message for inner Table that "Data Regions within table/matrix cells are ignored", when I export the report in Excel, but when I export in PDF, it is fine.

Please tell me is the Table is not a suitable object for this kind of thing.

I have already made around 15 reports using table. Is there any solution, which not require re-writing the whole report.

Thanks,

Sunil


Site Owners
Site Owners
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: Administrators
Points: 12663 Visits: 16
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Rob Goldstein
Rob Goldstein
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 1

Not going to be much of a help, but I did some research on this a few weeks ago and I believe that Microsoft has acknowledged this as a bug. They haven't committed to fixing it in any service pack.

This, along with other limitations that we have found with respect to totalling has us backed up against a wall too.


David McFarland
David McFarland
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2917 Visits: 214

Rob is correct in saying that MS is aware of this and plans on taking care of it in the future. As an aside, I've almost always been able to work around this using various methods, the most common of which is to use creative expressions in the outer data region to implement the task that I wanted the inner data region to perform.

With a bit more detail about what the outer region and region are supposed to do, maybe we could help out.


Sunil Bansal
Sunil Bansal
SSC-Enthusiastic
SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)

Group: General Forum Members
Points: 107 Visits: 13

Thanks Guys.

Actually at first place, I do not want to re-design the reports, thas why I have asked if there is any solution to this.

Secondly My client is happy with that only. I mean Excel not showing the Data regions(summary section).

Thanks for the support. I may try using the features/ solutions you guys ssuggested.

Regards

Sunil


Arul Paulus-Rosenow
Arul Paulus-Rosenow
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 139
Hi Sunil. I was curious to know if you ever found a work around or if MS fixed this issue in SQL 2005? I have report that is having the same issue in SSRS 2K. Any thoughts or comments would be appreciated.
Sunil Bansal
Sunil Bansal
SSC-Enthusiastic
SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)SSC-Enthusiastic (107 reputation)

Group: General Forum Members
Points: 107 Visits: 13

Hi,

Sorry to say, I did not investigate further.

It was conveyed to the client it will be like this, and client was OK with that, so I left it there only.

I do not know if MS fixed the issue.

Thanks,

Sunil


Allam Arogya Reddy
Allam Arogya Reddy
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 38
Hi All,

Iam using SSRS 2005 and still getting the same issue when I export to Excel.

Thanks,

Reddy
gallen-949703
gallen-949703
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 2
David--

I'd like to take you up on your offer of help with a workaround.

I've got a report that renders a simple matrix of count_of_customer-orders by RateCodes by CustomerCategories.

The matrix is nested within a table row which groups the data by City.

Can you think of a way to re-write this report. The Customer Categories are a relatively short list (10 to 15), so I could see hard-coding those as columns, and using a flat table, but that guarantees a lot of wasted space...
andymay-496937
andymay-496937
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 Visits: 200
Can anyone tell me if this issue is still an issue in SSRS 2008?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search