PDF expport and printing problem

Hello -
I am trying to export a report to PDF format and receive this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index was out of range. Must be non-negative and less than the size of the
collection. Parameter name: index
When I try to print my report this print error is displayed:
"An error occured during printing. (0x80004005)"
The report exports just fine to Excel and other reports export to PDF &
print just fine.
A previous post from Bruce Johnson referred to report language settings and
I am not sure which setting to verify.
I am running Reporting Services SP2.
Thanks,
PaulHello Paul -
Did you ever figure this error out? I am having the same issue. Thanks.
Mitch
mlake@.3plcorp.com
"Paul Ennamorato" wrote:
> Hello -
> I am trying to export a report to PDF format and receive this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index was out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index
> When I try to print my report this print error is displayed:
> "An error occured during printing. (0x80004005)"
> The report exports just fine to Excel and other reports export to PDF &
> print just fine.
> A previous post from Bruce Johnson referred to report language settings and
> I am not sure which setting to verify.
> I am running Reporting Services SP2.
> Thanks,
> Paul|||Mitch -
Thanks for your reply. We have not yet determined what causes this error
message.
Regards,
Paul
"Mitch Lake" wrote:
> Hello Paul -
> Did you ever figure this error out? I am having the same issue. Thanks.
> Mitch
> mlake@.3plcorp.com
> "Paul Ennamorato" wrote:
> > Hello -
> >
> > I am trying to export a report to PDF format and receive this error:
> >
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. (rrRenderingError) Get Online Help
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown.
> > Index was out of range. Must be non-negative and less than the size of the
> > collection. Parameter name: index
> >
> > When I try to print my report this print error is displayed:
> >
> > "An error occured during printing. (0x80004005)"
> >
> > The report exports just fine to Excel and other reports export to PDF &
> > print just fine.
> >
> > A previous post from Bruce Johnson referred to report language settings and
> > I am not sure which setting to verify.
> >
> > I am running Reporting Services SP2.
> >
> > Thanks,
> >
> > Paul|||Well, I never did figure out what was happening, but SP2 seems to have fixed
the problem. I was able to isolate it down to a particular group footer and
then got the "bright" idea to check for a service pack. Installed to
development and server and all is good again.
Mitch
"Paul Ennamorato" wrote:
> Mitch -
> Thanks for your reply. We have not yet determined what causes this error
> message.
> Regards,
> Paul
> "Mitch Lake" wrote:
> > Hello Paul -
> >
> > Did you ever figure this error out? I am having the same issue. Thanks.
> >
> > Mitch
> > mlake@.3plcorp.com
> >
> > "Paul Ennamorato" wrote:
> >
> > > Hello -
> > >
> > > I am trying to export a report to PDF format and receive this error:
> > >
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > > thrown. (rrRenderingError) Get Online Help
> > > Exception of type
> > > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > > thrown.
> > > Index was out of range. Must be non-negative and less than the size of the
> > > collection. Parameter name: index
> > >
> > > When I try to print my report this print error is displayed:
> > >
> > > "An error occured during printing. (0x80004005)"
> > >
> > > The report exports just fine to Excel and other reports export to PDF &
> > > print just fine.
> > >
> > > A previous post from Bruce Johnson referred to report language settings and
> > > I am not sure which setting to verify.
> > >
> > > I am running Reporting Services SP2.
> > >
> > > Thanks,
> > >
> > > Paul

PDF export problem

Hi,
When I try to export my report to PDF it throws me this error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
Index and length must refer to a location within the string. Parameter name:
length
I'm using Reporting Services with SP1.
Thanks in AdvancePlease verify how you have the report Language property set.
If you do not have Language property set to a language-country pair (i.e.
en-us) you will get this error when exporting to PDF.
If you select Czech in Report Designer it will get serialized as "cs". To
workaround this issue you will need to select Czech (Czech Republic)
in Report Designer. This choice gets serialized as "cs-CZ".
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"VK" <kafkav@.cgcc.cz> wrote in message
news:OQO0WvQsEHA.2688@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When I try to export my report to PDF it throws me this error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Index and length must refer to a location within the string. Parameter
> name: length
>
> I'm using Reporting Services with SP1.
> Thanks in Advance
>sql

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF Export error in reporting services 2000

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

