Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 30th, 2004, 04:20 AM
gnostic gnostic is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2004
Posts: 1 gnostic User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question reporting services problem

Hi!!
I make reports with visual studio.net using microsoft reporting services.The problem arise when i export reports in pdf format..Everything is ok except that the studio exports an extra blank page. The whole report fits into the first page but in pdf format the document contains two pages.
Do you now how can i fix this problem..I've tried with report properties, Layout...but i didn't got to solution..
If the report contains two pages then the pdf document shows 4(two blank) and so on..
Also, when i make report with a lot of matrices(report with more pages), one below another, besides the first problem arises another..The other problem is that in the export file unlike the first page the rest are not like in preview mode-matrices goesone over another..i can't fix this too..
ok, thanx!!

Reply With Quote
  #2  
Old June 11th, 2004, 03:55 AM
jpvalentin jpvalentin is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 2 jpvalentin User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
In fact, the blank page problem in PDF format is made by the bad size of the report.
The size of the report must be the same of the paper page for export to PDF format.
See the report properties to correct the page size :
Exemple : Width = 21cm & Length = 29,7cm.

Reply With Quote
  #3  
Old June 23rd, 2004, 05:41 PM
applearner applearner is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Posts: 1 applearner User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Reporting Services

Hi

I am using .net and MS-SQL SERVER Reporting Services. I have to do some reports for Search Creteria. If I choose 5 fields in ASP page I have to show only 5 columns with multiple rows inthe report page. If I choose 10 fields in ASP page then I have to show 10 columns with multiple rows in my report. Is it posible to send a select statement to report page at RUNTIME?

Reply With Quote
  #4  
Old July 21st, 2004, 08:01 AM
lazymale lazymale is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 4 lazymale User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Quote:
Originally Posted by jpvalentin
In fact, the blank page problem in PDF format is made by the bad size of the report.
The size of the report must be the same of the paper page for export to PDF format.
See the report properties to correct the page size :
Exemple : Width = 21cm & Length = 29,7cm.

Hi.

You are right JP but i think i disagree that the size of the report needs to be same as the A4 sheet.

gnostic, Here is my solution:-

If you want your report to come in a PDF format and on A4, the width of following have to be checked:
Body

Header image (if any)

Footer image (if any)

The width of these must be less than the actual size of an A4 sheet (8.5 inches). Now I am not certain what the exact calulation is for this. It worked for me when i gave the width of all of the above as 7.6 inches, which is almost an inch less than the actual size of an A4 sheet.

Try this and hope it helps.

Lazy Male.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > reporting services problem


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT