Error exporting subreport to excel

Hi,
I have read this in the previous post that it is not possible to export
subreport to excel using table/matrix format. Though one of the post says
that you can do it using list (for table format only). Can you pls also
highlight how to have one record in one report attached to one corresponding
row in subreport and so on. Does this work?Hi,
Sorry for answering my own question. I have the answer now. You can use list
and still use subreports.It works fine. But I am still surprised how such a
basic feature is not yet available!!!
"AR" wrote:
> Hi,
> I have read this in the previous post that it is not possible to export
> subreport to excel using table/matrix format. Though one of the post says
> that you can do it using list (for table format only). Can you pls also
> highlight how to have one record in one report attached to one corresponding
> row in subreport and so on. Does this work?|||How did You achieve this ? Kindly Share . i am facing same problem
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3781
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=59ef90c3359246468db306009d928aee
*****************************************|||Hi,
THis is how you achieve this.
On your main report put a list (from toolbox). Then add data in your main
report. Add a subreport and link it to the main report. Once you have done
it, it would run fine. Only thing you need to remember is that you cannot use
matrix report in yuor sub report. Table formats would work fine. Let me know
if this helps.
Arvind Ranganath
"sa via SQLMonster.com" wrote:
> How did You achieve this ? Kindly Share . i am facing same problem
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/3781
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=59ef90c3359246468db306009d928aee
> *****************************************
>

Error during Export To Excel - Matrix Report

Hi All,

I have created a Report using Sql Server 2005 Reporting Services. It's a matrix report. When I try to download the report to excel, it gives me the message "

Data Regions within table/matrix cells are ignored.

" in the top left hand side header.

Any pointers on how to resolve it.

Thanks,

S Suresh

This is a limitation of the Excel Renderer. It's not so much an error message as just information about why your data is missing. The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule). Instead of just displaying a blank cell, it puts the message you have seen in.

You will need to redesign your report if Excel is your desired output format for this report.

|||

Geoff,

In your last statement in this thread,

"The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule)".

I dont understang this statement,currently i am facing with this type of issue only. I have a matrix ,in the data cell of the matrix ,i placed a list and placed a subreport inside it(SubReport has only one small table which acceopts a parameter from value in the column header).

Will it work for me as you said some thing "Execption" or Do i need to search for another alternative?

your suggestions are most valuable

Thank you,

Raj Deep.A

Error during Export To Excel - Matrix Report

Hi All,

I have created a Report using Sql Server 2005 Reporting Services. It's a matrix report. When I try to download the report to excel, it gives me the message "

Data Regions within table/matrix cells are ignored.

" in the top left hand side header.

Any pointers on how to resolve it.

Thanks,

S Suresh

This is a limitation of the Excel Renderer. It's not so much an error message as just information about why your data is missing. The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule). Instead of just displaying a blank cell, it puts the message you have seen in.

You will need to redesign your report if Excel is your desired output format for this report.

|||

Geoff,

In your last statement in this thread,

"The Renderer cannot render data regions (list, table, matrix, subreport) nested inside other data regions (subreports inside lists are an exception to this rule)".

I dont understang this statement,currently i am facing with this type of issue only. I have a matrix ,in the data cell of the matrix ,i placed a list and placed a subreport inside it(SubReport has only one small table which acceopts a parameter from value in the column header).

Will it work for me as you said some thing "Execption" or Do i need to search for another alternative?

your suggestions are most valuable

Thank you,

Raj Deep.A

|||i have a matrix report that has 3 column groupings. Daily Date range across the top(Ex. 11/24,11/25, etc). The column groupings are numbers for WeekToDate, MonthToDate,ProjectToDate. So dates go across the top, then subtotals are grouped based up on the above 3 groups. Problem is when it switches from Nov to Dec 12/1 is missing and looks like it is moved to the end of the report right before the ProjectToDate subtotal. This 'problem' happens when exporting from Report Manager. Export from VS is fine.