Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Thursday, March 29, 2012

Directly generate PDF file

Is it possible to generate directly a PDF file with a name, and not first
come in the HTML page and then eport to PDF.
I hope someone knows how.
Kind regards
A. MoeskerSure, you can do this with either web services or URL integration. You
specify the render method. The default is HTML. If you have a link in your
report use the jump to URL instead of jump to report. Look at books online
and search on URL
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"A. Moesker" <a.moesker@.home.nl> wrote in message
news:OAk2oUqRFHA.3140@.tk2msftngp13.phx.gbl...
> Is it possible to generate directly a PDF file with a name, and not first
> come in the HTML page and then eport to PDF.
> I hope someone knows how.
> Kind regards
> A. Moesker
>|||I use the following JavaScript to determine the output from a standard asp
search results page.
The URL is built up and then calls a window to open up the new URL which
automatically causes the document to either open or be saved (users selection
via dialogue box).
var HLINK="";
HLINK = HLINK + "http://{RS Server Name}/ReportServer"
HLINK = HLINK + "?%2f{Folder Name}%2f"+sReportName
HLINK = HLINK + "&rs%3aClearSession=true"
HLINK = HLINK + "&rs%3aCommand=Render"
HLINK = HLINK + "&rs%3aFormat=" + aFormat //HTML4.0 - PDF - EXCEL
HLINK = HLINK + "&S_Customer="+S_Customer //Params go here
HLINK = HLINK + "&rc%3aToolbar=True"
HLINK = HLINK + "&rc%3aJavaScript=True"
HLINK = HLINK + "&rc%3aLinkTarget=_top"
HLINK = HLINK + "&rc%3aArea=Toolbar"
HLINK = HLINK + ""
You can see how the URL is built up. I use some 12 or so params with this
page and thay can be bolted on where I have indicated.
Best of luck,
Tony
"Bruce L-C [MVP]" wrote:
> Sure, you can do this with either web services or URL integration. You
> specify the render method. The default is HTML. If you have a link in your
> report use the jump to URL instead of jump to report. Look at books online
> and search on URL
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "A. Moesker" <a.moesker@.home.nl> wrote in message
> news:OAk2oUqRFHA.3140@.tk2msftngp13.phx.gbl...
> > Is it possible to generate directly a PDF file with a name, and not first
> > come in the HTML page and then eport to PDF.
> >
> > I hope someone knows how.
> >
> > Kind regards
> >
> > A. Moesker
> >
> >
>
>

Saturday, February 25, 2012

Different language Characters

I have a developer that needs to store different language
characters in a table. What he is doing is designing a web
page, so that someone will have a choice as what language
he will view the web page in. Is it possible to store lets
say Russian or Chinese characters in a SQL Server table?
Does this fall under Unicode data? If you can do this, how
do you get the characters into the coulmns? Any help or
suggestions would be greatly appreciated!!Hello Richard !
Yes, this is UNICODE. How you get the data into the columns ? With an INSERT
? Regardless , your business logic
is on SQL Server or in the frontend, the data is send to SQL Server in
UNICODE and also stored there as this.
Jens Süßmeyer.
"Richard" <richard.peoples@.lacdc.org> schrieb im Newsbeitrag
news:034301c365ce$cce23130$a501280a@.phx.gbl...
> I have a developer that needs to store different language
> characters in a table. What he is doing is designing a web
> page, so that someone will have a choice as what language
> he will view the web page in. Is it possible to store lets
> say Russian or Chinese characters in a SQL Server table?
> Does this fall under Unicode data? If you can do this, how
> do you get the characters into the coulmns? Any help or
> suggestions would be greatly appreciated!!|||Obviously then, I need to have SQL Server installed as Unicode. Correct?
>--Original Message--
>Hello Richard !
>Yes, this is UNICODE. How you get the data into the columns ? With an INSERT
>? Regardless , your business logic
> is on SQL Server or in the frontend, the data is send to SQL Server in
>UNICODE and also stored there as this.
>Jens S=FC=DFmeyer.
>
>"Richard" <richard.peoples@.lacdc.org> schrieb im Newsbeitrag
>news:034301c365ce$cce23130$a501280a@.phx.gbl...
>> I have a developer that needs to store different language
>> characters in a table. What he is doing is designing a web
>> page, so that someone will have a choice as what language
>> he will view the web page in. Is it possible to store lets
>> say Russian or Chinese characters in a SQL Server table?
>> Does this fall under Unicode data? If you can do this, how
>> do you get the characters into the coulmns? Any help or
>> suggestions would be greatly appreciated!!
>
>.
>|||No just change the columns you have to NVARCHAR to store UNICODE. But
remeber --> The Maximum Length will be chopped to 4000 characters.
Jens Süßmeyer.

Friday, February 24, 2012

Different headers on page 1 and 2

