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 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 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 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 Headers issues in SSRS 2005

I have a report, with 220 records, each row heigth varies. I have set the option to repeat header on every page on. However, when I print the report, the header prints on some pages, and some it does not. For eg, on the 5 page reprot, it prints the header on pg 1, 2 and 3. Then on pg 4 it does not, then again page 5 it prints the header.

Any advise.

The layout of the report has 15 fields. I have narrowed down the issue, to 1 column eg COMMENTS.. This is a comment field(has commnets and description data, ) size of col =2 in. This field is huge, ie has lot of data..So When I Hide this field, then the Report headers prints just fine.

The minute I UNHIDE This field, the print header issues comes back , ie on some pages the header is printed , on some, where the comments are huge, the header does not print.

Pl advise.

print header on the first page only

I have a table grouped by id. The detail for a particular group can span
serveral pages.
I have 3 header lines for each group . I want to print all 3 header rows on
the first page of the group and only one of the header rows on the next pages
of the group.
Does any one know how to do this?
--
MarieI found a solution here.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=227646
--
Marie
"Marie" wrote:
> I have a table grouped by id. The detail for a particular group can span
> serveral pages.
> I have 3 header lines for each group . I want to print all 3 header rows on
> the first page of the group and only one of the header rows on the next pages
> of the group.
> Does any one know how to do this?
> --
> Marie

Print Footer only on Last Page

I need to print a footer only on the last page of my report ? how can i do that...
also
in other report i have to print a part of footer(data is subset of the whole footer) and the whole footer on the last page.How can i do this
ThanksYou can conditionally hide what you don't want to see based on
Globals.PageNumber and Globals.TotalPages
For example, you could put the entire page footer into a rectangle and set
its Hidden property to:
=Globals.PageNumber<Globals.TotalPages
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Sunny" <Sunny@.discussions.microsoft.com> wrote in message
news:90130113-38FE-4579-B6C9-68BDE4C40055@.microsoft.com...
> I need to print a footer only on the last page of my report ? how can i do
that...
> also
> in other report i have to print a part of footer(data is subset of the
whole footer) and the whole footer on the last page.How can i do this
> Thanks
>|||Hey thanks...i saw your other reply for similar question later on.thanks anyway
"Chris Hays [MSFT]" wrote:
> You can conditionally hide what you don't want to see based on
> Globals.PageNumber and Globals.TotalPages
> For example, you could put the entire page footer into a rectangle and set
> its Hidden property to:
> =Globals.PageNumber<Globals.TotalPages
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Sunny" <Sunny@.discussions.microsoft.com> wrote in message
> news:90130113-38FE-4579-B6C9-68BDE4C40055@.microsoft.com...
> > I need to print a footer only on the last page of my report ? how can i do
> that...
> > also
> > in other report i have to print a part of footer(data is subset of the
> whole footer) and the whole footer on the last page.How can i do this
> >
> > Thanks
> >
>
>

Print fixed number of rows per page

I am trying to migrate an existing report / form. I am using a table
and want to print 15 rows per page - even if there are less data rows
available for my grouping. The blank rows (printed with borders) are
used to write in additional transactions throughout the day.
Any way to accomplish this? I am new to Reporting Services.
Thanks.Try this in the group expression.
=Int((RowNumber(Nothing)-1)/15)
Amarnath, MCTS
"jjoll" wrote:
> I am trying to migrate an existing report / form. I am using a table
> and want to print 15 rows per page - even if there are less data rows
> available for my grouping. The blank rows (printed with borders) are
> used to write in additional transactions throughout the day.
> Any way to accomplish this? I am new to Reporting Services.
> Thanks.
>

Print File Size

