Exporting report (with graph subreport) to PDF

Hi All,
This is my first reporting services post (as I am pretty new to
working with this new technology), so if I am unclear on anything or
ignorant on anything please forgive me!
Current Situation:
--
I am exporting a report to PDF (in a Windows service). The parent
report is exporting correctly, but a subreport is erroring out. This
subreport is simply a graph at the bottom of the report, so it is
pretty crucial to the report that it is shown. The method I am using
to export this report is LocalReport.Render.
Things to keep in mind:
--
I am developing this service in VS 2005 in c#.
Is this even possible?Have you applied SQL Server 2005 SP2 to your development machine?
If not try this since applying that will also update the ReportViewer
control and the rest of the client components as well.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Exporting report (with graph subreport) to PDF
> Date: Mon, 08 Oct 2007 12:41:31 -0000
> Organization: http://groups.google.com
> Lines: 24
> Hi All,
> This is my first reporting services post (as I am pretty new to
> working with this new technology), so if I am unclear on anything or
> ignorant on anything please forgive me!
>
> Current Situation:
> --
> I am exporting a report to PDF (in a Windows service). The parent
> report is exporting correctly, but a subreport is erroring out. This
> subreport is simply a graph at the bottom of the report, so it is
> pretty crucial to the report that it is shown. The method I am using
> to export this report is LocalReport.Render.
>
> Things to keep in mind:
> --
> I am developing this service in VS 2005 in c#.
>
> Is this even possible?
>|||On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Have you applied SQL Server 2005 SP2 to your development machine?
> If not try this since applying that will also update the ReportViewer
> control and the rest of the client components as well.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: MattW <mdw...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Exporting report (with graph subreport) to PDF
> > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > Organization:http://groups.google.com
> > Lines: 24
> > Hi All,
> > This is my first reporting services post (as I am pretty new to
> > working with this new technology), so if I am unclear on anything or
> > ignorant on anything please forgive me!
> > Current Situation:
> > --
> > I am exporting a report to PDF (in a Windows service). The parent
> > report is exporting correctly, but a subreport is erroring out. This
> > subreport is simply a graph at the bottom of the report, so it is
> > pretty crucial to the report that it is shown. The method I am using
> > to export this report is LocalReport.Render.
> > Things to keep in mind:
> > --
> > I am developing this service in VS 2005 in c#.
> > Is this even possible... Hide quoted text -
> - Show quoted text -
Thanks Chris ... That did the trick!|||Not a problem :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: MattW <mdw233@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Exporting report (with graph subreport) to PDF
> Date: Tue, 09 Oct 2007 13:38:21 -0000
> On Oct 8, 9:57 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Have you applied SQL Server 2005 SP2 to your development machine?
> >
> > If not try this since applying that will also update the ReportViewer
> > control and the rest of the client components as well.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> >
> >
> >
> > > From: MattW <mdw...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Exporting report (with graph subreport) to PDF
> > > Date: Mon, 08 Oct 2007 12:41:31 -0000
> > > Organization:http://groups.google.com
> > > Lines: 24
> >
> > > Hi All,
> >
> > > This is my first reporting services post (as I am pretty new to
> > > working with this new technology), so if I am unclear on anything or
> > > ignorant on anything please forgive me!
> >
> > > Current Situation:
> > > --
> > > I am exporting a report to PDF (in a Windows service). The parent
> > > report is exporting correctly, but a subreport is erroring out. This
> > > subreport is simply a graph at the bottom of the report, so it is
> > > pretty crucial to the report that it is shown. The method I am using
> > > to export this report is LocalReport.Render.
> >
> > > Things to keep in mind:
> > > --
> > > I am developing this service in VS 2005 in c#.
> >
> > > Is this even possible... Hide quoted text -
> >
> > - Show quoted text -
> Thanks Chris ... That did the trick!
>

Export to Excel - Multiple Columns

I have a pretty simple report that when exported to excel some columns span multiple excel columns?

Anybody know how to correct this?

The renderer tries to mimic the layout you created in the report designer. That may be the reason that some columns expand multiple columns.

Try the CSV renderer if you want very basic output.

|||

The renderer will merge columns in order to preserve the layout you defined in the RDL file.

Most often, merged cells are caused when there are report items either below or above the table that has borders that do not align precisely with the table columns.

A classic example of this is a single text box above the table acting as a header. If that textbox's left and right edges begin and end exactly at one of the below table's columns then merging should not occur.

-Chris