Our report consists of a large header on page 1 and a smaller header on the
other pages. It is important that we have the page numbers and total page
number on both headers.
--
Anders EklundDon't use a header on page 1, just include the large header information at
the top of the report and then set your report header's PrintOnFirstPage
property to False.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Anders Eklund" <AndersEklund@.discussions.microsoft.com> wrote in message
news:20F556AB-5EC6-4AB0-B924-50E16E01CB1E@.microsoft.com...
> Our report consists of a large header on page 1 and a smaller header on
> the
> other pages. It is important that we have the page numbers and total page
> number on both headers.
> --
> Anders Eklund|||But the varibles for "Total pages" can only be used in the header, or?
--
Anders Eklund
"Douglas McDowell" wrote:
> Don't use a header on page 1, just include the large header information at
> the top of the report and then set your report header's PrintOnFirstPage
> property to False.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> "Anders Eklund" <AndersEklund@.discussions.microsoft.com> wrote in message
> news:20F556AB-5EC6-4AB0-B924-50E16E01CB1E@.microsoft.com...
> > Our report consists of a large header on page 1 and a smaller header on
> > the
> > other pages. It is important that we have the page numbers and total page
> > number on both headers.
> >
> > --
> > Anders Eklund
>
>|||But the variable "Total pages" can only be used in the header, or?
--
Anders Eklund
"Douglas McDowell" wrote:
> Don't use a header on page 1, just include the large header information at
> the top of the report and then set your report header's PrintOnFirstPage
> property to False.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> "Anders Eklund" <AndersEklund@.discussions.microsoft.com> wrote in message
> news:20F556AB-5EC6-4AB0-B924-50E16E01CB1E@.microsoft.com...
> > Our report consists of a large header on page 1 and a smaller header on
> > the
> > other pages. It is important that we have the page numbers and total page
> > number on both headers.
> >
> > --
> > Anders Eklund
>
>

Different Header on Second Page

I have a report that requires a different header starting on the second page. I tried creating the header for page one in the body of the report, then creating the header for page two in the actual report header and setting PrintOnFirstPage to false. Unfortunately, this leaves a large space at the top of the first page, which is not acceptable to my users.

If there was a way to create a list box header that repeats at the top of each page, that would solve this problem as well, but I can't seem to find a way to do that either.

Any suggestions would be GREATLY appreciated.

You can use an iif statement in the testboxes of your header to change the contents depending on the global variable for page. If you need totally different header then use the hidden property to hide one header and display the other according to which page it is on.|||

Thank you. I actually tried something similar with a textbox in the body of the report and got the following error:

The Hidden expression for the textbox ‘textbox31’ refers to the global variable PageNumber or TotalPages. These global variables can be used only in the page header and page footer.

It didn't occur to me to try putting the textbox in the report header, but that works!

Thanks again!

Different header in HTML vs. PDF?

I have a report that is being displayed as a web page, and I've also
got a "Printer-friendly" button to call the same report generates as a
PDF. However, due to the business needs of the application, we need to
add an additional footer with copyright information to the bottom of
each page in the PDF version, but not display it when it's being viewed
as a web page (since it will be viewed in an IFRAME).
I've seen that the Visibility property of a section can be an
expression, so what I'm thinking is that I could use something along
the lines of =Iif(format="PDF", true, false) for the Visibility of the
footer, so it will show up when the passed-in "Format" parameter is
"PDF", but not when it's "HTML4.0". However, I'm not sure how to
access this parameter, or even whether or not I am able to.
Is there a way to access this value? Or will I have to make two
different reports, one with a footer and one without?
Thanks,
David HendersonThe second option is the best one.
Amarnath
"David Henderson" wrote:
> I have a report that is being displayed as a web page, and I've also
> got a "Printer-friendly" button to call the same report generates as a
> PDF. However, due to the business needs of the application, we need to
> add an additional footer with copyright information to the bottom of
> each page in the PDF version, but not display it when it's being viewed
> as a web page (since it will be viewed in an IFRAME).
> I've seen that the Visibility property of a section can be an
> expression, so what I'm thinking is that I could use something along
> the lines of =Iif(format="PDF", true, false) for the Visibility of the
> footer, so it will show up when the passed-in "Format" parameter is
> "PDF", but not when it's "HTML4.0". However, I'm not sure how to
> access this parameter, or even whether or not I am able to.
> Is there a way to access this value? Or will I have to make two
> different reports, one with a footer and one without?
> Thanks,
> David Henderson
>

Different footer size for first page

