Print on back side of 1st page only

I have a SRS report that we are using as an invoice. I want to print out terms on the backside of the 1st page. Is this possible? Any ideas on how to go about doing this? I think the best way to go about doing this is to print the whole report double sided, and leave every 'even numbered' page blank expcept page 2, where the terms would print. I'm just not sure how to go about doing this in SRS.

Any help would be appreciated.

Randy

To start out with, can you be sure that content for each of the subsequent pages (page 3 and up, I mean) will be less than a page in length, with explicit page breaks between each, or does the content have to "flow" through pages 3, 4, etc without explicit page breaks? Does the content for page 1, similarly, have a known length, or can you force it to have a known length?

This is a cool problem <s>.

>L<

|||

The report is an invoice report. Page 1 will contain some header information (logo, address, customer, etc) and then will begin to list invoice lines. More than likely these invoice lines will carry over into multiple pages depending on how many items the customer ordered. In this case, page 1 would need to print with all of my header information and as much invoice line information as will fit, then page 2 would need to print terms, then page 3 should continue where page 1 left off. Page 4 would then need to be printed blank (since we are printing double sided) and page 5 would continue where page 3 left off, etc, etc. The challenge is telling SQL, "OK, now that we are on page 2, print this instead" and then, "now that we are on page 3, continue printing."

Thanks for any help you can provide.

Randy

Example:

Page 1 - Header, and body section

Page 2 - Terms

Page 3 - Body section from page 1 continued (if needed)

Page 4 - Blank

Page 5 - Body section from page 3 continued (if needed)

Page 6 - Blank

Page 7 - Body section from page 5 continued (if needed)

Page 8 - Blank

etc, etc

|||

>> No explicit page breaks

That's what I was afraid of -- makes things a little more complex, but I think it can be done... sorry for the delay in response...

OK, this is really cool. And I tried it a bunch of other ways, some of which might work and be less wierd -- but this really does work perfectly and doesn't disturb the "preview" layout at all -- it will only affect the print and PDF layout (and presumably other renderers that go to fixed page dimensions).

Here's how it works: It depends on something that usually annoys the heck out of us: the behavior of "wide" report designs in terms of page breaks for fixed page layouts such as print and PDF.

This is what you do:

1) First, figure out how you are going to separate the content of the first page from other pages and design your report with *two* tables, one for first page and one for the other pages. The first table obviously has your header while the second does not.

I did this by creating a SELECT statement that included a row number using SQL Server capabilities, because you can't filter or break by the the reporting RowNumber() function. You can do this in other environments as well -- in another thread somewhere here I show a worked example for doing it in SQL 2000 -- and you could also just use two datasets, one for each table. But in SQL 2005 it's really easy to do this:

Code Snippet

SELECT Row_Number() OVER (ORDER BY Whatever) As MyRowNum,*
FROM YourData ORDER BY Whatever

2) Now you make sure you only have the right details for each table. In my example, it worked out to have these two filters. If you split your data by some other method into one dataset for each of the tables , you don't need to do this:

Code Snippet

=Fields!MyRowNum.Value <= =15 ' first table

=Fields!MyRowNum.Value > =15 ' second table

3) Design your two tables so that they fit within the normal printable page limits -- if your paper size is, for example, 8.5 * 11, you should make sure that the tables are no wider than will print properly in this normally.

4) Here's the trick: You need to make the layout (page size -- *not* interactive page size) wider than will print properly for your page set up.

Horizontally across from table #1 , you put a rectangle (or whatever) holding your Terms details for the invoice.

Horizontally across from table #2, you don't need to put anything.

The layout ends up looking something like this:

Real layout (say, 7.5") a bit of space for comfort addtl layout, forcing the break

Header information, part of Table number one, plus the details that fit on page 1

Your terms go here Table number two with the rest of your details

The extra layout you put in should not be any more than 8" wide (in the example where the page is 8.5" wide) and preferably it should be a bit less.

The result is exactly what you want and what we usually do not want but get by accident, when we design page layouts that don't fit in a fixed page size:

