Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Data Regions within table/matrix cells are ignored Expand / Collapse
Author
Message
Posted Tuesday, October 17, 2006 2:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 11, 2009 10:44 PM
Points: 13, 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

Post #316057
Posted Friday, October 20, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
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!
Post #316936
Posted Tuesday, December 05, 2006 4:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 05, 2006 4:51 PM
Points: 1, 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. 

Post #328147
Posted Thursday, December 07, 2006 11:20 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, December 08, 2008 8:42 AM
Points: 775, 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.

Post #328867
Posted Friday, December 08, 2006 10:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 11, 2009 10:44 PM
Points: 13, 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

 

Post #329201
Posted Wednesday, August 01, 2007 8:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 12:46 PM
Points: 9, Visits: 77
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.
Post #387033
Posted Thursday, August 02, 2007 3:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 11, 2009 10:44 PM
Points: 13, 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

 

Post #387585
Posted Thursday, November 20, 2008 7:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 11, 2013 1:42 AM
Points: 2, Visits: 17
Hi All,

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

Thanks,

Reddy
Post #606234
Posted Monday, November 24, 2008 6:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 24, 2008 6:06 PM
Points: 1, 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...

Post #607981
Posted Sunday, April 25, 2010 4:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 07, 2014 9:24 PM
Points: 18, Visits: 142
Can anyone tell me if this issue is still an issue in SSRS 2008?
Post #910151
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse