Exception Error while exporting to Excel

Hello,
I have a report that runs ok at the report manager. However, when I try to
export it to excel
I receive the following error message. Any ideas?
Thank you.
CD
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Item has already been added. Key in dictionary: "20" Key being
added: "20"
----
--
Microsoft Reporting ServicesDo you have a matrix in your report? Does the matrix has subtotals?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DC" <DC@.yahoo.com> wrote in message
news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
>
> Hello,
> I have a report that runs ok at the report manager. However, when I try to
> export it to excel
> I receive the following error message. Any ideas?
> Thank you.
> CD
> Reporting Services Error
> ----
--
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Item has already been added. Key in dictionary: "20" Key being
> added: "20"
> ----
--
> --
> Microsoft Reporting Services
>|||Yes, I do have a matrix report which has subtotals.
CD
"Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message
news:uBPuy1AnEHA.3292@.TK2MSFTNGP15.phx.gbl...
> Do you have a matrix in your report? Does the matrix has subtotals?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "DC" <DC@.yahoo.com> wrote in message
> news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> >
> >
> > Hello,
> > I have a report that runs ok at the report manager. However, when I try
to
> > export it to excel
> > I receive the following error message. Any ideas?
> >
> > Thank you.
> > CD
> >
> > Reporting Services Error
> ----
> --
> > --
> >
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > a.. Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > a.. Item has already been added. Key in dictionary: "20" Key being
> > added: "20"
> >
> ----
> --
> > --
> > Microsoft Reporting Services
> >
> >
>|||Here comes another bug. If you have a matrix with subtotals, you might
experience some difficulty while exporting reports to excel.
Here is the procedure I followed:
-Get rid of the total column.
-Deploy the report, check if export works.
-Put it back in.
-Deploy the report, check if export works.
When I apply column color changes it failed, and gave me the error message.
Even without color I am happy.
Regards,
Cem
"DC" <DC@.yahoo.com> wrote in message
news:eki3H7AnEHA.3628@.TK2MSFTNGP09.phx.gbl...
> Yes, I do have a matrix report which has subtotals.
> CD
>
> "Nico Cristache [MSFT]" <nipirvan@.microsoft.com> wrote in message
> news:uBPuy1AnEHA.3292@.TK2MSFTNGP15.phx.gbl...
> > Do you have a matrix in your report? Does the matrix has subtotals?
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "DC" <DC@.yahoo.com> wrote in message
> > news:eWjCLQAnEHA.2680@.TK2MSFTNGP15.phx.gbl...
> > >
> > >
> > > Hello,
> > > I have a report that runs ok at the report manager. However, when I
try
> to
> > > export it to excel
> > > I receive the following error message. Any ideas?
> > >
> > > Thank you.
> > > CD
> > >
> > > Reporting Services Error
> >
> ----
> > --
> > > --
> > >
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown. (rrRenderingError) Get Online Help
> > > a.. Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
was
> > > thrown.
> > > a.. Item has already been added. Key in dictionary: "20" Key
being
> > > added: "20"
> > >
> >
> ----
> > --
> > > --
> > > Microsoft Reporting Services
> > >
> > >
> >
> >
>

Excel Missing Rows (Managed NewsGroup Post)

Hello,
I am posting this through the MSDN Managed NewsGroup section. We are
experiencing the following problem:
When programatically exporting MS Reporting Services Reports to Excel - the
last row turns up missing. This does not happen 100% of the time but enough
that we cannot reliably send out to customers.
If you have never seen this happen I can provide you with a zip file with
sample data and the report. The report is a very simple column style report
that uses a stored procedure.
We have checked the stored procedure and it is returning the appropriate
data. When viewing in HTML all of the rows show up - it is only when the
report is exported to Excel that the last row comes up missing.Microsoft,
Please contact me and I will forward the report and the dataset to reproduce
the prolem.
"chanley54" wrote:
> Hello,
> I am posting this through the MSDN Managed NewsGroup section. We are
> experiencing the following problem:
> When programatically exporting MS Reporting Services Reports to Excel - the
> last row turns up missing. This does not happen 100% of the time but enough
> that we cannot reliably send out to customers.
> If you have never seen this happen I can provide you with a zip file with
> sample data and the report. The report is a very simple column style report
> that uses a stored procedure.
> We have checked the stored procedure and it is returning the appropriate
> data. When viewing in HTML all of the rows show up - it is only when the
> report is exported to Excel that the last row comes up missing.

Excel Merged Cells

Hi

I'm trying to eliminate merged cells when exporting a report to Excel. My problem being my report textbox above my table.

I've searched and found that making the textbox the same width as the first column eliminates the merging. Perfect, it does. But when the report is viewed in the report viewer, the textbox can only expand vertically. So the title looks terrible because column one is not wide.

I've read that expand horizontally is not an option I don't seem to be able to tell it not to output that text box, which would be an option if there is no other answer I can't have the text box the size I want it, due it creating merged cells I don't want to export it as a CSV

Are there any other options available or am missing something?

Cheers

You can try making the text box the same size as the first and second column or first second and third column if you need your textbox to be larger to accomodate its contents. It's not necessarily the size as much as that it aligns perfectly with one of the columns. I have had a really bad time with the merging of cells also. Sometimes I have to just handle it on the excel side by deleting the title out and then unmerging the merged columns.|||

Thanks for the reply KimberlyL. I tried this and it didn't work. I've tried it again today, making my title text box the width of 5 columns in my table and it still doesn't work, I get merged cells. If I make it the width of 4 columns then I don't get merged cells. So I've reduced the font size so it fits.

It's very strange, I wish I understood why, but at least it works for now

Cheers

|||

If you are exporting to Excel you can't really get rid of the cell merging, not unless you want to write your own renderer. I have read that the RS team is going to look at this problem sometime in the future.

I also had a customer who complained about this, he was trying to copy report values from one spreadsheet to another. In the end i just advised him on the quickest way to unmerge cells: press Ctrl+a, ctrl+1, select the Alignment tab, and deselect the merge cells checkbox. This has kept him quiet

|||

That is what customers had been doing with this report too. But it's not ideal is it! I've also had to remove an image that was placed at the top right of the page header as alligning that up with columns, or anything else I can think of, still adds extra cells and merged cells.

But it does what I want it to do for now. I can see me revisiting this, I just hope the problem has been looked at before I need to!

|||I remember seeing on one of the blogs that sometimes no matter what you do that you can still end up with merged cells. Something about the internal math and rounding that the renderer does. Yes it is very frustrating. I hope that this is fixed in a future release.