the terms are pushed to page 2 and each appearance of table #2, starting with page 3, gets followed by an extra blank page...

Whaddya think?

>L<

print next record in next column

I have a simple table with a few rows of data. I would like to create
a report that would print the records left to right (meaning; next
record would go into a next column and not down into the new row).
What is the best way to accomplish this?
I have a report created with two columns and the fields are in both,
but it prints out the same data twice in both columns.
Any help is greately appreciated!You may create mutli column reports which sounds like what you are looking
for... There is an example at www.msbicentral.com
--
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
"muris" <rmuris@.hotmail.com> wrote in message
news:1126021920.722602.103050@.g44g2000cwa.googlegroups.com...
>I have a simple table with a few rows of data. I would like to create
> a report that would print the records left to right (meaning; next
> record would go into a next column and not down into the new row).
> What is the best way to accomplish this?
> I have a report created with two columns and the fields are in both,
> but it prints out the same data twice in both columns.
> Any help is greately appreciated!
>sql

Print newly created report later

Hi all,

I am creating reports using crystal report in VB.NET. The reports are created successfully and can be converted to PDF and Word.

After the creation i send generated documents as email. And also have to print them.

I don't want to use Adobe/Word for the printing. I want to create .prn files for printing in the generation process.

Is there any other option which can be used to print the created report.

I can print the reports directly from crystal reports but i want to split the process in two phases
1, Generation
2, Dispatching

Looking for ideaCant you make use of Print button avaliable in the Report?|||Thanks for your reply.

But the scenario is entierly different in my case. I am using Crystal Reports as window service and the process is splited in two phases

1, Generation
2, Dispatching

One process will generate a document and then save it
the other process will print that generated document

I can generate and print in one process with out storing the file on disk. But i want to do it in two steps.

Regards|||What is the difficulty in doing this in two steps?|||The difficulty is,
I have to create a report in Step one and have to save it to the disk. Right in which format i would store it so i can again open it through crystal report and send its print?

Or is there any other format to store the generated report? SO i can print it again through crystal report.

I don't want to use MS Word or Adobe automation for printing.

Regards|||If you show the report in your application, enable print button so that you can print it from CR|||Madhi
Thanks for the reply but i think you are not getting the issue which i am facing.
My application runs as Windows Service it has no GUI.
Also first i have to create a report , save it to the disk. The other process will print that saved report file.

I can save the report in pdf, word and other suported formats but to print pdf i have to use Adobe or to print word i need MS Word. Which i don't want.

I directly want to print the saved file.

Regards|||Well. Which front end application are you using?|||There is no such Front End.

The request is submitted to the data base and the application checks the data base for any new request.

On the new request it generates the report and stor/export in specific format also updates the data base.

The other application picks the stored documents/files and prints then, email or fax them then again update the database.

Email and Faxing is working well but the print is creating problem as i described in my previous reply.|||See if you are able find solution here
http://support.businessobjects.com/

Print Name (field from dataset) On Every Page (Page Header)

Hello,

I am using the ReportViewer control and Client-Side Processing to display a Training Report that works great.

However, I need find a way to have one of the fields of my dataset display on every page of the report (Page Header).

I receive this message "The Value expression for the textbox FName refers to a field. Fields cannot be used in page headers or footers".

Is there a way to get this field to appear on every page of the report (preferably at the top).

Thanks for any help that you can provide me.

This is easy all what you need to to is to add ne parameters which get his value from your dataset fileds and then use this parameters in your page header or footer read this turtorial it will help you

http://technet.microsoft.com/en-us/library/bb508810.aspx

read the section titled " Assigning report parameter values using consolidated fields "

|||

hey

