Thursday, March 29, 2012

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
> *****************************************
>

No comments:

Post a Comment