We setting up an intratnet site that is generating PDF output from Reporting
Services 2005.
The WWW Server for the applications is on ServerA
The SQL Server & Reporting Services are on ServerB
From ServerA we are generating a HTTP request to the Reporting Services to
generate the report.
The report is generated as a PDF.
Everything works fine, except that IE always askes if they want to Download
or Open the document.
We simply want it to not ask, and always Open the PDF.
The users will be in a locked Citrix enviornment, so even if we have to stop
it from asking for ANYTHING that is okay as well.
Any ideas?Earl, this is probably because the users have the Confirm open on download
checkbox checked for the PDF filetype. In the Windows Explorer goto Tools,
Folder options, Filetypes, find PDF, click Advanced. Same is true for many
other types like .Doc, Xsl etc.
Ed Richard
"Earl Bonovich" <earl.bonovich...nospam...@.dciinc.org> wrote in message
news:OPlbDBf9FHA.952@.TK2MSFTNGP12.phx.gbl...
> We setting up an intratnet site that is generating PDF output from
> Reporting Services 2005.
> The WWW Server for the applications is on ServerA
> The SQL Server & Reporting Services are on ServerB
> From ServerA we are generating a HTTP request to the Reporting Services to
> generate the report.
> The report is generated as a PDF.
> Everything works fine, except that IE always askes if they want to
> Download or Open the document.
> We simply want it to not ask, and always Open the PDF.
> The users will be in a locked Citrix enviornment, so even if we have to
> stop it from asking for ANYTHING that is okay as well.
> Any ideas?
>
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Friday, March 30, 2012
PDF-Reporting with SQL2005 Reporting Services
Hi All,
in SQL Server Business Intelligence Development Studio the reporting output
(for SQL2005 Reporting Services) can for instance be chosen as pdf or excel.
choosing pdf as output, if the tables contain more data than one DIN-A-4
page can display the tables are continued on the next page. the table header
is fortunately also repeated on each new pdf-page.
however choosing excel as output, the whole output of one table is written
into one excel spreadsheet. even if the height of the table containing the
data is more than the height of DIN-A-4 then the table is not continued on
another spreadsheet. this leads to the unfortunate phenomenon that printing
the excel workbook (with tables higher than DIN-A-4) results in DIN-A-4
printouts in which the table header is unfortunately NOT repeated on each
new printout-page. (this is due to the fact that the tables in the
spreadsheets are highre than DIN-A-4.)
unfortunately in our case the generated pdf output can not used to be
printed, because for each report there have to made slight adjustments by
each user which cannot be processed within the reporting workflow.
hence we really need a solution to programmatically adjust the excel-output
provided by the SQL Server Business Intelligence Development Studio so that
within the excel-output the spreadsheets will have the same page breaks like
the pdf-pages within the pdf-output.
we are desperately looking for a solution for this issue. can anybody state
A) if it is either impossible or
B) if it would be possible and which steps would be involved to achieve this
aim?
thanks a lot in advance for your assistance!
best regards, janHi All,
doesn't anybody have an idea on how to generate Excel-Reportings with
SQL2005 Reporting Services (with tables in the spreadsheets that are higher
than DIN-A-4 printouts) which are printable?
Has anybody yet managed to generate Excel-Output and make this output
printable so that on each printed DIN-A-4-printout the table headers are
repeated and the tables have correct page breaks?
best regards, jan
"Jan" <no@.no.com> schrieb im Newsbeitrag
news:OEjOaBiGHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> in SQL Server Business Intelligence Development Studio the reporting
> output (for SQL2005 Reporting Services) can for instance be chosen as pdf
> or excel.
> choosing pdf as output, if the tables contain more data than one DIN-A-4
> page can display the tables are continued on the next page. the table
> header is fortunately also repeated on each new pdf-page.
> however choosing excel as output, the whole output of one table is written
> into one excel spreadsheet. even if the height of the table containing the
> data is more than the height of DIN-A-4 then the table is not continued on
> another spreadsheet. this leads to the unfortunate phenomenon that
> printing the excel workbook (with tables higher than DIN-A-4) results in
> DIN-A-4 printouts in which the table header is unfortunately NOT repeated
> on each new printout-page. (this is due to the fact that the tables in the
> spreadsheets are highre than DIN-A-4.)
> unfortunately in our case the generated pdf output can not used to be
> printed, because for each report there have to made slight adjustments by
> each user which cannot be processed within the reporting workflow.
> hence we really need a solution to programmatically adjust the
> excel-output provided by the SQL Server Business Intelligence Development
> Studio so that within the excel-output the spreadsheets will have the same
> page breaks like the pdf-pages within the pdf-output.
> we are desperately looking for a solution for this issue. can anybody
> state
> A) if it is either impossible or
> B) if it would be possible and which steps would be involved to achieve
> this aim?
> thanks a lot in advance for your assistance!
> best regards, jan
>
in SQL Server Business Intelligence Development Studio the reporting output
(for SQL2005 Reporting Services) can for instance be chosen as pdf or excel.
choosing pdf as output, if the tables contain more data than one DIN-A-4
page can display the tables are continued on the next page. the table header
is fortunately also repeated on each new pdf-page.
however choosing excel as output, the whole output of one table is written
into one excel spreadsheet. even if the height of the table containing the
data is more than the height of DIN-A-4 then the table is not continued on
another spreadsheet. this leads to the unfortunate phenomenon that printing
the excel workbook (with tables higher than DIN-A-4) results in DIN-A-4
printouts in which the table header is unfortunately NOT repeated on each
new printout-page. (this is due to the fact that the tables in the
spreadsheets are highre than DIN-A-4.)
unfortunately in our case the generated pdf output can not used to be
printed, because for each report there have to made slight adjustments by
each user which cannot be processed within the reporting workflow.
hence we really need a solution to programmatically adjust the excel-output
provided by the SQL Server Business Intelligence Development Studio so that
within the excel-output the spreadsheets will have the same page breaks like
the pdf-pages within the pdf-output.
we are desperately looking for a solution for this issue. can anybody state
A) if it is either impossible or
B) if it would be possible and which steps would be involved to achieve this
aim?
thanks a lot in advance for your assistance!
best regards, janHi All,
doesn't anybody have an idea on how to generate Excel-Reportings with
SQL2005 Reporting Services (with tables in the spreadsheets that are higher
than DIN-A-4 printouts) which are printable?
Has anybody yet managed to generate Excel-Output and make this output
printable so that on each printed DIN-A-4-printout the table headers are
repeated and the tables have correct page breaks?
best regards, jan
"Jan" <no@.no.com> schrieb im Newsbeitrag
news:OEjOaBiGHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi All,
> in SQL Server Business Intelligence Development Studio the reporting
> output (for SQL2005 Reporting Services) can for instance be chosen as pdf
> or excel.
> choosing pdf as output, if the tables contain more data than one DIN-A-4
> page can display the tables are continued on the next page. the table
> header is fortunately also repeated on each new pdf-page.
> however choosing excel as output, the whole output of one table is written
> into one excel spreadsheet. even if the height of the table containing the
> data is more than the height of DIN-A-4 then the table is not continued on
> another spreadsheet. this leads to the unfortunate phenomenon that
> printing the excel workbook (with tables higher than DIN-A-4) results in
> DIN-A-4 printouts in which the table header is unfortunately NOT repeated
> on each new printout-page. (this is due to the fact that the tables in the
> spreadsheets are highre than DIN-A-4.)
> unfortunately in our case the generated pdf output can not used to be
> printed, because for each report there have to made slight adjustments by
> each user which cannot be processed within the reporting workflow.
> hence we really need a solution to programmatically adjust the
> excel-output provided by the SQL Server Business Intelligence Development
> Studio so that within the excel-output the spreadsheets will have the same
> page breaks like the pdf-pages within the pdf-output.
> we are desperately looking for a solution for this issue. can anybody
> state
> A) if it is either impossible or
> B) if it would be possible and which steps would be involved to achieve
> this aim?
> thanks a lot in advance for your assistance!
> best regards, jan
>
Wednesday, March 28, 2012
PDF Rendering bug
We are trying to publish a group of financial reports using SQL Server
Reporting Services. We have hit a snag when we try to render the reports in
PDF format. The leading spaces of each line are stripped in the output
file. For example:
Department 10.7240 - ICU
Expenses SubDepartment
-- -
1,200 100
454 150
Becomes:
Department 10.7240 - ICU
Expenses SubDepartment
-- -
1,200 100
454 150
Does anyone know a solution for this problem? By the way, we did upgrade to SP2.
That did not correct the problem.
This blog entry (actually the comments for the entry) discusses same. Long story short, the PDF extension strips leading spaces in this version of SSRS, and there is no workaround :(
http://blogs.msdn.com/bimusings/archive/2005/06/15/429607.aspx
It sounds like you are "artificially" adding these spaces to make things line up. Can you re-position the textboxes which show the values and/or use the alignment settings to make the same thing happen?
|||Thanks for the information. Actually we are moving a fully formatted report from an old DEC Alpha system to .pdf files. Currently this is done manually. It is a process that involves cutting and pasting hundreds of pages of the original report into output for individual departments. The SSRS report consists of a single text box to hold the lines of the source report. That is why we have leading spaces.
We are able to do all the breakout of individual sections using SQL Server, but It looks like we will have to find another product to do the final conversion from text to .pdf. Actually, tiff files come out great, but they are huge and slow.
Thanks again for the good information.
PDF generation
What is implemented in the released version of Reporting Services concidering
generating PDF output directly out of reporting serivces?
The white paper says: â'You are not required to run any Adobe software on the
report server in order to render reports in PDF.â' In the hand book to
Reporting Services of Brian Larson it is written: ""First of all, you will
need some type of utility to produce output in a PDF format. This could be
Adobe's full version of Acrobat or some other utility."I have Reporting Services with service pack 1 on it and it can output
directly to PDF.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> What is implemented in the released version of Reporting Services
concidering
> generating PDF output directly out of reporting serivces?
> The white paper says: "You are not required to run any Adobe software on
the
> report server in order to render reports in PDF." In the hand book to
> Reporting Services of Brian Larson it is written: ""First of all, you will
> need some type of utility to produce output in a PDF format. This could be
> Adobe's full version of Acrobat or some other utility."
>|||Thank you very much for your help, Paul
"Paul" wrote:
> I have Reporting Services with service pack 1 on it and it can output
> directly to PDF.
>
> "pwi" <pwi@.discussions.microsoft.com> wrote in message
> news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> > What is implemented in the released version of Reporting Services
> concidering
> > generating PDF output directly out of reporting serivces?
> > The white paper says: "You are not required to run any Adobe software on
> the
> > report server in order to render reports in PDF." In the hand book to
> > Reporting Services of Brian Larson it is written: ""First of all, you will
> > need some type of utility to produce output in a PDF format. This could be
> > Adobe's full version of Acrobat or some other utility."
> >
>
>
generating PDF output directly out of reporting serivces?
The white paper says: â'You are not required to run any Adobe software on the
report server in order to render reports in PDF.â' In the hand book to
Reporting Services of Brian Larson it is written: ""First of all, you will
need some type of utility to produce output in a PDF format. This could be
Adobe's full version of Acrobat or some other utility."I have Reporting Services with service pack 1 on it and it can output
directly to PDF.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> What is implemented in the released version of Reporting Services
concidering
> generating PDF output directly out of reporting serivces?
> The white paper says: "You are not required to run any Adobe software on
the
> report server in order to render reports in PDF." In the hand book to
> Reporting Services of Brian Larson it is written: ""First of all, you will
> need some type of utility to produce output in a PDF format. This could be
> Adobe's full version of Acrobat or some other utility."
>|||Thank you very much for your help, Paul
"Paul" wrote:
> I have Reporting Services with service pack 1 on it and it can output
> directly to PDF.
>
> "pwi" <pwi@.discussions.microsoft.com> wrote in message
> news:73B22850-0B00-4CF5-80F6-3372B8E0CD58@.microsoft.com...
> > What is implemented in the released version of Reporting Services
> concidering
> > generating PDF output directly out of reporting serivces?
> > The white paper says: "You are not required to run any Adobe software on
> the
> > report server in order to render reports in PDF." In the hand book to
> > Reporting Services of Brian Larson it is written: ""First of all, you will
> > need some type of utility to produce output in a PDF format. This could be
> > Adobe's full version of Acrobat or some other utility."
> >
>
>
PDF Formatting Problem
Dear All,
I have written a database application in SQL and am using SQL Reporting
Services (for the first time) to generate the reports. I have come across a
problem to which I cannot see a solutions.
As part of the database application we store 'Visit Reports' which sales
people use to record information about customer that they have visited. I
have written a report which should display each record on a seperate page.
However, when someone has written a particularly long report and this spans 2
or more pages the report formats correctly on the screen, but when you export
to pdf you have the header information on 1 page (let's say the top 1/3 of
the page) and the detail of the report moves on to the next page. What I
want to happen is for the report to move on to a new page when appropriate
(i.e. when the 1st page is full).
Has anyone come across this? Is there a solution?
Thanks in advance,
Mike SwannIt looks like your report is either wider than 8½" or taller than 11".
Remember to take into account the body of your report, and the height of
header and footer (if there are any). I keep a safety margin of ½" to 1" to
avoid such issues.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> Dear All,
> I have written a database application in SQL and am using SQL Reporting
> Services (for the first time) to generate the reports. I have come across
> a
> problem to which I cannot see a solutions.
> As part of the database application we store 'Visit Reports' which sales
> people use to record information about customer that they have visited. I
> have written a report which should display each record on a seperate page.
> However, when someone has written a particularly long report and this
> spans 2
> or more pages the report formats correctly on the screen, but when you
> export
> to pdf you have the header information on 1 page (let's say the top 1/3 of
> the page) and the detail of the report moves on to the next page. What I
> want to happen is for the report to move on to a new page when appropriate
> (i.e. when the 1st page is full).
> Has anyone come across this? Is there a solution?
> Thanks in advance,
> Mike Swann|||Thanks for your response.
However, this is a UK A4 format and that is all correct. It is purely when
the report data forces it on to 2 pages. If there is only enough data for 1
page then it will convert to a pdf perfectly well.
Any other ideas?
Thanks
Mike
"Alain Quesnel" wrote:
> It looks like your report is either wider than 8½" or taller than 11".
> Remember to take into account the body of your report, and the height of
> header and footer (if there are any). I keep a safety margin of ½" to 1" to
> avoid such issues.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> >
> > Dear All,
> >
> > I have written a database application in SQL and am using SQL Reporting
> > Services (for the first time) to generate the reports. I have come across
> > a
> > problem to which I cannot see a solutions.
> >
> > As part of the database application we store 'Visit Reports' which sales
> > people use to record information about customer that they have visited. I
> > have written a report which should display each record on a seperate page.
> > However, when someone has written a particularly long report and this
> > spans 2
> > or more pages the report formats correctly on the screen, but when you
> > export
> > to pdf you have the header information on 1 page (let's say the top 1/3 of
> > the page) and the detail of the report moves on to the next page. What I
> > want to happen is for the report to move on to a new page when appropriate
> > (i.e. when the 1st page is full).
> >
> > Has anyone come across this? Is there a solution?
> >
> > Thanks in advance,
> >
> > Mike Swann
>|||You say that your header occupies 1/3 of the page. Did you try a smaller
header? Or no header at all?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:D41B4154-8BDA-4534-9B60-3619D81E995E@.microsoft.com...
> Thanks for your response.
> However, this is a UK A4 format and that is all correct. It is purely
> when
> the report data forces it on to 2 pages. If there is only enough data for
> 1
> page then it will convert to a pdf perfectly well.
> Any other ideas?
> Thanks
> Mike
>
> "Alain Quesnel" wrote:
>> It looks like your report is either wider than 8½" or taller than 11".
>> Remember to take into account the body of your report, and the height of
>> header and footer (if there are any). I keep a safety margin of ½" to 1"
>> to
>> avoid such issues.
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
>> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
>> >
>> > Dear All,
>> >
>> > I have written a database application in SQL and am using SQL Reporting
>> > Services (for the first time) to generate the reports. I have come
>> > across
>> > a
>> > problem to which I cannot see a solutions.
>> >
>> > As part of the database application we store 'Visit Reports' which
>> > sales
>> > people use to record information about customer that they have visited.
>> > I
>> > have written a report which should display each record on a seperate
>> > page.
>> > However, when someone has written a particularly long report and this
>> > spans 2
>> > or more pages the report formats correctly on the screen, but when you
>> > export
>> > to pdf you have the header information on 1 page (let's say the top 1/3
>> > of
>> > the page) and the detail of the report moves on to the next page. What
>> > I
>> > want to happen is for the report to move on to a new page when
>> > appropriate
>> > (i.e. when the 1st page is full).
>> >
>> > Has anyone come across this? Is there a solution?
>> >
>> > Thanks in advance,
>> >
>> > Mike Swann
>>
I have written a database application in SQL and am using SQL Reporting
Services (for the first time) to generate the reports. I have come across a
problem to which I cannot see a solutions.
As part of the database application we store 'Visit Reports' which sales
people use to record information about customer that they have visited. I
have written a report which should display each record on a seperate page.
However, when someone has written a particularly long report and this spans 2
or more pages the report formats correctly on the screen, but when you export
to pdf you have the header information on 1 page (let's say the top 1/3 of
the page) and the detail of the report moves on to the next page. What I
want to happen is for the report to move on to a new page when appropriate
(i.e. when the 1st page is full).
Has anyone come across this? Is there a solution?
Thanks in advance,
Mike SwannIt looks like your report is either wider than 8½" or taller than 11".
Remember to take into account the body of your report, and the height of
header and footer (if there are any). I keep a safety margin of ½" to 1" to
avoid such issues.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> Dear All,
> I have written a database application in SQL and am using SQL Reporting
> Services (for the first time) to generate the reports. I have come across
> a
> problem to which I cannot see a solutions.
> As part of the database application we store 'Visit Reports' which sales
> people use to record information about customer that they have visited. I
> have written a report which should display each record on a seperate page.
> However, when someone has written a particularly long report and this
> spans 2
> or more pages the report formats correctly on the screen, but when you
> export
> to pdf you have the header information on 1 page (let's say the top 1/3 of
> the page) and the detail of the report moves on to the next page. What I
> want to happen is for the report to move on to a new page when appropriate
> (i.e. when the 1st page is full).
> Has anyone come across this? Is there a solution?
> Thanks in advance,
> Mike Swann|||Thanks for your response.
However, this is a UK A4 format and that is all correct. It is purely when
the report data forces it on to 2 pages. If there is only enough data for 1
page then it will convert to a pdf perfectly well.
Any other ideas?
Thanks
Mike
"Alain Quesnel" wrote:
> It looks like your report is either wider than 8½" or taller than 11".
> Remember to take into account the body of your report, and the height of
> header and footer (if there are any). I keep a safety margin of ½" to 1" to
> avoid such issues.
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
> >
> > Dear All,
> >
> > I have written a database application in SQL and am using SQL Reporting
> > Services (for the first time) to generate the reports. I have come across
> > a
> > problem to which I cannot see a solutions.
> >
> > As part of the database application we store 'Visit Reports' which sales
> > people use to record information about customer that they have visited. I
> > have written a report which should display each record on a seperate page.
> > However, when someone has written a particularly long report and this
> > spans 2
> > or more pages the report formats correctly on the screen, but when you
> > export
> > to pdf you have the header information on 1 page (let's say the top 1/3 of
> > the page) and the detail of the report moves on to the next page. What I
> > want to happen is for the report to move on to a new page when appropriate
> > (i.e. when the 1st page is full).
> >
> > Has anyone come across this? Is there a solution?
> >
> > Thanks in advance,
> >
> > Mike Swann
>|||You say that your header occupies 1/3 of the page. Did you try a smaller
header? Or no header at all?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
news:D41B4154-8BDA-4534-9B60-3619D81E995E@.microsoft.com...
> Thanks for your response.
> However, this is a UK A4 format and that is all correct. It is purely
> when
> the report data forces it on to 2 pages. If there is only enough data for
> 1
> page then it will convert to a pdf perfectly well.
> Any other ideas?
> Thanks
> Mike
>
> "Alain Quesnel" wrote:
>> It looks like your report is either wider than 8½" or taller than 11".
>> Remember to take into account the body of your report, and the height of
>> header and footer (if there are any). I keep a safety margin of ½" to 1"
>> to
>> avoid such issues.
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Mike Swann" <MikeSwann@.discussions.microsoft.com> wrote in message
>> news:C806740E-EE41-4E99-9F71-4D0610E6B7F2@.microsoft.com...
>> >
>> > Dear All,
>> >
>> > I have written a database application in SQL and am using SQL Reporting
>> > Services (for the first time) to generate the reports. I have come
>> > across
>> > a
>> > problem to which I cannot see a solutions.
>> >
>> > As part of the database application we store 'Visit Reports' which
>> > sales
>> > people use to record information about customer that they have visited.
>> > I
>> > have written a report which should display each record on a seperate
>> > page.
>> > However, when someone has written a particularly long report and this
>> > spans 2
>> > or more pages the report formats correctly on the screen, but when you
>> > export
>> > to pdf you have the header information on 1 page (let's say the top 1/3
>> > of
>> > the page) and the detail of the report moves on to the next page. What
>> > I
>> > want to happen is for the report to move on to a new page when
>> > appropriate
>> > (i.e. when the 1st page is full).
>> >
>> > Has anyone come across this? Is there a solution?
>> >
>> > Thanks in advance,
>> >
>> > Mike Swann
>>
Monday, March 26, 2012
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?
>>
"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 files with images get unexpectedly large in SQL Server 2000 Reporting Services
When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?
Can anyone give me a hint on this one?
Thanks,
Neno
There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.
|||i want to download some programme so i need urgent thanks
|||
I would suggest installing RS SP2 and the latest QFE available (KB912424).
Thank you,
Nico
|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services
When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?
Can anyone give me a hint on this one?
Thanks,
Neno
There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.
|||i want to download some programme so i need urgent thanks
|||
I would suggest installing RS SP2 and the latest QFE available (KB912424).
Thank you,
Nico
|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211sqlPDF files with images get unexpectedly large in SQL Server 2000 Reporting Services
When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression)?
Can anyone give me a hint on this one?
Thanks,
Neno
There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into.
|||i want to download some programme so i need urgent thanks
|||
I would suggest installing RS SP2 and the latest QFE available (KB912424).
Thank you,
Nico
|||This problem still occurs in SQL Reporting 2005 localreports. An issue has been opened for this problem. Please add your vote. https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=232211PDF Export Very SLOW ! MS Rerporting Services TEAM Where Are you ??
Hi,
I have a matrix report that produce 79 pages on the HTML browser in 30
seconds, but
if I try to export the report in a PDF format it take more than 1 our !!!
The system configuration is:
IBM Server with 2 Pentium Xeon of 2.4 Ghz
1 Gb of RAM
Fast network HD
Windows 2003 Server SP1 (SBS)
SQL Server 2000 SP4
Rerpoting Services SP2
Do you have any idea about this problem ?
I've saw there are some old messages about this problem on this newsgroup,
but nobody of the
Microsoft Rerpoting Service Team has reply !!!
I think this is a very important issue, that can KILL the reportin services
system on a
Serious Real World company application.
Thanks.
Cesar Augusto Flavio De Min.
MCSDEven 30 seconds for HTML is very slow. PDF definitely is much much slower.
Everything is done in RAM. 1 GB of RAM is pretty minimal. Is your data on
this server as well or just RS? Can you add more RAM to it. Perhaps bring it
up to 2 Gig. Also, an 80 page report while not huge is most likely taking
time due to complexity. You could try splitting it up into multiple reports.
I don't know if RS 2005 has improved performance of PDF rendering or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cesar Augusto Flavio De Min" <cdemin_news@.yahoo.com> wrote in message
news:emEEYAO7FHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a matrix report that produce 79 pages on the HTML browser in 30
> seconds, but
> if I try to export the report in a PDF format it take more than 1 our !!!
> The system configuration is:
> IBM Server with 2 Pentium Xeon of 2.4 Ghz
> 1 Gb of RAM
> Fast network HD
> Windows 2003 Server SP1 (SBS)
> SQL Server 2000 SP4
> Rerpoting Services SP2
> Do you have any idea about this problem ?
> I've saw there are some old messages about this problem on this newsgroup,
> but nobody of the
> Microsoft Rerpoting Service Team has reply !!!
> I think this is a very important issue, that can KILL the reportin
> services system on a
> Serious Real World company application.
> Thanks.
> Cesar Augusto Flavio De Min.
> MCSD
>
I have a matrix report that produce 79 pages on the HTML browser in 30
seconds, but
if I try to export the report in a PDF format it take more than 1 our !!!
The system configuration is:
IBM Server with 2 Pentium Xeon of 2.4 Ghz
1 Gb of RAM
Fast network HD
Windows 2003 Server SP1 (SBS)
SQL Server 2000 SP4
Rerpoting Services SP2
Do you have any idea about this problem ?
I've saw there are some old messages about this problem on this newsgroup,
but nobody of the
Microsoft Rerpoting Service Team has reply !!!
I think this is a very important issue, that can KILL the reportin services
system on a
Serious Real World company application.
Thanks.
Cesar Augusto Flavio De Min.
MCSDEven 30 seconds for HTML is very slow. PDF definitely is much much slower.
Everything is done in RAM. 1 GB of RAM is pretty minimal. Is your data on
this server as well or just RS? Can you add more RAM to it. Perhaps bring it
up to 2 Gig. Also, an 80 page report while not huge is most likely taking
time due to complexity. You could try splitting it up into multiple reports.
I don't know if RS 2005 has improved performance of PDF rendering or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cesar Augusto Flavio De Min" <cdemin_news@.yahoo.com> wrote in message
news:emEEYAO7FHA.2012@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a matrix report that produce 79 pages on the HTML browser in 30
> seconds, but
> if I try to export the report in a PDF format it take more than 1 our !!!
> The system configuration is:
> IBM Server with 2 Pentium Xeon of 2.4 Ghz
> 1 Gb of RAM
> Fast network HD
> Windows 2003 Server SP1 (SBS)
> SQL Server 2000 SP4
> Rerpoting Services SP2
> Do you have any idea about this problem ?
> I've saw there are some old messages about this problem on this newsgroup,
> but nobody of the
> Microsoft Rerpoting Service Team has reply !!!
> I think this is a very important issue, that can KILL the reportin
> services system on a
> Serious Real World company application.
> Thanks.
> Cesar Augusto Flavio De Min.
> MCSD
>
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
|||
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.
>
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.
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.
PDF EXPORT
Dear All
I use sql server reporting services..in visual studio 2005..
when exporting report to pdf in the report viewer alignment varies..
single table report split up in to two pages not in proper manner..
how to tackle this export to pdf event in report viewer..
did anyone can help me in this.
Regards
Senthil
You need to do adjust the table correctly. just decrease the width of the table and other objects.
if width of the objects does not fit in a page than it will be divided into two pages in pdf. so try to adjust the width of the objects.
|||
I had the same problem and this is what I found. If the report is defined as an 11 x 8.5 (landscape) report with .5 margins (defined in report properties) all around your report data cannot exceed 10".
10" + .5 left margin + .5 right margin = 11.
If you exceed this the page will split.
|||
Thnx jhaberer
its working fine!...
sqlFriday, March 23, 2012
PDC - SQLServer Reporting Services Beta Install
I am having difficulty installing the server components of the SQLServer
Reporting Services Beta copy I received at the PDC. My server is the domain
controller for a small home network, and I received the following error:
An error occurred while applying security settings. <machineName>\ASPNET is
not a valid user or group.
This could be a problem with the package, or a problem connecting to a
domain controller on the
network. Check your network connection and click Retry, or Cancel to end
the install.
I have verified that the ASPNET machine account exists - but I suspect a
recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
error. I would like to try changing the account that the Report Server Web
Service runs as, but I don't see an option to accomodate thisoption.
Does anyone have any suggestions?
I have the following installed:
Recently upgraded .NET Framework from 1.0 to 1.1
Windows 2000 Server
SQLServer Standard Edition, SP3a
Thanks in advance,
RobYou might have more luck posting this message on the RS newsgroup.
It's :- microsoft.beta.reporting.services.general
--
HTH
Ryan Waight, MCDBA, MCSE
"Rob Patterson" <rpatterson@.ztr.com> wrote in message
news:uRRZqKGpDHA.384@.tk2msftngp13.phx.gbl...
> I am having difficulty installing the server components of the SQLServer
> Reporting Services Beta copy I received at the PDC. My server is the
domain
> controller for a small home network, and I received the following error:
> An error occurred while applying security settings. <machineName>\ASPNET
is
> not a valid user or group.
> This could be a problem with the package, or a problem connecting to a
> domain controller on the
> network. Check your network connection and click Retry, or Cancel to end
> the install.
> I have verified that the ASPNET machine account exists - but I suspect a
> recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
> error. I would like to try changing the account that the Report Server
Web
> Service runs as, but I don't see an option to accomodate thisoption.
> Does anyone have any suggestions?
> I have the following installed:
> Recently upgraded .NET Framework from 1.0 to 1.1
> Windows 2000 Server
> SQLServer Standard Edition, SP3a
> Thanks in advance,
> Rob
>|||How do I subscribe to microsoft.beta.reporting.services.general
I have a similar problem, but I am unable to subscribe.
Thanks,
Hanna
Reporting Services Beta copy I received at the PDC. My server is the domain
controller for a small home network, and I received the following error:
An error occurred while applying security settings. <machineName>\ASPNET is
not a valid user or group.
This could be a problem with the package, or a problem connecting to a
domain controller on the
network. Check your network connection and click Retry, or Cancel to end
the install.
I have verified that the ASPNET machine account exists - but I suspect a
recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
error. I would like to try changing the account that the Report Server Web
Service runs as, but I don't see an option to accomodate thisoption.
Does anyone have any suggestions?
I have the following installed:
Recently upgraded .NET Framework from 1.0 to 1.1
Windows 2000 Server
SQLServer Standard Edition, SP3a
Thanks in advance,
RobYou might have more luck posting this message on the RS newsgroup.
It's :- microsoft.beta.reporting.services.general
--
HTH
Ryan Waight, MCDBA, MCSE
"Rob Patterson" <rpatterson@.ztr.com> wrote in message
news:uRRZqKGpDHA.384@.tk2msftngp13.phx.gbl...
> I am having difficulty installing the server components of the SQLServer
> Reporting Services Beta copy I received at the PDC. My server is the
domain
> controller for a small home network, and I received the following error:
> An error occurred while applying security settings. <machineName>\ASPNET
is
> not a valid user or group.
> This could be a problem with the package, or a problem connecting to a
> domain controller on the
> network. Check your network connection and click Retry, or Cancel to end
> the install.
> I have verified that the ASPNET machine account exists - but I suspect a
> recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
> error. I would like to try changing the account that the Report Server
Web
> Service runs as, but I don't see an option to accomodate thisoption.
> Does anyone have any suggestions?
> I have the following installed:
> Recently upgraded .NET Framework from 1.0 to 1.1
> Windows 2000 Server
> SQLServer Standard Edition, SP3a
> Thanks in advance,
> Rob
>|||How do I subscribe to microsoft.beta.reporting.services.general
I have a similar problem, but I am unable to subscribe.
Thanks,
Hanna
Pb with group and lost of informations in the report
But I have problem with reporting services. Could you help me?
For exemple, I have some informatins who don't appear in my report. For example, I have a list of agricultur who are ranged in three different groups( A,B or C). I want to put their names by grouping them in their departement and their town.
Then, a second group on the departement
And finally, a group on the town. But agriculteurs can have a departement and no town, that's why I put them under the departement, and before, the towns of the departement.
For examples for a group, I want to see :
Group A
Auvergne
Mr smith
Mr nicoli
Mr autain
Aubière
Mr potier
Mr dupont
Clermont-ferrand
Mme Pilla
Mr tilmont
Mr aubigny
But, in fact, with reporting services, you don't see Mr nicoli and Mr autain. And I don't understand why? Could you help me?
Salut,
Si j'ai bien compris, tu aurais une dimension Gographie avec une hirarchie
Groupe|||what i suggest is...
only group by ur groups i.e A B & C and under that group by department ,
then sort the records by Town wise, display town beside the name of the agricultur and make it display only once .
do not have a group for Town.
hope it works for u
|||Oui, tu as tout compris, je dois mettre le nom des agriculteurs sous le nom de dpartement et/ou de ville.J'ai stock mes donnes dans un tableau, j'ai insr un group 1 sur groupe(A,B,ou C) un group 2 sur dpartement, et un group 3 sur ville. Et entre group 2 et 3, c'est à dire sous dpartement, j'ai des agriculteurs qui n'appartiennent à aucune ville. Et comme ce sont des lignes de groupes, et pas des lignes de dtails, j'ai l'impression que reporting services, ne prend pas tous les agriculteurs. Et là est mon soucis.Comment lui faire afficher les agriculteurs qui me manquent. Tu veux d'autres prcisions?|||Hum, well,I must display the name of the town before the agricultur sometimes, when I have agriculturs in the town. I can't inverse the town and the agriculturs. But do you know a way to display all the information between two groups? Or is it a bug of reporting services?
Moreover, for another thing, I want not to display an empty line, but I don't find, so I do Iif(condition, " " ,my treatment) and I have big white. Normal, But I can't find anything else to display what I want.
|||you cannot say it as bug, only it is designed like that, the grouping will always be Hierarchical(vertical). you can have only one group under a group .
practically think , can u have multiple bosses or a single boss. 99% of people will have a single boss. that means only one group under a group.
Unless manual method, i think u never find a reporting tool to support ur cause..
if u do not want to display blank line or empty line. u can use CASE statement in ur SQL query to replace blank or null values in Town Column by whatever u want.
Wednesday, March 21, 2012
Pause/Continue distribution, content formatting or delivering.
Notification Services get an event and create notification batch.
Can I pause or stop process of notification delivery with (or without ) ability to continue?
You can disable the distributor, which will stop all formatting/delivery operations. When you re-enable it, the distributor will pick up where it left off. If you set an expiration age in your notification class, then notifications older than that age not be picked up again.You can disable the distributor via the command line using the nscontrol disable command (check the books online for the syntax for disabling just the distributor). If you're using SQL 2005, you can also disable the distributor from Management Studio: right click on the NS instance, choose properties, and uncheck the distributor from the list of enabled components.
Hope this helps.
-shyam|||
Thanks.
I want to specify the question. I have one NS instance and one application in this instance. This application contains one event class with one parameter (Site_ID). Application gets some events with different Site_ID (e.g. 1,2,3) and creates several notification batches for each event. I want to pause or stop delivery process for notifications (may be, distributor work items?) for some Site_ID (e.g. 2). Can I do this?
|||Unfortunately there isn't a way to enable/disable event classes. You may however, enable/disable a particular event provider.If this scenario is important you may investigate having an event class per event provider. In your case, that would implying turning each site into an individual event provider and use the management of a particular event provider to achieve what you're looking for. If you do choose to do this, note that there will be implications on how you manage your subscriptions.
Hope that helps,
Anand|||
Hi Roman -
Here's a copy of the reply I posted to your post in the newsgroup.
(http://groups-beta.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/5161755f07148121/92b74bf86dcf45b1#92b74bf86dcf45b1)
A couple of possibilities come to mind:
1) Depending on your Event Provider, you could alter the how the
events are recognized to prevent the submission of the unwanted
events. For example, if you're using the SQL Server Event Provider,
you can base it on a view that unions together all of the events you
want to recognize. When you need to stop on type of event for a while,
just comment it out of the view. For example:
SELECT Site_ID, Site_Info FROM MyTable WHERE Site_ID = 1
UNION
SELECT Site_ID, Site_Info FROM MyTable WHERE Site_ID = 2
UNION
SELECT Site_ID, Site_Info FROM MyTable WHERE Site_ID = 3
UNION
SELECT Site_ID, Site_Info FROM MyTable WHERE Site_ID = 4
2) You can reactively catch the unwanted notifications in a custom
content formatter and disregard it based upon some criteria that you
set.
Of course I think proactively catching them ahead of time (option #1)
is better. It's more efficient and allows you to resubmit them later
if need be.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
For further clarification and present the business need, I would like to restate the question this way: How does one pause, resume, or cancel a specific batch currently being distributed?
E.g. Assume that NS is the core for a messaging platform that includes the ability to send emails to a membership list. For whatever the business reason, the operator sending the email needs to interrupt (suspend) the current batch being distributed and may or may not decide to resume distribution where it left off depending upon the reason for interuption.
Yes it best to catch issues before distributing, but to find a serious issue 10% into the distribution and be able to click a button to stop the remaining 90% seems a reasonable expectation.
Does the NS platform provide this level of control?
Thanks,
--Bob
Thanks for clarifying. No, there is no reliable way to stop the distribution midway.
Your scenario is interesting and we see the value in enabling it reliably. We will consider this feature for the next release.
Thanks,
Anand|||Perhaps you could implement a custom delivery protocol that checks a criteria indicating whether or not to send the notification or to discard it? Scalability may become an issue for you depending on how you check the send/no send criteria.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
Thank you for considering this as a feature enahncement in the future. I'm sure that there are other circumstances where this level of control may be desireable to more customers than ourselves.
I'm not too sure what we will do in the mean time, but at least we know that this is not doable for now.
Thanks,
--Bob|||
Well, as I can see, it is possible to cancel the distribution at least using filtering at the level of the custom delivery protocol, even if there is no possiblity to resume it again. Distributor will still process all formatted messages, but they won't be sent by protocol.
Moreover, if we put some value indicating delivery failure, can sending process also be resumed later, using standard (or custom?) retry abilities?
|||I haven't tried it myself, but I can't see any reason why the standard retry logic wouldn't work. Just be mindful of the ExpirationAge, RetrySchedule, and RetryDelay elements. Of course you'll also need to consider those times when you need to turn delivery again before the expiration age of the ones you wanted to cancel has expired.
I suspect this implementation has some scalability issues, too. You'll definitely want to make the filtering check as efficient as possible and then do some load testing.
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
Pause between pages when printing RS report
I am using Report Services on SQL Server 2005. I have a report that gets its data from a single SQL Server stored procedure. One other small table is used, but only to provide a list of values for selecting a parameter value to send to the stored procedure.
On the report I use a list control to display multiple records per page.
When printing the report (which currently produces over 500 pages - future printings of this report will not be nearly so large), the printer pauses between each page as if they are seperate print jobs. This is an HP LaserJet 5Si that normally cranks out reports very fast.
The only thing I can think of that might contribute to this sort of behavior is the fact that I set my margin sizes to 0in to get as much design room on the report as possible. Could that cause this sort of behavior?
Just bumping this topic. I'm very much in need of an answer on this. I've tried different settings for the margins as well, but anything other than 0in. causes extra pages to be printed.
How can I eliminate the pause between pages?|||How are you printing the report? Are you using the printing via the web or using delivery? I have not heard of this sort of behavior. The only thing I can think of is that the server is busy rendering each page and is causing the printer to wait for additional pages.
-Daniel|||Thanks for the reply.
I am printing the reports via the web. This behavior is exhibited when printing them from the Visual Studio design environment as well.
|||Most likely, your printer is able to print faster than the ability of the server to generate the pages. This could happen if the pages are complex and/or have lots of images. The overall time should be similar to exporting the report to an image format.|||I guess I can see where the report generation might be the bottleneck, however it is just a standard report with a basic list control displaying some 20-25 data fields per record. There are no images being used at all. The most graphically intensive element is a light gray filled box around the report title.
Honestly, I can't imagine a much simpler report. That is why I have trouble accepting this as being as good as it gets.
|||The fact that you see this in the designer as well as the server seems to mean that the issue may lie elsewhere. Do any other reports behave this way? Are you able to try any other printers?
When you print from the web you can preview the report first. Can you first preview the entire report before printing? By doing this you will have downloaded all the pages to the client, when you actually print you will just be sending the emf file to the printer. If the problem still occurs then it is most likely an issue downstream from RS if it doesn't occur then RS would have some issue.
Thanks.
-Daniel
Pause between pages when printing RS report
I am using Report Services on SQL Server 2005. I have a report that gets its data from a single SQL Server stored procedure. One other small table is used, but only to provide a list of values for selecting a parameter value to send to the stored procedure.
On the report I use a list control to display multiple records per page.
When printing the report (which currently produces over 500 pages - future printings of this report will not be nearly so large), the printer pauses between each page as if they are seperate print jobs. This is an HP LaserJet 5Si that normally cranks out reports very fast.
The only thing I can think of that might contribute to this sort of behavior is the fact that I set my margin sizes to 0in to get as much design room on the report as possible. Could that cause this sort of behavior?Just bumping this topic. I'm very much in need of an answer on this. I've tried different settings for the margins as well, but anything other than 0in. causes extra pages to be printed.
How can I eliminate the pause between pages?|||How are you printing the report? Are you using the printing via the web or using delivery? I have not heard of this sort of behavior. The only thing I can think of is that the server is busy rendering each page and is causing the printer to wait for additional pages.
-Daniel|||Thanks for the reply.
I am printing the reports via the web. This behavior is exhibited when printing them from the Visual Studio design environment as well.|||Most likely, your printer is able to print faster than the ability of the server to generate the pages. This could happen if the pages are complex and/or have lots of images. The overall time should be similar to exporting the report to an image format.|||I guess I can see where the report generation might be the bottleneck, however it is just a standard report with a basic list control displaying some 20-25 data fields per record. There are no images being used at all. The most graphically intensive element is a light gray filled box around the report title.
Honestly, I can't imagine a much simpler report. That is why I have trouble accepting this as being as good as it gets. 
When you print from the web you can preview the report first. Can you first preview the entire report before printing? By doing this you will have downloaded all the pages to the client, when you actually print you will just be sending the emf file to the printer. If the problem still occurs then it is most likely an issue downstream from RS if it doesn't occur then RS would have some issue.
Thanks.
-Danielsql
Subscribe to:
Posts (Atom)