I told the answerin different post ( http://forums.asp.net/t/1160246.aspx ), but repeat it for you

you should define a Parameter for your report from Layout section ,then ( right click insome empty place in outeside of your report table, you'll see a context menu with 4 Items , select the Report Parameter) ,then create a Textbox inside your Header or Footer , then rightclick onthe textbox and and select Expression , then put the followingcode in it .

=Parameters!ReportFooterParameterName.Value

goodluck ,|||

I appreciate the help. I am not quite sure what to do when setting up the Report Parameters to fill this textboxt with the field from my dataset. Would you mind giving me a little guidance in this area?

I am getting the message A Value expression used for the report parameter 'Name' refers to a field. Fields cannot be used in report parameter expressions.

Thanks again!

|||

ok ,

let me describe it for you

there is 2 different type of value in reporting server ,

1 ) the filed that you provide by DataBase that will display like Filelds!DBFiledName.Value

2 ) the filed that you provide by getting information fromuser or from yourexisting Query this type of values called Parameters and will display asParameters!ReportFooterParameterName.Value

when you want to show oneparameter inHeader orFooter ,you can't useFields it means all the textbox that you put in header / footer , shouldcomplete byParameters ,

for sending parameters to header or footer , you have2 option ,

Take it FromUser or programmatically fill the Parameter , in commonly uses , we set the parameters Programatically , like

@.myParameter = "hello world!"

when I use the myParameter in Header, itwill display thehello world! ,

but if youuse the Fields inHeader or Footer it cousean error thatyou taken it .

for sending a parameter to your header , pleaseread the post above ,

Thank you , 7 Goodluck

Print Multiple Documents with VS2005 Local Report

Hello all.
I have a document (that could be for example an invoice) that was done with
VS2005 Local Report. This document is exported to PDF in the application
(with response.OutputStream.Write).
Now I want to be able to print multiple documents (for example invoices), by
generating a PDF with all the documents selected by the user.
I can generate as many local reports as i want to with the desired data. But
how can i export them to a single PDF file?
I will appreciate any comments.I am trying to do this also -- except printing, does anyone have any
suggestions? I can call the report over and over again, but then I get a
print dialog for each iteration of the report.
Thanks!
"Orlando" wrote:
> Hello all.
> I have a document (that could be for example an invoice) that was done with
> VS2005 Local Report. This document is exported to PDF in the application
> (with response.OutputStream.Write).
> Now I want to be able to print multiple documents (for example invoices), by
> generating a PDF with all the documents selected by the user.
> I can generate as many local reports as i want to with the desired data. But
> how can i export them to a single PDF file?
> I will appreciate any comments.|||Just to say that I solved this problem by redesigning my local reports to
support multiple documents.
I couldn't find another way to do this.
"Joel" wrote:
> I am trying to do this also -- except printing, does anyone have any
> suggestions? I can call the report over and over again, but then I get a
> print dialog for each iteration of the report.
> Thanks!
> "Orlando" wrote:
> > Hello all.
> >
> > I have a document (that could be for example an invoice) that was done with
> > VS2005 Local Report. This document is exported to PDF in the application
> > (with response.OutputStream.Write).
> >
> > Now I want to be able to print multiple documents (for example invoices), by
> > generating a PDF with all the documents selected by the user.
> >
> > I can generate as many local reports as i want to with the desired data. But
> > how can i export them to a single PDF file?
> >
> > I will appreciate any comments.

Print Multiple Copies

