Boolean Report Parameters

Hi, I have created a report parameter using a Boolean data type.

When I preview my Report I can select either True or False for this parameter. Is there any way of changing the 'True' label to say something else and again the same with the 'False' label?

Click on Report-Parameters

Select your parameter and go down to Available Values

Type in a label and the value

ex.

Open - True

Closed - False

Simone

|||This brings the values up in a list box, I was hoping to keep the selection as tick boxes but amend 'True' to say 'Open' for example.|||

I ran into the same issue today when I tried to change "String" parameter to "Boolean", and hoping to have radiobox instead of listbox dropdown.

No good, it'd be boolean type with dropdown, which is the same as "String" type essentially

It'd be nice to able to change label for "True" and "False"

Boolean report parameter with Yes/No choice list

SSRS 2005
In the Report Designer you can specify a Boolean report parameter with a
list of values. When the report is viewed on the Preview tab, the dropdown
list is rendered for the parameter instead of the usual True/False radio
buttons.
However, when the report is run on the Report Server, the same report
parameter is rendered with the usual True/False radio buttons and the defined
list is ignored.
Is this a bug in Report Designer, Report Server or both? Are there plans to
fix one of these so at least the behavior is consistent?
--
Chris, SSSIHello Chris,
I have reproduced this issue.
I am contacting the product team to check whether there is any fix or
workaround for this issue. I appreciate your patience.
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 Wei,
Any update on a fix or workaround for this?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I have reproduced this issue.
> I am contacting the product team to check whether there is any fix or
> workaround for this issue. I appreciate your patience.
> 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 Chris,
The product team is still look into this. I will update any information
ASAP.
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 Chris,
After a long discussion with internal product team, this issue has a
workaround:
Use a string parameter with a Valid Values list instead.
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.

book

It seems that there are only two books on SSIS

The Rational Guide to Scripting SQL Server 2005 - BETA preview

Professional SQL Server 2005 Integration Services by wrox

Has anyone read these or any other ones out there?

Any thoughts on which to get?

I am very new to SSIS.

Thanks

hi,

I don't believe it. Only two?

I'd like to acquire Wrox book. I had one about .Net and it was awesome

|||

I refer you to your previous post in which you asked the same question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425223&SiteID=1

-Jamie

|||

Hi, Just thought the other post was getting old.

Problem solved.

Thanks

|||

fmardani wrote:

It seems that there are only two books on SSIS

The Rational Guide to Scripting SQL Server 2005 - BETA preview

Professional SQL Server 2005 Integration Services by wrox

Has anyone read these or any other ones out there?

Any thoughts on which to get?

I am very new to SSIS.

Thanks

i have both books and find each to be helpful.|||

What is the difference between the two?
Isn't the one with the relational guide... title for the beta? if so isn't it different to the final release version?

Thanks

|||

As is stated in the other thread (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425223&SiteID=1) there is another version coming out soon for RTM.

-Jamie

Body BackgroundImage not displayed in browser

I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.

However, if the report is printed, or exported to PDF or Excel, the background displays correctly.

It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.

Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?

This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.

-Chris

|||

I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?

Thanks!

Body BackgroundImage not displayed in browser

I have been trying to set up reports with a background image. The background displays correctly on the preview tab in Visual Studio, but is not visible when deployed to the report server and rendered in Internet Explorer.

However, if the report is printed, or exported to PDF or Excel, the background displays correctly.

It does not seem to make any difference if the image is external or embedded. Also, the problem only seems to affect the Body properties; a background image attached to a table, for example, seems to display correctly.

Has anybody else seen this behavior? I have not done extensive testing, but every report that I have tried seems to have the same problem. Is there a setting someplace that I am missing, or is this perhaps a bug in IE?

This sounds like a known issue in RS 2005 SP1 where the background images does not show up when rendering with the ReportViewer control. This was addressed in a Hotfix and will also be fixed in Visual Studio 2005 SP1.

-Chris

|||

I am running RS 2005 with SP2. When I render a RS report to Internet Explorer the background image still is not displaying, though the image does print. Exactly as described in the origional message. Any ideas?

Thanks!

Blank Parameters

