exe to export reports to pdf

Hi,
We have a need to create something like a win app that would be scheduled to
run on the web/reporting server, query the db, pass some parameters to
reports and auto-generate them in pdf format (to be stored in db or on the
same box) to make them available for the website visitors.
Have anybody done something like this before or seen an example of? We tried
to do something similar when reporting services when it just came out but
were unable to implement. Would really appreciate any advice on how to
tackle this!Thanks! Are you using data-driven subscription feature for this? Is it only
available with Enterprise SQL edition?
"Wickherm" <Wickherm@.discussions.microsoft.com> wrote in message
news:3CF580B4-0CD1-4C37-8099-2B65FBF846B2@.microsoft.com...
> We use the subscriptons in RS to schedule reports to save to a file share.
> The parameters in the reports call outside dll's to get the values.
> "ilona" wrote:
>> Hi,
>> We have a need to create something like a win app that would be scheduled
>> to
>> run on the web/reporting server, query the db, pass some parameters to
>> reports and auto-generate them in pdf format (to be stored in db or on
>> the
>> same box) to make them available for the website visitors.
>> Have anybody done something like this before or seen an example of? We
>> tried
>> to do something similar when reporting services when it just came out but
>> were unable to implement. Would really appreciate any advice on how to
>> tackle this!
>>

excel vs. pdf - is it possible to eliminate header?

I have a report that has images etc. (company logo) at the top which works
fine when rendering to pdf. However I'd like to elimiate this stuff when
rendering to xls. Is that possible?
Thanks.
--CoryTry CSV ASCII instead. Much faster and it will do what you want.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Cory" <Cory@.discussions.microsoft.com> wrote in message
news:3CA7586B-D025-4561-9D32-6BD9A63303C3@.microsoft.com...
>I have a report that has images etc. (company logo) at the top which works
> fine when rendering to pdf. However I'd like to elimiate this stuff when
> rendering to xls. Is that possible?
> Thanks.
> --Cory

Excel versus PDF Rendering

We have a report that's rendered to a printable form over 1000 times
in a span of 2 hours. We're in the process of replacing the server
because this workload has been hammering the machine and running the
RS services out of memory. I've added a metering component (the page
that redirects users to the report checks to see how many reports are
running and holds them at that page if it's over a set number). My
question is... for a fairly plain report (about 8 pages, mostly just
gridlines and shaded areas, with column and row header text. No
embedded images), which rendering performs better - PDF or Excel?
I've done some un-scientific research, and found that the CPU and
clock-time for each is pretty consistent, but that PDF might require
less memory per rendering report? Any feedback on this would be very
helpful.With SP1 of Reporting, the Algoritm for PDF Render are improved.
Con el Service Pack 1, el algoritmo de renderizacion de PDF fue mejorado.
John Bocachica
Colombia
"TShay" wrote:
> We have a report that's rendered to a printable form over 1000 times
> in a span of 2 hours. We're in the process of replacing the server
> because this workload has been hammering the machine and running the
> RS services out of memory. I've added a metering component (the page
> that redirects users to the report checks to see how many reports are
> running and holds them at that page if it's over a set number). My
> question is... for a fairly plain report (about 8 pages, mostly just
> gridlines and shaded areas, with column and row header text. No
> embedded images), which rendering performs better - PDF or Excel?
> I've done some un-scientific research, and found that the CPU and
> clock-time for each is pretty consistent, but that PDF might require
> less memory per rendering report? Any feedback on this would be very
> helpful.
>

Excel Output Missing Last row

My excel outout is missing the last row of the recordset. HTML, PDF, and the
other outputs are ok. This is a simple report with no grouping. Please help.Derek,
Have you tried to add a blank footer row to the table?
This way if the bug does occur it will just drop a blank footer and not your
data. (I know this is idea is just a band-aid not a fix but MS seems to be
ignoring this problem.)
I have not tested this theory myself because I have only seen this happen a
few times and each time I tried to dup the results everything worked fine.
Do you have a report that has a regular problem that you could test my theory
for me?
Tim
"Derek Howard" wrote:
> My excel outout is missing the last row of the recordset. HTML, PDF, and the
> other outputs are ok. This is a simple report with no grouping. Please help.