Is there any way to send a quantity to the print que to deterimine the
number of copies to print?
I need to deliver a copy of a report to each department that is
reflected on areport. Let's say for example, I have a report that has
3 departments with line items to be produced by each department, can
query the count of departments and send this count to the print que to
get this report to print three copies?
This report is being developed in SRS2000.
Thanks to all who respond!On Apr 26, 11:35 am, ba_wvu <bander...@.allin.com> wrote:
> Is there any way to send a quantity to the print que to deterimine the
> number of copies to print?
> I need to deliver a copy of a report to each department that is
> reflected on areport. Let's say for example, I have a report that has
> 3 departments with line items to be produced by each department, can
> query the count of departments and send this count to the print que to
> get this report to print three copies?
> This report is being developed in SRS2000.
> Thanks to all who respond!
As far as I know, there is not an option to do this. That said, you
can group by Department as part of the table/matrix control and select
'Page break at end' as part of the grouping properties. That way you
would only need to print one copy and each Department would print on
its own page(s). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||if the departments are fixed,then what you can do is to create a subscription
and give the dept ids. so it reaches all the dept.
See if you can use this, if possible.
Amarnath
"ba_wvu" wrote:
> Is there any way to send a quantity to the print que to deterimine the
> number of copies to print?
> I need to deliver a copy of a report to each department that is
> reflected on areport. Let's say for example, I have a report that has
> 3 departments with line items to be produced by each department, can
> query the count of departments and send this count to the print que to
> get this report to print three copies?
> This report is being developed in SRS2000.
> Thanks to all who respond!
>|||Thank you both for your responses. In a response to your comments - I
currently have the report page breaking on the grouped departments,
but the floor manager wants to see all items, not just a particular
departments items, on the shop order. And the departments are not
always fixed, orders can always have different departments. So I'm a
little stuck. Any additional comments/responses are appreciated.

Print Multi table report with a range of parameters.

We have a work order print that is called from a web page using a URL. The
print consists of 4 tables. All of the recordsets use the same parameters
but come from different data sets. I have a request to make it print
multiple work orders at a time.
When I use a select for multiple work orders it prints it all in one set of
tables but I want a seperate set of tables for each work order. Is there a
way to group the tables together?
Any other ideas?You need to use a list control, and if your reports are in RS 2000, you need
to do some hand editing of the xml.
First create your list, then add the table which displays the actual data +
any textboxes for headings and such.
Then you mark your list, and set the Grouping property to the Work Order ID.
If you're working with RS 2005, right click on the list in the report,
choose Properties. Click on the "Edit Details Group" Button. Select "Page
Break at end". (Or start, if you want.)
If you're working with RS 2000, you need to hand edit your RDL like this:
Open the code version of the report
Find your list
In the Grouping section, add <PageBreakAtEnd>true</PageBreakAtEnd>
Your code should look something like this:
<List Name="List1">
<Style>
<FontFamily>Times New Roman</FontFamily>
<FontSize>18pt</FontSize>
<Color>Maroon</Color>
<FontWeight>900</FontWeight>
</Style>
<Top>0.875in</Top>
<Grouping Name="ListGrouping">
<GroupExpressions>
<GroupExpression>=Fields(Parameters!PageGroupingParameter1.Value).Value</GroupExpression>
<GroupExpression>=Fields(Parameters!PageGroupingParameter2.Value).Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
Save the code, and test the report. Did it work?
Kaisa M. Lindahl Lervik
"msc" <matt@.dontspam.com> wrote in message
news:6C0D2B4C-DCED-4559-A849-18B260FA7C03@.microsoft.com...
> We have a work order print that is called from a web page using a URL.
> The
> print consists of 4 tables. All of the recordsets use the same parameters
> but come from different data sets. I have a request to make it print
> multiple work orders at a time.
> When I use a select for multiple work orders it prints it all in one set
> of
> tables but I want a seperate set of tables for each work order. Is there
> a
> way to group the tables together?
> Any other ideas?
>sql

Print list of tables with Identity row set to NOT FOR REPLICATION

Does anyone know if there's an SQL command i can run that will list
the tables in a database that have an identity column set to NOT FOR
REPLICATION?

Many thanks

Dan Williams."Dan Williams" <dan_williams@.newcross-nursing.com> wrote in message
news:2eac5d02.0406030812.2651f9e6@.posting.google.c om...
> Does anyone know if there's an SQL command i can run that will list
> the tables in a database that have an identity column set to NOT FOR
> REPLICATION?
> Many thanks
> Dan Williams.