amit_800 wrote:

Hi,

I am exporting my report in PDF format and i am getting following error:-

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Font 'Arial' doesn't support style 'Regular'.

I am using sql server2000 reporting services....

can anyone help !

thanks

|||

I have seen this only once before and reinstalling the Arial font fixed this issue. The error message you see comes from the Windows GDI library. To reinstall Arial, do the following. Note that these instructions are for Windows XP or Windows Server 2003 only.

1. In Windows Explorer, navigate to C:\Windows\Fonts

2. Right-click the Arial (TrueType) font and select delete

3. Reboot

4. Expand Arial.tt_ from the i386 or AMD64 directory on your Windows CD to a directory on your hard drive. To expand, you can use the expand.exe file in the i386/amd64 directory or an application like 7-Zip.

5. In Windows Explorer, navigate to C:\Windows\Fonts

6. From the File menu, choose Install New Font and then select the Arial.TTF file you expanded.

7. Reboot

Thanks.

PDF export error

I've created a report and it works fine in html,
but when I export to PDF, I receive next error:
Reporting Services Error
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError)
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown
Index and length must refer to a location within the string.
Parameter name: length
Any suggestions please?
Regards,
Miguel.Check what the report language property is set to. If it's not a
language-country pair, you might run into this error. For instance, if you
choose "English", this error might occur. Change it to a language-country
pair (for example en-US).
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Miguel Esteban" <mestebanpt@.yahoo.es> wrote in message
news:eUEQ258cEHA.3420@.TK2MSFTNGP12.phx.gbl...
> I've created a report and it works fine in html,
> but when I export to PDF, I receive next error:
> Reporting Services Error
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError)
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown
> Index and length must refer to a location within the string.
> Parameter name: length
>
> Any suggestions please?
> Regards,
> Miguel.
>

PDF export error

When I try to export a 2400 pages report to pdf get the reporting services
error:
exception of type Microsoft.Reporting.Services.ReportRenderingException was
thrown. index was out of range. Must be non-negative and less than the size
of the collection. Parameter name: index.
The report ran before SP2 fine and after SP2 fine too.
Any help will be greatly appreciated.These are the error I get when debug.
A first chance exception of type 'System.ArgumentOutOfRangeException'
occurred in mscorlib.dll
Additional information: Index was out of range. Must be non-negative and
less than the size of the collection.
--
A first chance exception of type
'Microsoft.ReportingServices.ReportRendering.ReportRenderingException'
occurred in microsoft.reportingservices.imagerendering.dll
--
A first chance exception of type
'Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException' occurred in microsoft.reportingservices.processing.dll
Additional information: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
--
A first chance exception of type
'Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException' occurred in microsoft.reportingservices.processing.dll
Additional information: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
"Ehsan Khan" wrote:
> When I try to export a 2400 pages report to pdf get the reporting services
> error:
> exception of type Microsoft.Reporting.Services.ReportRenderingException was
> thrown. index was out of range. Must be non-negative and less than the size
> of the collection. Parameter name: index.
> The report ran before SP2 fine and after SP2 fine too.
> Any help will be greatly appreciated.

Password Protected Excel File

Hi

I'm in need of a bit of assitance here. Basically I am currently creating a SSIS package which works in principle with the exception of my data flow.

On my data flow I am reading an excel file using the excel source, this works fine for a number of my examples but one of the excel files is password protected. This is throwing an error when I try to run the package.

Does anyone know how to read a password protected excel file?

Thanks
Kismet123You cannot access a password-protected Excel file using the Jet OLE DB Provider, period.

I probably shouldn't mention this, but as an interesting tidbit of useless knowledge, the Provider can access the file if it is open at the same time in the Excel application...and without even providing the password. But doing so causes a huge memory leak in the Excel process that's going to bring things down sooner or later.
Q319998 BUG: Memory Leak When You Query Open Excel Worksheet with ADO
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q319998

-Doug
|||Thanks for that information Doug. Could you possibly tell me what the Password property is referring to when you create an Excel Connection Manager. I thought it would have something to do with if the connection you are making is password protected.

Kismet