Just installed SP2 and started experimenting with the print functionality.
The size of the print jobs are huge. I had a fairly simple six page report
with a spooling size of over 100 mb, a single page over 17mb. Is there
anything that can be done to reduce this size . If not, we will not be able
to use the functionality as the network just will bog down - it is back to
printing out pdf files - which the users do not like.
Any hope of getting around this?This is the current behavior and there is no workaround. We are looking at
what we can do to make this better for the Yukon Release.
--
| Thread-Topic: Print File Size
| thread-index: AcVi/0NJpHDoEkgjQrGWFSnnPT784w==| X-WBNR-Posting-Host: 24.97.250.114
| From: "=?Utf-8?B?Y2hyaXM=?=" <chris@.discussions.microsoft.com>
| Subject: Print File Size
| Date: Fri, 27 May 2005 14:01:33 -0700
| Lines: 12
| Message-ID: <BBD25630-CC0A-4176-AEE4-03EC7BE22C6D@.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.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:44927
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Just installed SP2 and started experimenting with the print
functionality.
| The size of the print jobs are huge. I had a fairly simple six page
report
| with a spooling size of over 100 mb, a single page over 17mb. Is there
| anything that can be done to reduce this size . If not, we will not be
able
| to use the functionality as the network just will bog down - it is back
to
| printing out pdf files - which the users do not like.
|
| Any hope of getting around this?
|
|
|
|
|

Print ER diagram for a database in SQL Server

Uday,
right-click on the white background on the database
diagram and select Page Setup. You can select different
page sizes and scale ratios on this form.
Rgds,
Paul Ibison (SQL Server MVP)
You might also want to create "subject" areas by creating several individual
diagrams for the functional areas of the database instead of the entire
thing in one.
Sincerely,
Anthony Thomas

"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:02af01c4dc3c$1ce5b0a0$a601280a@.phx.gbl...
Uday,
right-click on the white background on the database
diagram and select Page Setup. You can select different
page sizes and scale ratios on this form.
Rgds,
Paul Ibison (SQL Server MVP)
sql

Print each tables in new page Options

Hi All,

I have a report which has four tables in it. But I have only one
Dataset. Since this dataset has more then 30 fields, I have divided
this into four tables to be shown in a report. This will help the user
to take print of the report and place each print out side by side for
view.

Showing each table in a new page is just fine. It works. But when we
take print out some times rows of second table are printed in same
page that shows rows of first table.

With this user can not put each print out side by side for view.

Is there any way to set option like print each table in new page? I
mean to say after printing first table, second table print should
start at new page.

Thanks in advance.

This is actually pretty easy (if it is what I think it is). I did this the other day with the same amount of data you are dealing with. Just get to the table's property pop-up menu and under the "General" tab click the check box next to "Insert a page break after this table". That should do the job for you. But I would suggest putting the tables directly under each other if you have manually spaced them out onto each page. This way you won't have awkward whitespace at the beginning of each page. Let me know if this helps you.|||

Thanks for the reply.

I forgot to mention one point. I have set visibility property on tables. Will this visibilty property affects how pages are printed?

Regards,

|||Yes, the visibility will most likely affect your formatting. I'm assuming you're using the dynamic visibility function for each table, as opposed to just a child object of the table. In this case it is harder to give you a solution. The reason is because SSRS 2005 is not capable of dynamic table relocation. If you could give me more specifics about which objects are dynamically visible then I might be able to offer a solution to your problem.|||

The whole table visibility is set through expression based on user input.

The report has large number of fields to be shown. If user selects Print format then these four tables will be shown to user to and user can take print out of the same. If user selects export format then all fields will be shown in one table and the above mentioned 4 tables will be hidden.

But report is shown properly. All four tables are shown in new page if user selects Print option. Page break is OK. While printing, report is printed continuously. No Page breaks while printing.

Is there anyother approach to this problem?

Print custom page in asp.net

How could i print a custom page (8.5in X 5.5in) in asp.net 2.0 ?

If you are using ssrs to do the report you can set the margin size by right clicking on the gray area of the body of your report this will bring up properties click on the layout tab you can set the size of your report here.

Please mark as answered if this helps you

print blank page