select TABLE_NAME, COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
where columnproperty(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdNotForRepl') =
1

Simon|||Cool. Thanks for that, it worked a treat.

Dan

"Simon Hayes" <sql@.hayes.ch> wrote in message news:<40bf6492$1_1@.news.bluewin.ch>...
> "Dan Williams" <dan_williams@.newcross-nursing.com> wrote in message
> news:2eac5d02.0406030812.2651f9e6@.posting.google.c om...
> > Does anyone know if there's an SQL command i can run that will list
> > the tables in a database that have an identity column set to NOT FOR
> > REPLICATION?
> > Many thanks
> > Dan Williams.
> select TABLE_NAME, COLUMN_NAME
> from INFORMATION_SCHEMA.COLUMNS
> where columnproperty(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdNotForRepl') =
> 1
> Simon

print list of queries, tables, views and sp

I just started a new job and 1st time on sql server, how can i print list of queries, tables, views, stored procedures and functions?What do you mean by print?
What version of SQL Server are you running? This will have an effect on the query you need to run. The below example was written for 2000

SELECT name
, id
, type
FROM sysobjects
WHERE type IN ('V', 'U', 'SP', 'FN')
-- v = view, u = table, sp = sproc, fn = user-defined function|||2005 Users Note:
BOL Says
Important: This Microsoft SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use catalog views instead.

Any general comments as to whether we should still be coding with sysobjects ?

:angel:

GW|||We are kind of caught on the edge of the sword on this issue. Because users rarely give us enough information to know what version of SQL they are using, we tend to give them the answers that work under the largest possible set of conditions.

You are correct, using the catalog views is preferable if you are running a version of SQL Server that supports the catalog views. On a "going forward" basis, you probably ought to only use the catalog views, but on a "forum answer" I tend to stick with what will work for the largest number of people.

-PatP|||Anybody have the catalog solution to hand?

I don't get to play on much 2K5, but I am going to be taking my MCTS in it in a couple of months, so I should really get brushed up on it :p|||Play around with the view sys.objects. You should have it in no time. I think id changed to object_id, but most of the rest is the same.|||SELECT ROUTINE_TYPE, ROUTINE_SCHEMA, ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES

SELECT TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES-PatP

Print Layout Settings

How can I set default print properties for a report in a ReportViewer control?

Do I have to set it by the report or by the ReportViewer?

I mean properties like A4 page, and Landscape layout?

?|||

The print properties can be defined in the RDL. The page size, width, etc.. are properties in the RDL. The layout for landscape can be pre-set by setting the width and hight to 11x8.5.

This link might help: http://msdn2.microsoft.com/en-us/library/ms159237.aspx

Print Layout feature showing black

Today I received a Windows Update that included SQL 2005 SP2. Since
that time whenever I try to use the "Print Layout" feature in
Reporting Services, it shows nothing but black. Does anyone know of a
fix for this?Here you go: http://support.microsoft.com/kb/935356/en-us
This is the new cumulative update that should fix your issue. You'll need
to follow the steps on the page to request the fix.
This is one of the bugs fixed:
50001105 After you apply SQL Server 2005 SP2, the Print Preview feature in
Reporting Services may show a solid black page.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: cphite@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Print Layout feature showing black
> Date: Thu, 04 Oct 2007 13:17:24 -0700
> Today I received a Windows Update that included SQL 2005 SP2. Since
> that time whenever I try to use the "Print Layout" feature in
> Reporting Services, it shows nothing but black. Does anyone know of a
> fix for this?
>|||On Oct 4, 4:52 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Here you go:http://support.microsoft.com/kb/935356/en-us
> This is the new cumulative update that should fix your issue. You'll need
> to follow the steps on the page to request the fix.
Thanks, Chris - that worked perfectly.|||Great. You wern't the only person I've seen that had that problem.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: cphite@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Print Layout feature showing black
> Date: Fri, 05 Oct 2007 07:56:08 -0700
> Organization: http://groups.google.com
> On Oct 4, 4:52 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Here you go:http://support.microsoft.com/kb/935356/en-us
> >
> > This is the new cumulative update that should fix your issue. You'll
need
> > to follow the steps on the page to request the fix.
> Thanks, Chris - that worked perfectly.
>

Print layout

Hi all!
I have a problem trying to make ma report print in LEGAL format by default.
I had set:
Interactive size to 14in, 8.5in
Page size to 14in, 8.5in
Now my report is in landscape by default wich is ok, but I can't find the
way to make it print in legal format by default instead of letter.
Someone knows how to do this?
Thanks, JulienHello Julien,
I would like to know how you configure your body size of the report.
How long did your body size plus the page header and page foot?
Based on my test, I have a report without page header/foot. And I set the
body to be 14in, 8.5in. And I could see that when I try to print the
report, it will use Legal as the format.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||I didn't change de body size, so it's 7.25in, 0.84in
But even when I set it to 14in, 8.5in and I deploy, refresh, print. My
original paper size is set to Letter and my Print paper size is set to same
as original, so Letter.
At least the orientation is the one I want, landscape.
Can it be an incompatibility with my printer?
I'm using a Toshiba e-Studio282.
Thanks in advance.
Julien
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:%238zWbnCbHHA.928@.TK2MSFTNGHUB02.phx.gbl...
> Hello Julien,
> I would like to know how you configure your body size of the report.
> How long did your body size plus the page header and page foot?
> Based on my test, I have a report without page header/foot. And I set the
> body to be 14in, 8.5in. And I could see that when I try to print the
> report, it will use Legal as the format.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Julien,
What about when you preview the report in the development environment?
If you click the Page Setup, What's the result?
Per my experience, this issue may caused by the incompatibility with your
printer if your printer did not support Letter.
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.|||My Printer support letter, legal, A4 and many more.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:y60B5pRbHHA.752@.TK2MSFTNGHUB02.phx.gbl...
> Hello Julien,
> What about when you preview the report in the development environment?
> If you click the Page Setup, What's the result?
> Per my experience, this issue may caused by the incompatibility with your
> printer if your printer did not support Letter.
> 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.
>|||Hello Julien,
Could you please let me know what's the version of Reporting Services you
use? Have you applied the Services pack?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||RS 2005
no sp applied yet
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:DVkTe%233bHHA.1820@.TK2MSFTNGHUB02.phx.gbl...
> Hello Julien,
> Could you please let me know what's the version of Reporting Services you
> use? Have you applied the Services pack?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Julien,
Could you please applied the latest Services Pack for Reporting Services?
How to obtain the latest service pack for SQL Server 2005
http://support.microsoft.com/kb/913089/
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
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.|||Julien, hi -- I have a couple of wacky questions for you...
1) What is the DEFAULT printer on your box (I know that the printer you are
printing to is the Tosh, but if this is a server-mode report, it may not be
being constructed under your user identity... you can see where I'm going
withi this) ?
2) If question #1 does not help at all, what if you created a second Tosh
printer setup in which the DEFAULT layout for that setup was legal size, and
then you printed to that second printer setup?
BTW: I've seen something similar to this. For example, I have difficulty
getting the Excel export to respect a landscape orientation in a report that
prints landscape just fine to the printer driver.
The question is figuring out which rendering component is seeing the wrong
setup information, and at what moment it's having the trouble. I think
there really is a bug here but if we understand the bug we will be able to
figure out our workarounds <shrug>.
>L<
"Julien Bonnier" <julien@.m0851.com> wrote in message
news:erCs3m7bHHA.2088@.TK2MSFTNGP05.phx.gbl...
> RS 2005
> no sp applied yet
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:DVkTe%233bHHA.1820@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Julien,
>> Could you please let me know what's the version of Reporting Services you
>> use? Have you applied the Services pack?
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>

