PDFs... Automatically open?

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?
>

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
>

PDF to RDL conversion

I have a project that we need to dynamically output a PDF document.
The format I have it in now is PDF. I want to be able to bring this
PDF into the Visual Studio report designer as a starting point. I will
the drop report parameters on to the report to add the dynamic data.
Is there any way I can convert a PDF document into an RDL file?I haven't heard of an automatic converter that will take a PDF and create an
RED, not sure how it would be able to do that anyway.
--
Floyd
"Paul Hester" <phester@.gmail.com> wrote in message
news:1123797876.993952.76350@.g44g2000cwa.googlegroups.com...
>I have a project that we need to dynamically output a PDF document.
> The format I have it in now is PDF. I want to be able to bring this
> PDF into the Visual Studio report designer as a starting point. I will
> the drop report parameters on to the report to add the dynamic data.
> Is there any way I can convert a PDF document into an RDL file?
>|||Nope, Floyd is correct, there is no way to do this...Start from scratch...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul Hester" <phester@.gmail.com> wrote in message
news:1123797876.993952.76350@.g44g2000cwa.googlegroups.com...
>I have a project that we need to dynamically output a PDF document.
> The format I have it in now is PDF. I want to be able to bring this
> PDF into the Visual Studio report designer as a starting point. I will
> the drop report parameters on to the report to add the dynamic data.
> Is there any way I can convert a PDF document into an RDL file?
>

PDF output problem for checkbox like "Ticks" displayed in reports

Hi All,
we created a report that should render some "checked items" (like the ticks
in a checkbox) to indicate the given answers for multiple chooice questions
from a questionaire.
Displaying the tick is done by using a unicode character from the font "MS
Mincho". When we render the report in report viewer, all seems to be fine,
but when rendered to a pdf it goes wrong; the "tick" is replaced with a
question mark.
We can't find any specific unicode/pdf related settings for RS. Any clues.
Many thanks in advance,
TimHi tvds,
I have exactly the same problem, did you find any solution?
Thanks,
Markus
"tvds" wrote:
> Hi All,
> we created a report that should render some "checked items" (like the ticks
> in a checkbox) to indicate the given answers for multiple chooice questions
> from a questionaire.
> Displaying the tick is done by using a unicode character from the font "MS
> Mincho". When we render the report in report viewer, all seems to be fine,
> but when rendered to a pdf it goes wrong; the "tick" is replaced with a
> question mark.
> We can't find any specific unicode/pdf related settings for RS. Any clues.
> Many thanks in advance,
> Tim
>sql

PDF Margins

