PDF FORMAT

I am trying to use couple of PDF librararies to do some post processing on the PDF generated by reproting services but all the tools i have tried so far are unable to open PDFs generated by RS - however other PDF (which are not generated by RS) can be opened normally programatically. RS generated PDF can however be viewed using acrobat reader...really strange - has anyone run into this problem - what is so specific about RS generated PDFs?Hey, try thi
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
> I am trying to use couple of PDF librararies to do some post processing on the
PDF generated by reproting services but all the tools i have tried so far are
unable to open PDFs generated by RS - however other PDF (which are not generated
by RS) can be opened normally programatically. RS generated PDF can however be
viewed using acrobat reader...really strange - has anyone run into this
problem - what is so specific about RS generated PDFs?|||...sorry somthing is wrong w/my keyboard....it keeps posting although I'm not'a
click'in on |Send
Anyway, you may wish to try this...
Rename one of those pdf's to .TXT, then open w/Notepad and remove everything
after the EOF.
Then save, rename to .PDF and retry to open.
I have the same problem rendering a report from .Net web page w/param text and
cmd buttons.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
> I am trying to use couple of PDF librararies to do some post processing on the
PDF generated by reproting services but all the tools i have tried so far are
unable to open PDFs generated by RS - however other PDF (which are not generated
by RS) can be opened normally programatically. RS generated PDF can however be
viewed using acrobat reader...really strange - has anyone run into this
problem - what is so specific about RS generated PDFs?|||There is a bug in the PDF renderer which causes one of the offsets written
to the PDF file to be off by one byte. This doesn't impact Acrobat because
Acrobat automatically detects this situation and autorepairs the file, but
other tools may not be that smart. We have fixed this bug, and the fix will
be available in beta 3 of SQL Server 2005.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
>I am trying to use couple of PDF librararies to do some post processing on
>the PDF generated by reproting services but all the tools i have tried so
>far are unable to open PDFs generated by RS - however other PDF (which are
>not generated by RS) can be opened normally programatically. RS generated
>PDF can however be viewed using acrobat reader...really strange - has
>anyone run into this problem - what is so specific about RS generated PDFs?|||::::::::(((((((((
When is beta3 expected?
"Rajeev Karunakaran [MSFT]" wrote:
> There is a bug in the PDF renderer which causes one of the offsets written
> to the PDF file to be off by one byte. This doesn't impact Acrobat because
> Acrobat automatically detects this situation and autorepairs the file, but
> other tools may not be that smart. We have fixed this bug, and the fix will
> be available in beta 3 of SQL Server 2005.
> --
> Rajeev Karunakaran [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
> news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
> >I am trying to use couple of PDF librararies to do some post processing on
> >the PDF generated by reproting services but all the tools i have tried so
> >far are unable to open PDFs generated by RS - however other PDF (which are
> >not generated by RS) can be opened normally programatically. RS generated
> >PDF can however be viewed using acrobat reader...really strange - has
> >anyone run into this problem - what is so specific about RS generated PDFs?
>
>|||Not yet announced. One way to get news about Yukon is to subscribe to the
newsletter: http://www.microsoft.com/sql/yukon/productinfo/default.asp
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
news:98999417-9289-445D-AFC9-C4F4BF977FFF@.microsoft.com...
> ::::::::(((((((((
> When is beta3 expected?
>
> "Rajeev Karunakaran [MSFT]" wrote:
>> There is a bug in the PDF renderer which causes one of the offsets
>> written
>> to the PDF file to be off by one byte. This doesn't impact Acrobat
>> because
>> Acrobat automatically detects this situation and autorepairs the file,
>> but
>> other tools may not be that smart. We have fixed this bug, and the fix
>> will
>> be available in beta 3 of SQL Server 2005.
>> --
>> Rajeev Karunakaran [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Ashok Jain" <AshokJain@.discussions.microsoft.com> wrote in message
>> news:69163171-1AD3-49B1-B7D6-333116B1DAE2@.microsoft.com...
>> >I am trying to use couple of PDF librararies to do some post processing
>> >on
>> >the PDF generated by reproting services but all the tools i have tried
>> >so
>> >far are unable to open PDFs generated by RS - however other PDF (which
>> >are
>> >not generated by RS) can be opened normally programatically. RS
>> >generated
>> >PDF can however be viewed using acrobat reader...really strange - has
>> >anyone run into this problem - what is so specific about RS generated
>> >PDFs?
>>

PDF Export taking too long

I am using RS SP2 with SQL 2k SP4.
I have a fairly large report, in the region of a few hundred pages. It has a
couple of parameters that filters the data. I have it linked from a web
application and it goes directly to PDF. If the parameters are set the
report renders to PDF pretty quickly, the size runs from 1 page to 70 pages.
If we try to render the whole thing it just sits and sits and sits. I let it
run for an hour at one point at the report never appeared. The CPU is spiked
to 25% continually and eventually I have to do an iisreset to. Now I am
pretty sure, say 95% sure that this report worked fine with RS SP1 and SQL
2k SP3a.
So two questions.
Is there a known problem with large PDF exports?
Does anyone know if any third parties are selling PDF rendering extensions
for sql reporting services? I know there is at least one for Excel.So 1 - 70 pages is fast. How many pages is it if it is the whole thing? PDF
rendering and Excel rendering are very resource intensive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <atelford6@.hotmail.nospam.com> wrote in message
news:O7cFPTVYFHA.2768@.tk2msftngp13.phx.gbl...
>I am using RS SP2 with SQL 2k SP4.
> I have a fairly large report, in the region of a few hundred pages. It has
> a couple of parameters that filters the data. I have it linked from a web
> application and it goes directly to PDF. If the parameters are set the
> report renders to PDF pretty quickly, the size runs from 1 page to 70
> pages. If we try to render the whole thing it just sits and sits and sits.
> I let it run for an hour at one point at the report never appeared. The
> CPU is spiked to 25% continually and eventually I have to do an iisreset
> to. Now I am pretty sure, say 95% sure that this report worked fine with
> RS SP1 and SQL 2k SP3a.
> So two questions.
> Is there a known problem with large PDF exports?
> Does anyone know if any third parties are selling PDF rendering extensions
> for sql reporting services? I know there is at least one for Excel.
>|||Good news and bad news
Good news is I have figured out the problem. Bad news is it does appear to
come from a PDF rendering bug.
We mad a minor change to the report and uploaded it, which is when we saw
the problem. I rolled back the report, redeployed and all is well, renders
290 pages in around 20 seconds.
The report has a table with 4 groups. On the third group we added a single
blank row above the group row. The group row contains some text. So for
groups #3 we have two header rows, one blank the other has a datafield. We
basically wanted to add some whitespace. With that extra blank row the
report with null parameters will not render and just pegs the CPU. If we
remove the row it works fine. If we supply a parameter to filter the report
it will render in both cases. I don't know at what point it breaks and I
don't really have the time to mess with it.
I will leave it without the whitespace for now but its very annoying to have
such a simple report change break the rendering.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%230WlwdVYFHA.3864@.TK2MSFTNGP10.phx.gbl...
> So 1 - 70 pages is fast. How many pages is it if it is the whole thing?
> PDF rendering and Excel rendering are very resource intensive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alex" <atelford6@.hotmail.nospam.com> wrote in message
> news:O7cFPTVYFHA.2768@.tk2msftngp13.phx.gbl...
>>I am using RS SP2 with SQL 2k SP4.
>> I have a fairly large report, in the region of a few hundred pages. It
>> has a couple of parameters that filters the data. I have it linked from a
>> web application and it goes directly to PDF. If the parameters are set
>> the report renders to PDF pretty quickly, the size runs from 1 page to 70
>> pages. If we try to render the whole thing it just sits and sits and
>> sits. I let it run for an hour at one point at the report never appeared.
>> The CPU is spiked to 25% continually and eventually I have to do an
>> iisreset to. Now I am pretty sure, say 95% sure that this report worked
>> fine with RS SP1 and SQL 2k SP3a.
>> So two questions.
>> Is there a known problem with large PDF exports?
>> Does anyone know if any third parties are selling PDF rendering
>> extensions for sql reporting services? I know there is at least one for
>> Excel.
>

PDF Document Map Hierarchy

I've notice a couple other posts about this issue, but could not seem
to find any responses/resolutions.
I have a table with multiple groups. In HTML the document map
hierarchy looks fine. In PDF there is no hierarchy.
Thanks for any help with this.
Example - HTML:
- Sex
- Male
- Age
- 35
- 40
- 45
- Female
- Age
- 35
- 40
- 45
Example - PDF:
Sex
Male
Age
35
40
45
Female
Age
35
40
45Hi Bob,
how did you get the hierarchy in HTML and preview? I have no hierarchy at
all.
thanks
Matt
"BobA" <robert.ames@.mercer.com> wrote in message
news:b7b93183.0410051203.4d37c984@.posting.google.com...
> I've notice a couple other posts about this issue, but could not seem
> to find any responses/resolutions.
> I have a table with multiple groups. In HTML the document map
> hierarchy looks fine. In PDF there is no hierarchy.
> Thanks for any help with this.
> Example - HTML:
> - Sex
> - Male
> - Age
> - 35
> - 40
> - 45
> - Female
> - Age
> - 35
> - 40
> - 45
> Example - PDF:
> Sex
> Male
> Age
> 35
> 40
> 45
> Female
> Age
> 35
> 40
> 45|||Thanks, I figured it out. I needed to set the document map against the
group not the element in the table.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> Hi Bob,
> how did you get the hierarchy in HTML and preview? I have no hierarchy at
> all.
> thanks
> Matt
>
> "BobA" <robert.ames@.mercer.com> wrote in message
> news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > I've notice a couple other posts about this issue, but could not seem
> > to find any responses/resolutions.
> >
> > I have a table with multiple groups. In HTML the document map
> > hierarchy looks fine. In PDF there is no hierarchy.
> >
> > Thanks for any help with this.
> >
> > Example - HTML:
> >
> > - Sex
> > - Male
> > - Age
> > - 35
> > - 40
> > - 45
> > - Female
> > - Age
> > - 35
> > - 40
> > - 45
> >
> > Example - PDF:
> >
> > Sex
> > Male
> > Age
> > 35
> > 40
> > 45
> > Female
> > Age
> > 35
> > 40
> > 45
>|||This is still an issue. Are there any ideas on how to fix this
problem?
Matt wrote:
> Thanks, I figured it out. I needed to set the document map against
the
> group not the element in the table.
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > Hi Bob,
> >
> > how did you get the hierarchy in HTML and preview? I have no
hierarchy at
> > all.
> >
> > thanks
> >
> > Matt
> >
> >
> > "BobA" <robert.ames@.mercer.com> wrote in message
> > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > I've notice a couple other posts about this issue, but could not
seem
> > > to find any responses/resolutions.
> > >
> > > I have a table with multiple groups. In HTML the document map
> > > hierarchy looks fine. In PDF there is no hierarchy.
> > >
> > > Thanks for any help with this.
> > >
> > > Example - HTML:
> > >
> > > - Sex
> > > - Male
> > > - Age
> > > - 35
> > > - 40
> > > - 45
> > > - Female
> > > - Age
> > > - 35
> > > - 40
> > > - 45
> > >
> > > Example - PDF:
> > >
> > > Sex
> > > Male
> > > Age
> > > 35
> > > 40
> > > 45
> > > Female
> > > Age
> > > 35
> > > 40
> > > 45
> >
> >|||Hi Bob,
I am facing the same dilema. The Document map hierarchy appears flat when
you export to PDF. Very annoying!!!
Thanks,
Terry
"BobA" wrote:
> This is still an issue. Are there any ideas on how to fix this
> problem?
> Matt wrote:
> > Thanks, I figured it out. I needed to set the document map against
> the
> > group not the element in the table.
> >
> > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > > Hi Bob,
> > >
> > > how did you get the hierarchy in HTML and preview? I have no
> hierarchy at
> > > all.
> > >
> > > thanks
> > >
> > > Matt
> > >
> > >
> > > "BobA" <robert.ames@.mercer.com> wrote in message
> > > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > > I've notice a couple other posts about this issue, but could not
> seem
> > > > to find any responses/resolutions.
> > > >
> > > > I have a table with multiple groups. In HTML the document map
> > > > hierarchy looks fine. In PDF there is no hierarchy.
> > > >
> > > > Thanks for any help with this.
> > > >
> > > > Example - HTML:
> > > >
> > > > - Sex
> > > > - Male
> > > > - Age
> > > > - 35
> > > > - 40
> > > > - 45
> > > > - Female
> > > > - Age
> > > > - 35
> > > > - 40
> > > > - 45
> > > >
> > > > Example - PDF:
> > > >
> > > > Sex
> > > > Male
> > > > Age
> > > > 35
> > > > 40
> > > > 45
> > > > Female
> > > > Age
> > > > 35
> > > > 40
> > > > 45
> > >
> > >
>|||Hi,
I have the same issue also. Did anyone ever find a solution to it?
Thanks,
Melissa
"Terry" wrote:
> Hi Bob,
> I am facing the same dilema. The Document map hierarchy appears flat when
> you export to PDF. Very annoying!!!
> Thanks,
> Terry
> "BobA" wrote:
> > This is still an issue. Are there any ideas on how to fix this
> > problem?
> >
> > Matt wrote:
> > > Thanks, I figured it out. I needed to set the document map against
> > the
> > > group not the element in the table.
> > >
> > > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > > news:ulf3e8ArEHA.1152@.TK2MSFTNGP11.phx.gbl...
> > > > Hi Bob,
> > > >
> > > > how did you get the hierarchy in HTML and preview? I have no
> > hierarchy at
> > > > all.
> > > >
> > > > thanks
> > > >
> > > > Matt
> > > >
> > > >
> > > > "BobA" <robert.ames@.mercer.com> wrote in message
> > > > news:b7b93183.0410051203.4d37c984@.posting.google.com...
> > > > > I've notice a couple other posts about this issue, but could not
> > seem
> > > > > to find any responses/resolutions.
> > > > >
> > > > > I have a table with multiple groups. In HTML the document map
> > > > > hierarchy looks fine. In PDF there is no hierarchy.
> > > > >
> > > > > Thanks for any help with this.
> > > > >
> > > > > Example - HTML:
> > > > >
> > > > > - Sex
> > > > > - Male
> > > > > - Age
> > > > > - 35
> > > > > - 40
> > > > > - 45
> > > > > - Female
> > > > > - Age
> > > > > - 35
> > > > > - 40
> > > > > - 45
> > > > >
> > > > > Example - PDF:
> > > > >
> > > > > Sex
> > > > > Male
> > > > > Age
> > > > > 35
> > > > > 40
> > > > > 45
> > > > > Female
> > > > > Age
> > > > > 35
> > > > > 40
> > > > > 45
> > > >
> > > >
> >
> >