i export my report to pdf and its leaving one blank page with every alternative page

is there any setting?

thanks

Make sure your layout, pagesize and margins all agree. Also, search this forum. This topic has been addressed several times in the past.|||Look at the report body width. If, for example, you set your margins to .5" on a portrait report, in this situation your body may be 7.500001". I have found this from time to time. The amount is so slight that looking at it won't do you any good. Click on the body and look at the width, then try to find the object that is causing the width to exceed your margins. I would first check your table width.|||

I'm using landscape and in my body property

width=11in

height = 4.125in

what does it mean, i have to reduce the width or height?

thanks a lot

|||

i fixed myself

i have to reduce the width size

|||

The trick to landscape vs portrait reports is by default portrait is set to 8.5 x 11 in the report properties. All you have to do is flip these two values around.

Jon

Print at bottom of page.

Hi.

I know the function of being able to set a section of a report to print at the bottom of the page, but does anyone know any work arounds for this? I have a main report (statement) which ive done a work around, to include the details i need at the bottom of the page into the footer, but then i have a second report (invoice) that needs to be included as subreport, which also needs infomation at the bottom of the page, but as its a subreport, sql reports does not allow for footer/header infomation in a subreport.

Unfortuantly i can not split the two reports out as they need to be printed together.

Any help/recomendations would be greatly received.

Thanks

Tom

Can't you create a page footer on the report that is being used for the subreport?|||

Hi, Thanks for the reply,

a subreport will not show either the page header or the footer unfortuantly.

Thanks

Tom

|||I apologize, I was not aware of this and I just tested a report trying to show the report footer, and you are correct. If I think of way, I will let you know.|||

i know its a right pain!

Thanks for having a look.

Tom

Preventing duplicate database entries

Hi all.. I've been scouring the forums for about 6 hours to noavail. This is a really simple question. I'm trying to havea registration page that lets the user input name, email, desiredusername, and password. I want to check the username and emailfields to make sure ppl cannot sign up twice. So from what I'vegathered I have a couple of options:

1) i can set up a unique constraint on the database columns,
2) i can run a select statement before inserting,
3) i can store the whole database column in a variable then search through it.

My question is how to do option 2? All of my transactions are through a sqldatasource object in c#.

since you mentioned sqldatasource I am assuming you are working with SQL Server. You could write a stored proc and do a conditional INSERT.

CREATE PROC..

...

BEGIN

IF NOT EXISTS ( SELECT * FROM table WHERE username = @.username ANDemail=@.email...)

BEGIN

-- do the INSERT

END

ELSE

BEGIN

--the user already exists. return an appropriate message

END

|||Do #1, then catch the constraint error in sqldatasource_inserted event.|||Stored procedures are pretty exciting and cool.. I'm about to spendsome time reading up on them because there's a lot for me to learn (howto execute them, syntax, capabilities, etc.). Appreciate thereply ndinakar. I'll figure this out soon I'm sure.|||I've spent a considerable amount of time trying to set up a constrainton the email and usernames fields to no avail. This is how I'vebeen going about it:

1)in server explorer, double click my table
2)right click the email column, select Check Constraints
3) Add new

Now it asks for an Expression. No idea what to enter here I triedthe single word "UNIQUE" but that is wrong. And, all my web/forumsearches regarding the subject were unsuccessful- lots of regularexpression results returned.

Similarly, I tried playing around with the Indexes/Keys option insteadof check constraints option. I thought this would give me moreluck since it looks like you can select from a drop-down which columnsyou want to apply the effect to. Problem here is the drop-down isonly populated with one column, the PK.

I'm thinking I need to head over to the bookstore and park myself thereuntil I figure some things out- sick of staring at the monitor. Thanks for the reply.|||

You can also do it via script from Query Analyzer:

ALTERTABLE <tableName> ADD COSNTRAINT <constraint_name> UNIQUE(<column1>,<column2>,<column3>)

|||It's not a check constraint, it's really a unique index that you build.