I have searched through out this newsgroup and seen several people
pose the question without response. I am trying to output some reports
to PDF from the standard RS interface
(http://localserver/reports/....) The report generates a PDF
perfectly except that the margins are 1 inch on each side (I don't
know anyone that uses that setting), and can't seem to find a way to
set this at design time. I have set the page size to 8.5 / 11 and
placed everything appropriately on the design time grid. I am a
Reporting Services noob, but have written a number of applications
using various 4GL's (Delphi, VS, etc). This is my first experience
with anything .Net, so any specific guidance related to developing in
.Net should be included.Hi Kevin,
Thanks for your posting!
From your descriptions, I understood you could like to know how to set
Report Margins when rendering to PDF format. If I have misunderstood your
concern, please feel free to point it out.
Based on my knowledge, please try change the Left / Right / Top / Button
Margins number under
Report -> Report Properties -> Layout
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

pdf instead of html as default output format

Hi all,
I would like to output all reports in pdf format instead of html.
I dont want to allow users to choose an export format.
So, if they access an URL and fill some textboxes with appropriated
parameters I can send them a ready-to-print PDF file in Internet Explorer.
Is it possible?
(I´m assuming all clients uses IE browser and Acrobat Reader plugin).
thanks a lot!One way you can do it is in the url of the report. You can add at the end of
your report url:
&rs:Command=Render&rs:format=pdf
Since it is in the url you have to be careful how you open it. I just open
the report in a new windows and it will actually render the report in the
adobe acrobat reader progam so there is no url the user can change. You
could embed it in an iframe on a page to display to a user as well.
"Ricardo" wrote:
> Hi all,
> I would like to output all reports in pdf format instead of html.
> I dont want to allow users to choose an export format.
> So, if they access an URL and fill some textboxes with appropriated
> parameters I can send them a ready-to-print PDF file in Internet Explorer.
> Is it possible?
> (I´m assuming all clients uses IE browser and Acrobat Reader plugin).
> thanks a lot!
>
>

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."
> >
>
>

PDF file featuring only the first page... why?

Hello,
I am struggeling with my .PDF file exports. One of our reports outputs 250
pages in the web interface. When I ask to output a PDF version of it, the
file contains only the first page but I really don't know why. Could it be a
problem with the .RDL file?!?
Thanks!
Marc LacoursiereAfter some more inspection... I have found something interesting!
The report contains a table which has 2 groups. Both of them were set to do
a page break after them. If I remove the page break in the inner group, but
leave the other intact, the problem is fixed.
For this report, it is now working perfectly. But I am still wondering why
would the PDF rendering stop because of a table containing two groups both
doing page breaks?
Suppose I am required to create such a behavior in a different report, would
I still be stuck with that issue?
Marc Lacoursiere
"Marc Lacoursiere" <marcdotlacoursiere@.cgi.com> wrote in message
news:uroxxN$9EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hello,
>
> I am struggeling with my .PDF file exports. One of our reports outputs 250
> pages in the web interface. When I ask to output a PDF version of it, the
> file contains only the first page but I really don't know why. Could it be
> a problem with the .RDL file?!?
>
> Thanks!
> Marc Lacoursiere
>sql

Passing table Column name as parameter to a stored procedure

I want to run a Stored Procedure which takes Column name( table column names ) as input, use some aggregate function and return the desired output.

I have tried passing a single column name as input parameter and also the entire SQL statement as input parameter. but i am not able to capture and return the output value

I have also tried using Table data type but fail to capture the value. I dont want to use Temporary table.

The syntax i tried is some thing like this

Declare @.stmt nvarchar(100)
Declare @.AcctCode Char(8)
Declare @.rtVal numeric(18,5)

Set @.AcctCode = 'An_Sales'
Set @.stmt = 'Select AVG(' + @.ACCTCODE + ') From T_Comp_Profile'
Exec sp_executesql @.rtval = @.stmt

And also

Declare @.AcctCode Char(8)
Declare @.Ssql NVarchar(100)
Declare @.rtVal numeric (18,5)
Set @.AcctCode = 'An_Sales'

Set @.Ssql = 'Select ' +@.rtval + '=AVG(an_sales) into From T_Comp_Profile'
Exec SP_ExecuteSql @.Ssql
print @.rtval

Pls help me in this regard

Ramanbir Singhtry something like...

Declare @.mystmt nvarchar(100)
Declare @.AcctCode Char(8)
Declare @.rtVal numeric(18,5)

Set @.AcctCode = 'An_Sales'
Set @.mystmt = 'Select AVG(' + @.ACCTCODE + ') From T_Comp_Profile'
Exec sp_executesql @.stmt= @.mystmt|||Dear Rockslide

U have wriiten me with the following code

Declare @.mystmt nvarchar(100)
Declare @.AcctCode Char(8)
Declare @.rtVal numeric(18,5)

Set @.AcctCode = 'An_Sales'
Set @.mystmt = 'Select AVG(' + @.ACCTCODE + ') From T_Comp_Profile'
Exec sp_executesql @.stmt= @.mystmt

The stt "Exec sp_executesql @.mystmt" this returns a data set, so it is not going to be stored in a variable like u specified i.e
Exec sp_executesql @.stmt= @.mystmt

because when we print the value of @.stmt using "Print @.stmt" it returns nothing also we cant use a table data type here in place of @.stmt|||hi rjaj

I think I am a little confused.

sp_executesql takes (basically) 2 different parameters, see the syntax below.

sp_executesql [@.stmt =] stmt
[
{, [@.params =] N'@.parameter_name data_type [,...n]' }
{, [@.param1 =] 'value1' [,...n] }
]

When we say

exec sp_executesql @.stmt=@.mystmt

we are effectively saying

exec sp_executesql @.stmt = 'Select AVG(' + @.ACCTCODE + ') From T_Comp_Profile'

if we do nothing else with the returned results they will be outputed.

if you want the results to return to a parameter then you would need to do something like

select @.results = sp_executesql @.stmt = 'Select AVG(' + @.ACCTCODE + ') From T_Comp_Profile'

at a guess (the line above hasn't been tested, in theory I think it should work).|||Sounds familiar

http://www.dbforums.com/t970045.html|||create table #tbl ([output] int null)
insert #tbl Exec (@.stmt)|||Originally posted by ms_sql_dba
create table #tbl ([output] int null)
insert #tbl Exec (@.stmt)

Using temporary tables work
but i dont want to use a temporary table
Is there any other way for that