Print Issues with Reporting Services

I developed and deployed a report using VS.net. Reporting Services gives you the option on the web page to print the report or export to another format. When choosing to print, I am unable to get the report to print in landscape mode on standard letter paper. What is the relationship between the margin properties (which seem to have no impact) on the report? the body of the report? and the printer?
The report size doesnt seem to matter (10 x 7.5 inches) tried changing margins here also
The body size doesnt seem to matter (9.75 x 7 inches) and here

Does the issue lie with
a) the printer properties
b) Reporting services
c) IE
Im stumped!!

Hopefully, you are using the Sep. CTP or later, since there was a known issue earlier with landscape printing. After the report server was upgraded, I still had to manually delete the old RSClientPrint Class file on my PC, which was cached under the "Downloaded Program Fles" folder (RTM version is: 2005,90,1399,0).

Print is not allowed in UDF

I want to put some trace in the a UDF, so I put print in the function. IT gave error. Can anyone please explain why this happen. But this work with SPs.

Cheers

Shimit

Hi,

this is just simply one of the limitations UDFs take, like not being able to execute something via EXEC or executing a SP in common, or using GETDATE() in functions...

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Print in Trigger Statements.....

SQL Server books online has 'print' statements in the trigger examples.
Where exactly the print will happen? How to get benefit of this while
debugging?
Thanks,
Jessy
You can make execution visible in the query analyzer, can print out some
information about filled variables, rowcounts, status of transactions etc.
While debugging you can also watch the value of the variable with the
properties pane.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jessy Martin" <Jessy_Smith79@.hotmail.com> schrieb im Newsbeitrag
news:%23MweP25ZFHA.616@.TK2MSFTNGP12.phx.gbl...
> SQL Server books online has 'print' statements in the trigger examples.
> Where exactly the print will happen? How to get benefit of this while
> debugging?
> Thanks,
> Jessy
>