I am trying to use a stored procedure that can accept blank parameters to
return a complete set of data. when I use the preview screen in reporting
services, the sproc does not return anything, yet when i run the sproc from
anywhere else, it works. Is there a setting I am missing to be able pass
balnk values to a sproc from the report?
Yes, if i pass values to the report, not blanks, the sproc does run and
returns data.
--
John Cleveland
Network Manager
Urban systems LtdTry using SQL Profiler to find out what is actually sent to the stored
procedure. Blank might not be blank. Do you expect a NULL or a '' as a blank
in the sp? Anyway, SQL Profiler shows what is actually sent, so you can
modify either Parameter or Stored Procedure accordingly.
Kaisa M. Lindahl Lervik
"John Cleveland" <JohnCleveland@.discussions.microsoft.com> wrote in message
news:EA34E0D4-7E12-4730-96F5-B783261CADF4@.microsoft.com...
>I am trying to use a stored procedure that can accept blank parameters to
> return a complete set of data. when I use the preview screen in reporting
> services, the sproc does not return anything, yet when i run the sproc
> from
> anywhere else, it works. Is there a setting I am missing to be able pass
> balnk values to a sproc from the report?
> Yes, if i pass values to the report, not blanks, the sproc does run and
> returns data.
> --
> John Cleveland
> Network Manager
> Urban systems Ltd
>|||When you click on preview, is it giving a small entry screen ? if yes dont
enter anything like double quotes etc.. before that is it giving a screen?
Amarnath
"John Cleveland" wrote:
> I am trying to use a stored procedure that can accept blank parameters to
> return a complete set of data. when I use the preview screen in reporting
> services, the sproc does not return anything, yet when i run the sproc from
> anywhere else, it works. Is there a setting I am missing to be able pass
> balnk values to a sproc from the report?
> Yes, if i pass values to the report, not blanks, the sproc does run and
> returns data.
> --
> John Cleveland
> Network Manager
> Urban systems Ltd
>|||I ran a trace in profiler and here is what I got:
exec spCostReport @.Project=N'', @.Phase=N''
These are the 2 params i am trying to send. I have default values set in
the sproc that should kick in if the params are blank. I exported the trace
to make sure there was nothing between the '', and there wasn't. Any thing
else to check for?
When I run this from the dataset screen in reporting services, it runs fine
leaving the params blank. it only seems to be when the report is run.
--
John Cleveland
Network Manager
Urban systems Ltd
"Kaisa M. Lindahl Lervik" wrote:
> Try using SQL Profiler to find out what is actually sent to the stored
> procedure. Blank might not be blank. Do you expect a NULL or a '' as a blank
> in the sp? Anyway, SQL Profiler shows what is actually sent, so you can
> modify either Parameter or Stored Procedure accordingly.
> Kaisa M. Lindahl Lervik
> "John Cleveland" <JohnCleveland@.discussions.microsoft.com> wrote in message
> news:EA34E0D4-7E12-4730-96F5-B783261CADF4@.microsoft.com...
> >I am trying to use a stored procedure that can accept blank parameters to
> > return a complete set of data. when I use the preview screen in reporting
> > services, the sproc does not return anything, yet when i run the sproc
> > from
> > anywhere else, it works. Is there a setting I am missing to be able pass
> > balnk values to a sproc from the report?
> >
> > Yes, if i pass values to the report, not blanks, the sproc does run and
> > returns data.
> >
> > --
> > John Cleveland
> > Network Manager
> > Urban systems Ltd
> >
>
>

Blank pages when printing

Hi - I am generating a table with large amounts of data. When I generate the
report, the report looks fine but when I print preview it, every alternating
page is blank with only the header and footer being displayed on every page.
I have tried playing around with the page breaks with no luck. Is there a
way, maybe programmaticaly to set page breaks and stop my report from having
blank page between data page? Or what might be causing the alternate blank
pages with header/footer?
thanksHello ISGADMIN,
I had a real time myself at first with plank pages as I am sure a lot of
designers did, but all you need to do is make sure the design grid, margin
settings and data regions fall within boundaries when designing. If you have
a one inch margins on the R and L in Landscape settings (11 X 8.5 in the
Report Properties) for example, the design area and all objects on it need
to fall under 10 inches on the ruler. You may have to tweak with the
measurement for the actual grid to get it just right, but it will work.
--
Rodney Landrum - Author, "Pro SQL Server Reporting Services" (Apress)
http://www.apress.com
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:C1D58BC4-D257-4052-AAB6-10BE7BEE21E2@.microsoft.com...
> Hi - I am generating a table with large amounts of data. When I generate
> the
> report, the report looks fine but when I print preview it, every
> alternating
> page is blank with only the header and footer being displayed on every
> page.
> I have tried playing around with the page breaks with no luck. Is there a
> way, maybe programmaticaly to set page breaks and stop my report from
> having
> blank page between data page? Or what might be causing the alternate
> blank
> pages with header/footer?
> thanks|||Have you considered re-creating the report? Or copy & paste the RDL File,
and start deleting objects from it. Perhaps one of the objects is taking a
full new page.
"ItSGADMIN" wrote:
> Hi - I am generating a table with large amounts of data. When I generate the
> report, the report looks fine but when I print preview it, every alternating
> page is blank with only the header and footer being displayed on every page.
> I have tried playing around with the page breaks with no luck. Is there a
> way, maybe programmaticaly to set page breaks and stop my report from having
> blank page between data page? Or what might be causing the alternate blank
> pages with header/footer?
> thanks|||Hi isgadmin,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in print preview for sub reports

Hi,

I have serveral subreports in main report. I have no problem print the orignal report but when I print them as subreport so get extra blank pages. I try to set the width of sub report in main report the max width value (19.6 cm width) without succeed. Any help would be appreiciate!

Hi,The extra blank page is coming for the Page Layout that you set for your report.Decrease the Left Margin and right margin percentage and try to move your Textbox fields bit closer to each other from right side and remove the extra space left on the right side of your report just draging it towards left.Hope this will solve your problem.|||Hi,In Sql report the preview take extra space for the extra width that you give to your report.So remove the extra width from your report.Do not increase the default width of the report by draging it towards right.Hope this will solve your problem.

Regards
Gelu

Blank page at http://localhost/reports and VS.Net Crashes on Preview

I have two questions. I am trying to work through some very simple reports to get the feel for SSRS. I am running SQL Server 2005 Developer Edition and I have VS.Net 2005 Pro installed on Windows XP SP2. I can walk through the report wizard just fine. But when I go to preview the report I get an exception in VS.Net.

Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module kernel32.dll, version 5.1.2600.2180, stamp 411096b4, debug? 0, fault address 0x0001eb33.

Now I know that this doesn't mean much in terms of sorting out the issue, but I thought that I would include it.

My second question is that I have created a data source and data model. When I try to bring up Report Manager at http://localhost/reports, all I see is a blank page. Nothing is displayed. I can't seem to find anything on the forums about this.

Thanks,

Scott

check reporting services have been installed properly

check Reports and ReportServer folders under default Website folder in ISS

check ReportServerDb and ReportServerTemp Db databases in sqlserver

always install first reporting services and then VS .NET ..