Hi,
I am trying to create invoices where first page should have ~3.75in footer
with remittance slip. All other pages should have small footer.
Body of the report is one big table with groups.
What is the [best] way to accomplish this? Footer size could not be
formula-based (at least though VS2K5).
I am useing RS2K5SP1.
Thanks
-AndreyHi Andrey,
Thanks for using MSDN Managed Newsgroup Support.
Footer size can not use expressions.
I would like to know if it's possible for you to add your remittance slip
in the firs page content.
Sincerely,
Wei Lu
Microsoft Online Community 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.
--
>Thread-Topic: Different footer size for first page
>thread-index: AcZqNrS4PipuEn7hSOe3RyettPbMqw==>X-WBNR-Posting-Host: 205.143.175.124
>From: =?Utf-8?B?QW5kcmV5?= <AndreyN@.newsgroups.nospam>
>Subject: Different footer size for first page
>Date: Thu, 27 Apr 2006 13:11:01 -0700
>Lines: 15
>Message-ID: <89E7F9E4-A6DE-47FF-A7CA-A01F81E95B34@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:72865
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi,
>I am trying to create invoices where first page should have ~3.75in footer
>with remittance slip. All other pages should have small footer.
>Body of the report is one big table with groups.
>What is the [best] way to accomplish this? Footer size could not be
>formula-based (at least though VS2K5).
>I am useing RS2K5SP1.
>Thanks
>-Andrey
>|||Wei,
Report itself is a table with multiple groups which can span multiple pages.
How can I add a slip to the end of first page other than putting it into the
footer?
Is there any way to have deferent footers for first page and all other pages
(similar to Word)?
Thanks
-Andrey
"Wei Lu" wrote:
> Hi Andrey,
> Thanks for using MSDN Managed Newsgroup Support.
> Footer size can not use expressions.
> I would like to know if it's possible for you to add your remittance slip
> in the firs page content.
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.
> --
> >Thread-Topic: Different footer size for first page
> >thread-index: AcZqNrS4PipuEn7hSOe3RyettPbMqw==> >X-WBNR-Posting-Host: 205.143.175.124
> >From: =?Utf-8?B?QW5kcmV5?= <AndreyN@.newsgroups.nospam>
> >Subject: Different footer size for first page
> >Date: Thu, 27 Apr 2006 13:11:01 -0700
> >Lines: 15
> >Message-ID: <89E7F9E4-A6DE-47FF-A7CA-A01F81E95B34@.microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >Path: TK2MSFTNGXA01.phx.gbl
> >Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:72865
> >NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >
> >Hi,
> >
> >I am trying to create invoices where first page should have ~3.75in footer
> >with remittance slip. All other pages should have small footer.
> >
> >Body of the report is one big table with groups.
> >
> >What is the [best] way to accomplish this? Footer size could not be
> >formula-based (at least though VS2K5).
> >
> >I am useing RS2K5SP1.
> >
> >Thanks
> >
> >-Andrey
> >
>|||Hi Andrey,
The reporting services pagination is different with Word. The pagination in
the Reporting Service can not use the formula expression.
As you are using the group to add the page breaks, I think you need to
design a subreport and include only the first page content and the slip.
Then, you could put the other data in the report and with the different
page footer.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community 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.
--
>Thread-Topic: Different footer size for first page
>thread-index: AcZqhlU29tf9nijmTwuP3TUJOP/8+Q==>X-WBNR-Posting-Host: 68.122.5.247
>From: =?Utf-8?B?QW5kcmV5IE5pa2lmb3Jvdg==?= <AndreyN@.newsgroups.nospam>
>References: <89E7F9E4-A6DE-47FF-A7CA-A01F81E95B34@.microsoft.com>
<6P8i0XnaGHA.1244@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Different footer size for first page
>Date: Thu, 27 Apr 2006 22:41:01 -0700
>Lines: 77
>Message-ID: <0A370993-DE0E-409E-B6AB-E73193657815@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>Path: TK2MSFTNGXA01.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:72881
>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Wei,
>Report itself is a table with multiple groups which can span multiple
pages.
>How can I add a slip to the end of first page other than putting it into
the
>footer?
>Is there any way to have deferent footers for first page and all other
pages
>(similar to Word)?
>Thanks
>-Andrey
>"Wei Lu" wrote:
>> Hi Andrey,
>> Thanks for using MSDN Managed Newsgroup Support.
>> Footer size can not use expressions.
>> I would like to know if it's possible for you to add your remittance
slip
>> in the firs page content.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community 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.
>> --
>> >Thread-Topic: Different footer size for first page
>> >thread-index: AcZqNrS4PipuEn7hSOe3RyettPbMqw==>> >X-WBNR-Posting-Host: 205.143.175.124
>> >From: =?Utf-8?B?QW5kcmV5?= <AndreyN@.newsgroups.nospam>
>> >Subject: Different footer size for first page
>> >Date: Thu, 27 Apr 2006 13:11:01 -0700
>> >Lines: 15
>> >Message-ID: <89E7F9E4-A6DE-47FF-A7CA-A01F81E95B34@.microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> > charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>> >Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> >Path: TK2MSFTNGXA01.phx.gbl
>> >Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:72865
>> >NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>> >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> >
>> >Hi,
>> >
>> >I am trying to create invoices where first page should have ~3.75in
footer
>> >with remittance slip. All other pages should have small footer.
>> >
>> >Body of the report is one big table with groups.
>> >
>> >What is the [best] way to accomplish this? Footer size could not be
>> >formula-based (at least though VS2K5).
>> >
>> >I am useing RS2K5SP1.
>> >
>> >Thanks
>> >
>> >-Andrey
>> >
>>
>

Different Detail Sections - Different Page Sizes

I have two detail sections A and B. Details A is on one page, then a new page starts for Details B.
I want Details A - Legal Size
Details B - Letter Size
How can I accomplish this.
thank youany help, anyone?