Print in Trigger Statements.....

SQL Server books online has 'print' statements in the trigger examples.
Where exactly the print will happen? How to get benefit of this while
debugging?
Thanks,
JessyYou can make execution visible in the query analyzer, can print out some
information about filled variables, rowcounts, status of transactions etc.
While debugging you can also watch the value of the variable with the
properties pane.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Jessy Martin" <Jessy_Smith79@.hotmail.com> schrieb im Newsbeitrag
news:%23MweP25ZFHA.616@.TK2MSFTNGP12.phx.gbl...
> SQL Server books online has 'print' statements in the trigger examples.
> Where exactly the print will happen? How to get benefit of this while
> debugging?
> Thanks,
> Jessy
>sql

Print in Trigger Statements.....

SQL Server books online has 'print' statements in the trigger examples.
Where exactly the print will happen? How to get benefit of this while
debugging?
Thanks,
JessyYou can make execution visible in the query analyzer, can print out some
information about filled variables, rowcounts, status of transactions etc.
While debugging you can also watch the value of the variable with the
properties pane.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Jessy Martin" <Jessy_Smith79@.hotmail.com> schrieb im Newsbeitrag
news:%23MweP25ZFHA.616@.TK2MSFTNGP12.phx.gbl...
> SQL Server books online has 'print' statements in the trigger examples.
> Where exactly the print will happen? How to get benefit of this while
> debugging?
> Thanks,
> Jessy
>

Print in Landscape

What's the trick to get reports to correctly print in Landscape mode? Most
recent solution does print using special code, but always does an extra
blank page dump at end.To print reports in landscape mode, you have to set page size to 29,7 cm; 21
cm.
After doing this, be sure that all your report items are placed into this
size, taking into account also the margins you have configured. This is to
say that your report width can not be greater that 29,7 cm - Left margin -
Right margin. This way, you will not have extra blank pages in your report.
Hope this helps,
Mónica
"Joe" <hortoristic@.gmail.dot.com> escribió en el mensaje
news:F97F6B2E-378E-45DD-9128-C4047DBED424@.microsoft.com...
> What's the trick to get reports to correctly print in Landscape mode?
> Most recent solution does print using special code, but always does an
> extra blank page dump at end.

Print in Landscape

Is possible to set a report to print in landscape by default?
ThanksSet report width larger than report height.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Goldin" <markgoldin@.comcast.net> wrote in message
news:OIB616FbEHA.4048@.TK2MSFTNGP10.phx.gbl...
> Is possible to set a report to print in landscape by default?
> Thanks
>

Print Icono

Dear
Why in my reports dont show print icono or print button?
Help me pleaseDid you install Service Pack 2 on your server ?