Boolean Data Type not available (workaround for checkbox.checked storing?)

I have a page for inventory price entry that I have used for a while. Now I need to add a checkbox for whether or not the price includes shipping. I added the checkbox to the form and had it posting 'True' or 'False' to the database as nchar(10) data type. When the gridview pulls up the data, I have the Item Template like this, so it shows a disabled checkbox either checked or not:

<asp:CheckBoxID="CheckBox2"runat="server"Checked='<%# Convert.ToBoolean(Eval("Shipping")) %>'Enabled="False"/>

This works fine for displaying the values, but I copied the checkbox to the Edit Item Template, but did not disabled this one. At first, I didn't change the databindings, leaving it Convert.ToBoolean(Eval("Shipping")), which allowed me to go into Edit mode, change the checkbox, then click update. At which point it would return to it's original state (meaning Update wasn't actually updating). However if I change the databindings, then the page won't display.

I checked the SQL statement, and sure enough, it has the

UpdateCommand="UPDATE [PartsTable] ... SET [Shipping] = @.Shipping... WHERE [PartID] = @.original_PartID

After fiddling with the sql statement, now I get Object cannot be cast from DBNull to other types. I think that means that the checkbox is sending a null value to the database.

Any insight as to how to get this to work is much appreciated. Thanks in advance.

I don't know if this will work declaratively but your problem is ANSI SQL Boolean is three valued True/False/Null the reason ANSI SQL is called three valued logic. The links below will show how to use Nullable types of FCL(framework class library) 2.0 to solve your problem. Hope this helps.

http://www.codeproject.com/csharp/c__20_nullable_types.asp

http://www.c-sharpcorner.com/UploadFile/PashuSX/NullableTypes04282006114548AM/NullableTypes.aspx?ArticleID=b28a5114-a92a-4ced-a23c-06d8a29de6e4

|||

I found this thread:http://forums.asp.net/thread/1092916.aspx and after reading it, I've changed the data type in the database to Bit. This has significantly helped my problem .

BUT I have the checkbox in normal mode displaying perfectly fine. However, when I click edit, there is a textbox that displays either True or False (True is 1 and False is 0 in the database). If I change True to 0 or False to 1, it works. HOWEVER I want it to display a textbox. When I delete the textbox in the edit template, replace it with a checkbox and then set the databinding to the shipping field, I can click edit and the box appears just fine, but when I change it and click update, I get this Error:Syntax error converting the nvarchar value 'False' to a column of data type bit.Which to me means that it is trying to post the checkbox.checked ='s value, not just checkbox.checked which is stored as a bit in the database.

How/Where can I change this?

|||Figured it out! Turns out the auto generated update statement set the paramenter to

<asp:ParameterName="Shipping"Type="String"/>

So I took out the Type="String" and it fixed my problem.

Thanks.

|||I am glad to see your problem is resolved.

Bookmark in Code not working.

I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement:

"An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code

Additional information: Some parameters or credentials have not been specified"

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim strReport1 As String = "/ReportDirectory/CurrentWeekSales"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri(CStr(Session.Item("ReportServer")))
ReportViewer1.ServerReport.ReportPath = strReport1
ReportViewer1.ServerReport.Timeout = 500000

Do While ReportViewer1.ServerReport.IsDrillthroughReport
ReportViewer1.PerformBack()
Loop

Dim RptParameters1 As ReportParameter() = New ReportParameter(0) {}
RptParameters1(0) = New ReportParameter("EBO_EmpKey", CStr(Session.Item("UserKey")))
ReportViewer1.ServerReport.SetParameters(RptParameters1)

ReportViewer1.ServerReport.Refresh()

ReportViewer1.JumpToBookmark("6")

End If
End Sub

What am I missing?

ThanksI too am having a similar problem. I find that JumpToBookmark() simply does not work no matter what I try. Interestingly, setting the 'action' property of a TextBox within the report to jump to the target bookmark seems to work. Unfortunately, I need to be able to do this in code without having to force the user to click on the report.

Is this a known problem, or is there something else on the viewer and/or report that needs to be set?

Thanks,

Ian.

BODY not getting assigned BackgroundColor and BODY does not have CanShrink property: REPOS

I have simplified the problem I am having down by creating an empty report
with and Page Header, Body and PageFooter. I have set the BackgroundColor
of all three to "White".
I am using VS.NET to design the Report and ASP.NET with C# to call the
Reporting Services web service Render method using HTML4.0 format to render
the report inline on my web page with a blue background.
The css (a1_s) for the Body does not a Background color as seen below in the
Supporting Examples:
The bigger problem is that I have a Table in the Body. Both do not have a
CanGrow or CanShrink property, at least exposed in VS.NET. The Table is the
only thing in the Body. The Table has a Header, Group, Detail and Footer.
If the report returns no detail, I see the Table Header and the Table
Footer. It knew to collapse/shrink the Group and Detail sections but did
not shrink the Table and/or the Body. Under the Table Footer and before the
Page Footer is a gap which is the transparent area.
The Lame workarounds I have found so far are:
- reduce the Height of the Body and the Table to the smallest allowed by the
VS.NET, but during design you have to increase it and not forget to decrease
it when you are done
- put the Table in a rectangle with a "White" BackgroundColor but there is
still a big gap between the Table Footer and Page Footer
Supporting Examples:
The RDL is:
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<PageHeader>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageHeader>
<RightMargin>1in</RightMargin>
<Body>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>89d2899d-7bc6-4d9d-b3f5-1bee26df10a3</rd:ReportID>
<PageFooter>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Height>0.25in</Height>
</PageFooter>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
The CSS snippet is:
.a1_s{HEIGHT:50.80mm;overflow:hidden;WIDTH:165.10mm}
.a3{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
.a5{border:1pt None
Black;background-color:White;background-repeat:Repeat;padding-left:0pt;paddi
ng-top:0pt;padding-right:0pt;padding-bottom:0pt;HEIGHT:6.35mm;overflow:hidde
n;WIDTH:100%}
The generated HTML for the report is
<div id="oReportDiv" onresize="javascript:OnResizeDiv()" style="OVERFLOW:
auto; WIDTH: 100%; HEIGHT: 100%">
<table cellpadding="0" cellspacing="0">
<tr>
<td id="oReportCell" style="PADDING: 10px">
<DIV class="a3"> </DIV>
<DIV class="a1_s"> </DIV>
<DIV class="a5"> </DIV>
<script language="javascript" type="text/javascript">
<!--
var docMapIds = [];
//-->
</script>
</td><td style="WIDTH: 100%; HEIGHT: 0px"></td>
</tr><tr>
<td style="WIDTH: 0px; HEIGHT: 100%"></td>
</tr>
</table>
</div>Hi Douglas,
I am looking into this issue, I will keep you updated as soon as I find
there is anything useful to add :)
Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.|||Hi Douglas,
From your descriptions, I understood that you are not able to generate
html as you expected when using Render method called from web service. If I
have misunderstood your concern, please feel free to point it out.
BODY do not has CanShrink property, but I am not sure why you are not able
to assign BackgoundColor property? Is it possible for you to assign the
BackgoundColor in the Report Designer?
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.|||Hi Michael,
I am able to assign BackgroundColor in the Report Designer as confirmed by
the RDL I supplied in my first post.
The class generated for the Body ("a1_s") does not have a background-color
where as the Header ("a3") and Footer("a5") do have it. This can also be
seen by the Style Sheet and HTML provided in my first post.
Why doesn't a background-color get generated for the Body?
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:CzW6x8ENFHA.2900@.TK2MSFTNGXA03.phx.gbl...
> Hi Douglas,
> From your descriptions, I understood that you are not able to generate
> html as you expected when using Render method called from web service. If
I
> have misunderstood your concern, please feel free to point it out.
> BODY do not has CanShrink property, but I am not sure why you are not able
> to assign BackgoundColor property? Is it possible for you to assign the
> BackgoundColor in the Report Designer?
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner 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.
>|||Hi Doug,
You may also manually write the code to change the background of HTML code
after calling Web service render method as workaround for your scenario.
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.|||Hi Michael,
So, is this a known issue?
If so, might it be corrected in SP2?
With the workaround you suggested, since I have one container for all
reports, a User Control, I would have to query the report to see what color
to change it to.
The only way I have found to query the report is to call the
GetReportDefinition Method of the ReportingService Class and then parse the
.rdl.
Is there an easier way?
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:nacubipNFHA.2720@.TK2MSFTNGXA03.phx.gbl...
> Hi Doug,
> You may also manually write the code to change the background of HTML code
> after calling Web service render method as workaround for your scenario.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner 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.
>|||Hi Douglas,
Thanks for your kindly patience:)
Yes, I am sorry to say that this is currently by design feature of
Reporting Services now.
If the body of the report does not have a border, the background color is
taken to be the background color for the entire page, not just the body. As
a result, it is placed on the <BODY> element rather than in the CSS for the
<DIV> corresponding to the body of the report.
I don't think SP2 will fix this.
Thanks again for your patience and corporation. If you have any questions
or concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.|||Hi Michael,
I tested your findings and setting the BODY border color to white and solid
is the best workaround so far and much more manageable.
Thanks,
Doug
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:9sYecjlOFHA.3136@.TK2MSFTNGXA01.phx.gbl...
> Hi Douglas,
> Thanks for your kindly patience:)
> Yes, I am sorry to say that this is currently by design feature of
> Reporting Services now.
> If the body of the report does not have a border, the background color is
> taken to be the background color for the entire page, not just the body.
As
> a result, it is placed on the <BODY> element rather than in the CSS for
the
> <DIV> corresponding to the body of the report.
> I don't think SP2 will fix this.
> Thanks again for your patience and corporation. If you have any questions
> or concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner 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.
>|||Hi Doug,
Thanks for your understanding:) If you have any questions or concerns next
time, don't hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.

Blocking Threshold Exceeded

I have a site that calls a stored procedure to populate data on an ASP page.
50% of the time when I access this page I get a timeout error. I looked in
the Event Viewer and noticed MSSQLSERVER errors with this description:
Error: 50001, Severity: 16, State: 1
Blocking Threshold Exceeded, Threshold at 3. Total Blockers at 44
The total blockers number changes occasionaly but I don't know what this
means and how to fix it. I am not doing anything complex with the stored
procedure. It is a select statement which joins multiple tables. No
inserts, updates, or deletes are being done.
Does anyone have an idea how to correct this?
Thanks.Even though the procedure that performs the query is not
inserting/updating/deleting, is this still being done by any process? When
it actually completes, what is the average and maximum runtime of the query?
Also, the following article describes various methods for identifying what
processes are blocked, what process is doing the blocking, and what specific
T-SQL statement is blocking.
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
http://support.microsoft.com/defaul...kb;EN-US;224453
If this is a reporting type query against data potentially with uncommitted
transactions, then you may want to consider using "set transaction isolation
level read uncommitted", so long as you understand how this can impact the
results. Read up on this in Books Online.
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:A1346683-78D7-40CE-9F7F-3AE8521D392F@.microsoft.com...
>I have a site that calls a stored procedure to populate data on an ASP
>page.
> 50% of the time when I access this page I get a timeout error. I looked
> in
> the Event Viewer and noticed MSSQLSERVER errors with this description:
> Error: 50001, Severity: 16, State: 1
> Blocking Threshold Exceeded, Threshold at 3. Total Blockers at 44
> The total blockers number changes occasionaly but I don't know what this
> means and how to fix it. I am not doing anything complex with the stored
> procedure. It is a select statement which joins multiple tables. No
> inserts, updates, or deletes are being done.
> Does anyone have an idea how to correct this?
> Thanks.
>

BLOBs and Stored Procedures

I have been told that using BLOBS and Stored Procedures is a bad thing.
Running the SQL in the page is the only correct way. We are using SQL Serve
r
2000 - soon to go to 2005. Could someone direct me to documentation that
addresses this situation?
--
Tonywho told you this?
BLOBS I can see why people would advise you to avoid them, they aren't
bad things, they just have the capability to be used badly.
Stored procedures are very good things, by "running the SQL in the page
is the only correct way" do you mean passing SQL as a string to your
sqlCommand objects? is this just for when you are using BLOBS or all
SQL you run?|||some of the key benefits of stored procedures are mentioned in this
article:
http://msdn.microsoft.com/library/d...>
_07_31vb.asp|||Will,
Thanks for getting back to me. I have used Stored Procedures for years.
No, my questions is specific to BLOBS and stored procedures. (I have heard
all the negatives about BLOBS - pdfs in databases, but I have a client ...)
My DBAs tell me that 'adding' a layer to the data process - for BLOBs only-
is too high a price to pay (resources) for me to use them.
I can't find definitive proof one way or the other. I would really like to
continue to use my data layer and not use in-page SQL (ADO .Net to SQL Serve
r
with no SP). I can't argue to vehemently because I don't know if a query
plan is even generated for the BLOB handling SP.
With over twelve years of experience with SQL Server, I have never seen a
situation where performance was better without a stored procedure. But SQL
has to handle BLOBs differently, so I was hoping to find something to suppor
t
either side of the argument that I could take to my DBAs.
Thanks for your time.
--
Tony
"Will" wrote:

> some of the key benefits of stored procedures are mentioned in this
> article:
> http://msdn.microsoft.com/library/d...
es_07_31vb.asp
>

Blank window Problem

Hi everyone...
I ve a problem that is-
Scenario:
I open report using url access from html page. Parameters are passed in from
html page as hidden fields. Url of report is in Action attribute of form in
the page. So, when i submit it it opens BLANK WINDOW and the opens prompt
window for saving or opening option.
Problem:
I dont want this blank window.
Please help! I am looking replies from MS guys as i couldnt find it anywhere!
--
Suneet Mohan
Microsoft Certified ProfessionalOn Sat, 2 Apr 2005 10:51:02 -0800, Suneet <suneetmohan@.gmail.com>
wrote:
>Hi everyone...
>I ve a problem that is-
>Scenario:
>I open report using url access from html page. Parameters are passed in from
>html page as hidden fields. Url of report is in Action attribute of form in
>the page. So, when i submit it it opens BLANK WINDOW and the opens prompt
>window for saving or opening option.
>Problem:
>I dont want this blank window.
>Please help! I am looking replies from MS guys as i couldnt find it anywhere!
>--
>Suneet Mohan
>Microsoft Certified Professional
It would be helpful to see the URL that is created and which seems to
fail.
Andrew Watt
MVP - InfoPath

Blank space between Details section and Page Footer section.

hey folks,
this is probably a newbe question, but please bear with me. so here is the deal i have this report and i have one grouping in it and then i've suppressed the Report Footer and have some stuff in the Page Footer. Here is a picture to illustrate this (i'll continue the question in my next post):So the problem is that when i Preview the report, it gives me blank space between my Details section and the Page Footer. Here is a picture of the problem. Can anyone explain this to me?

Thanks.|||Suppress GroupFooter1 if there's nothing in it.|||it's already suppressed.
Also, none of my sections has the Keep Together, No Page After, or Print At Bottom Of Page options checked.

Both Group Header #1 and Report Footer are hidden and suppressed.

And I still get the blank space.|||Hi,

May be a silly answer. But your report is displaying normal. Your report data is finished within the page (for ex half of the page). Your picture is displaying at the Page Footer. So the remaining space remains as blank.

Actually what do you want to do?|||O, so what you are saying is that the PageFooter always displays at the bottom of the page no matter what?

I knew it was a newbie question.

What i wanted was for the stuff in the Page Footer to display directly below the last record in the Details section, but i guess a Page Footer won't work for that.|||Yes, Hope you got it.

In your case, you can display the object (or anything) in the Report Footer area so that it will display right after the report. But it will display only at the end of the page not in all pages.

To display in all pages, you can use page footer and use some formula to restrict the display it is last page.
Ex.

Right Click your picture : Select Format Graphic option. Check Suppress and then click X-2 button. Select PageNumber and TotalPagecount from the PrintState functions list/enter the following

PageNumber = TotalPageCount

Click Ok.

Note. Place the picture in Page Footer as well as in Report Footer so that you can get the picture in all the pages except the last page and at the end of the report|||harmonycitra,
now you are confusing me. Maybe I am missunderstanding you about the Page Footer; in your first post you said that in case the report data is finished withing the page (for ex half the page) than having blank space between the Details and Page Footer sections is normal. Now, in your last post, you said that if i wanted to print something on each page right after the Details section, i can use the Page Footer. Please understand that by "right after the Details section" I mean no blank space between the Details section and the section that comes right below it, hence I can not use the Page Footer for that purpose since if I do a blank space would show up on the report if the data in Details has finished within the half of the page. Do you see the contradiction here or I am just not understanding what exactly is it that you were saying earlier?|||Sorry for the confusion.

Normally Page Footer will display at the bottom of each and every page. If a report contains 3 pages, the first two pages will be filled fully. The third page i,e the last page may not having the data to fill the entire page. In that case there will be a blank space appear between the Details and the Page Footer.
This is not because of page footer but because of detail section is finished half of the third page.

But the Report Footer will display at the end of the report. (always in the last page)

In your example which you had posted, try to put the totals in the report footer and finish the boxes, lines in Report Footer. It'll work fine.

Hope you understand. Otherwise I'll send some sample|||yes, i understand. i'd actually already put the summary lines, etc. in the Report Footer and it works fine, i just wanted to clear this up for myself. you learn something new every day i guess.

thanks for your help.

Blank rows on report

Hello,
My report seems to be generrating a randon number of rows per page. Some
pages have only one row, others three and some blank. this does not appear
to correspond to group breaks. Has anyone else seen this? Is there a way to
make the report rows follow immediately one after another?
Thanks.HI jo st charles,
i encountered the same problem because of the improper groupings onli.
u can check the same.
check out the detail cell u can find some more.if u can give out some more
info
i will help u out.
cheers
drupa

blank pages inserted on exported pdf and tif format

Hi,
After I export the report to PDF or TIF format, the pages became double. It
inserts a blank sheet on every page of the report. Does anyone know how to
fix this issue? Any help is appreciate it.
Thanks,
LianneLianne,
I had that problem too. Some of your report items are wider than the page.
Look on the ruler above your report page and make sure that you do not have
any report items that go to the right more than the width of your page
(usually it's 8.5 inches).
Good luck.
"Lianne Kwock" wrote:
> Hi,
> After I export the report to PDF or TIF format, the pages became double. It
> inserts a blank sheet on every page of the report. Does anyone know how to
> fix this issue? Any help is appreciate it.
>
> Thanks,
> Lianne|||Not greater than the width of the page when considering your margins plus
the ruler.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Simon Gold" <SimonGold@.discussions.microsoft.com> wrote in message
news:862C6173-C1F9-40B2-8C4E-1B1333BEA0ED@.microsoft.com...
> Lianne,
> I had that problem too. Some of your report items are wider than the page.
> Look on the ruler above your report page and make sure that you do not
> have
> any report items that go to the right more than the width of your page
> (usually it's 8.5 inches).
> Good luck.
> "Lianne Kwock" wrote:
>> Hi,
>> After I export the report to PDF or TIF format, the pages became double.
>> It
>> inserts a blank sheet on every page of the report. Does anyone know how
>> to
>> fix this issue? Any help is appreciate it.
>>
>> Thanks,
>> Lianne|||You will also need to make sure that your report respect the following:
Body:Width > (Report:PageWidth - Report:LeftMargin -
Report:RightMargin).
A similar restriction exists for Body:Height and Report:PageHeight.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lianne Kwock" <LianneKwock@.discussions.microsoft.com> wrote in message
news:509E186D-CBBD-4725-B46C-47F175AEAA6F@.microsoft.com...
> Hi,
> After I export the report to PDF or TIF format, the pages became double.
> It
> inserts a blank sheet on every page of the report. Does anyone know how
> to
> fix this issue? Any help is appreciate it.
>
> Thanks,
> Lianne

Blank pages in Print Layout version of report

Hi All

I have a report that looks and works fine in the native 'screen layout' but when I select the Print Layout option, a blank page is inserted after each page. These blank pages contain the header and footer, but not the body section of the report. Has anyone else seen this sort of thing? Is there something in my report layout causing this, or is it a bug in the Print Layout rendering?

Thanks much

On your report layout, is the white background width, plus the size of your right and left margins (in Report, Properties) greater than your page width in report, properties?

This will cause page breaks.

BobP

|||

I have the same or similiar question.

When I preview my report in Report Services I have no blank pages. When I print preview it there is one or two pages that are blank. Well they are half blank or partial blank.

My report has a header and body. I have the labels of the body in the header because I can't get the repeatwith Property to work(That's being addressed in another thread.). In the Body I have a list box and sub list box. I have it grouped by a field contained in the list box. Some the pages end where the grouping ends, but not all. It's strange. If I edit the size of the list box or somehow or decrease the size of the report the blank pages changes. Such as now it's half blank on page 4 and 3/4 blank on page 30. out of 50. I change the list box a little and it changes my blank pages to be on 15 and 22.

Anyone got a sufggestion for this?

Card Gunner

Blank Pages generated after the subreport

Hi,

I am very new to SSRS. I developed a report which has two subreports in it. Blank page is generated at the end of each Page. Can any one help me how to avoid this.

try to reduce the spacing between the sub report components on the main page - It needs some trail and error

Blank Pages

When I print my report in SSRS it says there are 5 pages, when I print my
report to the printer, 22 pages comes out, every other page is blank. It
does the same when I print it to PDF.
I went to Report Properties>>Layout and have my settings as 10in Width, 8in
Height and margins are set to zero.
What is wrong here?
Thanks,
RyanOn Jun 14, 2:24 pm, Ryan Mcbee <RyanMc...@.discussions.microsoft.com>
wrote:
> When I print my report in SSRS it says there are 5 pages, when I print my
> report to the printer, 22 pages comes out, every other page is blank. It
> does the same when I print it to PDF.
> I went to Report Properties>>Layout and have my settings as 10in Width, 8in
> Height and margins are set to zero.
> What is wrong here?
> Thanks,
> Ryan
You want to make sure that you are not page breaking after groups,
etc. Also, I find that when exporting to PDF, a lot of times the extra
pages can be avoided by putting multiple table/matrix controls inside
a single rectangle control (where applicable). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

blank pages

When I print my report, every other page is blank. I have resized everything
down to half the page, played with margins and object sizes to see if I just
had an oversized item, but to no avail. Is there a setting or somthing that
does this?
I am at my wits end!
thanks!Check the width of your report's Body - right-click on the body bar and
select properties - Size>width. This should be less than or equal to
Page width - (Left margin + Right margin) <- all in Report Properties
Layout tab
HTH,
Magendo_man
"Carl Henthorn" wrote:
> When I print my report, every other page is blank. I have resized everything
> down to half the page, played with margins and object sizes to see if I just
> had an oversized item, but to no avail. Is there a setting or somthing that
> does this?
> I am at my wits end!
> thanks!

Blank page?

In my report I have 4 lists. In the each list I have textbox (Company Name)
And matrix. Each list shows in separate page. So basically if I view report
I have 4 pages.
The problem is.
For example, If in my report parameter, which is â'Group Nameâ'
(A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
still 4 pages and 2 pages is blank. How can I remove that blank pages?
I used matrix in the list to able to view each matrix in separate pages.
Thank you.On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> In my report I have 4 lists. In the each list I have textbox (Company Name)
> And matrix. Each list shows in separate page. So basically if I view report
> I have 4 pages.
> The problem is.
> For example, If in my report parameter, which is 'Group Name'
> (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> still 4 pages and 2 pages is blank. How can I remove that blank pages?
> I used matrix in the list to able to view each matrix in separate pages.
> Thank you.
I don't work with lists often but if I were trying to do here is where
I'd start.
Try conditioning the visibility properties of your lists.
Insert an expression into the Visibility>Hidden property of the
individual lists. For the Group Name A list, try something like:
=IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
You may need to fiddle with the syntax some but what you're trying to
get at is
"If A is found in the Group Name param
then show the List
otherwise hide the List"
If needed, the namespace is Microsoft.VisualBasic.
If lists work like tables and other report items, the non-hidden ones
should move up and fill the white space left by the hidden ones.
HTH
toolman|||I do not have problem to hide my lists. If i unselect 2 groups it will hide
the lists but leaves the 2 blank pages. I need to remove these blank pages.
"toolman" wrote:
> On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > And matrix. Each list shows in separate page. So basically if I view report
> > I have 4 pages.
> > The problem is.
> > For example, If in my report parameter, which is 'Group Name'
> > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > I used matrix in the list to able to view each matrix in separate pages.
> >
> > Thank you.
> I don't work with lists often but if I were trying to do here is where
> I'd start.
> Try conditioning the visibility properties of your lists.
> Insert an expression into the Visibility>Hidden property of the
> individual lists. For the Group Name A list, try something like:
> =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> You may need to fiddle with the syntax some but what you're trying to
> get at is
> "If A is found in the Group Name param
> then show the List
> otherwise hide the List"
> If needed, the namespace is Microsoft.VisualBasic.
> If lists work like tables and other report items, the non-hidden ones
> should move up and fill the white space left by the hidden ones.
> HTH
> toolman
>|||Try to adjust the canvas size in layout to match the report width and height
in Report Properties.
Thanks,
"JT" wrote:
> I do not have problem to hide my lists. If i unselect 2 groups it will hide
> the lists but leaves the 2 blank pages. I need to remove these blank pages.
>
> "toolman" wrote:
> > On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > > And matrix. Each list shows in separate page. So basically if I view report
> > > I have 4 pages.
> > > The problem is.
> > > For example, If in my report parameter, which is 'Group Name'
> > > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > > I used matrix in the list to able to view each matrix in separate pages.
> > >
> > > Thank you.
> >
> > I don't work with lists often but if I were trying to do here is where
> > I'd start.
> >
> > Try conditioning the visibility properties of your lists.
> >
> > Insert an expression into the Visibility>Hidden property of the
> > individual lists. For the Group Name A list, try something like:
> > =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> > You may need to fiddle with the syntax some but what you're trying to
> > get at is
> > "If A is found in the Group Name param
> > then show the List
> > otherwise hide the List"
> > If needed, the namespace is Microsoft.VisualBasic.
> >
> > If lists work like tables and other report items, the non-hidden ones
> > should move up and fill the white space left by the hidden ones.
> >
> > HTH
> > toolman
> >|||Each list shows in separate pages but if is one list unselected (For exmp:
group A - from report parameter) then it should not show the 1 page. Instead
of that I do have the blank page. How to remove the blank page?
"naren" wrote:
> Try to adjust the canvas size in layout to match the report width and height
> in Report Properties.
> Thanks,
> "JT" wrote:
> > I do not have problem to hide my lists. If i unselect 2 groups it will hide
> > the lists but leaves the 2 blank pages. I need to remove these blank pages.
> >
> >
> > "toolman" wrote:
> >
> > > On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > > > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > > > And matrix. Each list shows in separate page. So basically if I view report
> > > > I have 4 pages.
> > > > The problem is.
> > > > For example, If in my report parameter, which is 'Group Name'
> > > > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > > > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > > > I used matrix in the list to able to view each matrix in separate pages.
> > > >
> > > > Thank you.
> > >
> > > I don't work with lists often but if I were trying to do here is where
> > > I'd start.
> > >
> > > Try conditioning the visibility properties of your lists.
> > >
> > > Insert an expression into the Visibility>Hidden property of the
> > > individual lists. For the Group Name A list, try something like:
> > > =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> > > You may need to fiddle with the syntax some but what you're trying to
> > > get at is
> > > "If A is found in the Group Name param
> > > then show the List
> > > otherwise hide the List"
> > > If needed, the namespace is Microsoft.VisualBasic.
> > >
> > > If lists work like tables and other report items, the non-hidden ones
> > > should move up and fill the white space left by the hidden ones.
> > >
> > > HTH
> > > toolman
> > >

Blank Page...

I cannot figure out why I have a blank page in front of my report. I have
hunted and hunted to see what I have set that would be causing this. The
blank page is generated when I print to paper, Adobe or Excel but not in the
preview.
Any suggestions?
Thanks!On Apr 18, 10:16 am, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> I cannot figure out why I have a blank page in front of my report. I have
> hunted and hunted to see what I have set that would be causing this. The
> blank page is generated when I print to paper, Adobe or Excel but not in the
> preview.
> Any suggestions?
> Thanks!
Firstly, you will want to make sure that all of your controls'
properties (where possible) are set to 'Fit table on one page if
possible.' Make sure that none of the controls' properties have a page
break after groups, etc. If this does not resolve the issue, try to
put the table controls, etc inside a rectangle. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you - the second suggestion did the trick!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176911441.964042.82780@.b58g2000hsg.googlegroups.com...
> On Apr 18, 10:16 am, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
>> I cannot figure out why I have a blank page in front of my report. I have
>> hunted and hunted to see what I have set that would be causing this. The
>> blank page is generated when I print to paper, Adobe or Excel but not in
>> the
>> preview.
>> Any suggestions?
>> Thanks!
> Firstly, you will want to make sure that all of your controls'
> properties (where possible) are set to 'Fit table on one page if
> possible.' Make sure that none of the controls' properties have a page
> break after groups, etc. If this does not resolve the issue, try to
> put the table controls, etc inside a rectangle. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 18, 1:57 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> Thank you - the second suggestion did the trick!
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176911441.964042.82780@.b58g2000hsg.googlegroups.com...
> > On Apr 18, 10:16 am, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> >> I cannot figure out why I have a blank page in front of my report. I have
> >> hunted and hunted to see what I have set that would be causing this. The
> >> blank page is generated when I print to paper, Adobe or Excel but not in
> >> the
> >> preview.
> >> Any suggestions?
> >> Thanks!
> > Firstly, you will want to make sure that all of your controls'
> > properties (where possible) are set to 'Fit table on one page if
> > possible.' Make sure that none of the controls' properties have a page
> > break after groups, etc. If this does not resolve the issue, try to
> > put the table controls, etc inside a rectangle. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Blank Page while exporting output to pdf

Hi,
I am exporting the output of Reporting Services to a pdf file. There is
always a blank page after every page. How can I remove it. Please help me
to resolve this.
Thanks.
AnujHi,
Check the properties of the objects on the report. In the layout section you
will find PageBreakAtEnd and PageBreakAtStart properties, make sure these are
set correctly or you may end up with blank pages where you don't want them.
Although this is unlikely to be the problem if the report displays fine in
HTML or other formats.
Hope it helps.
Ben Lee
"Anuj" wrote:
> Hi,
> I am exporting the output of Reporting Services to a pdf file. There is
> always a blank page after every page. How can I remove it. Please help me
> to resolve this.
> Thanks.
> Anuj|||I reckon that you're using too much space (across) on your report when
building it in the designer.
Say your report is regular portrait with width of 21cm and height of 29.7,
and 2.5cm left and right margin (you'll find these settings in the menu
option Report -> Report Properties -> Layout), check that the width of the
report area you're working with in your designer is not greater than the Page
Width - (Left Margin + Right Margin). If it is then you'll get those blank
pages.
"Anuj" wrote:
> Hi,
> I am exporting the output of Reporting Services to a pdf file. There is
> always a blank page after every page. How can I remove it. Please help me
> to resolve this.
> Thanks.
> Anuj

Blank page when using subreport

I have a subreport on a SRS report. When I run the subreport by itself,
there is no problem. But when I run the main report it always generates a
blank page as page one.
Any help pinpointing the problem would be greatly appreciated!
Thanks,
BobOn Sep 11, 9:28 am, "Bob Bridges"<m...@.here.com> wrote:
> I have a subreport on a SRS report. When I run the subreport by itself,
> there is no problem. But when I run the main report it always generates a
> blank page as page one.
> Any help pinpointing the problem would be greatly appreciated!
> Thanks,
> Bob
Make sure that you are not setting a page break for grouping. The best
way to condense down this space is to include this subreport inside a
rectangle control. Of course, there's always including the subreport
as a table/etc in the main report, which sometimes due to complexity
of layout requirements, is necessary. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Blank page when exported to PDF

Hi all,

I have this report which has one table and 2 matixes one below the other. The 2 matrixes are very big matrixes (i mean they are wide enough to spill over to the next page). I have "PageBreakatStart" true for the 2 matixes.

Here is my problem. when i export this report to PDF, i get a blank page after the table. If i get rid of "PageBreakatStart", there is no blank page but matrix1 start right after the table which i don't want. can somebody tell me how to eliminate that blank page? Hope my explanation makes sense.

Hey rsri... what did you do to get around this problem?|||I am still looking for the answer. I did not get around this problem yet.

Blank Page On Crystal Report 10

Hi Im' using Crystal Report 10 and the modules created works well when running on Windows XP, but when I try to run the modules under Windows 2003 or Windows 2000 then only a blank page is being displayed (without any error being returned).

Any idea? Please help!

Btw, Im' using Crstal Report Advanced Developer on all machines.Hello,

Can you please tell me if you got any answer for your problem as i'm getting the same issue too... Thanks in advance

bracoute
email addr: bracoute@.hotmail.com|||Yes me to but im using cystal report 8. In my development PC there are no problems but when i installed it at another PC to test it happens. the report have no error message but it jus blank??

please help anybody

Blank page in report manager

When i load report manager everything appears to be running fine. The header, footer and nav bar at the top load correctly. Even the directory and file tree load fine.

The problem is when you click on a report everything from below the nav bar ( where the report would be rendered) blanks out and load bar at the bottom just tacks at full.

One way to fix this problem is to open the web config file for report manager save it then close the file.

This is not a viable solution to the problem. I was wondering if any one else had the same problem . If so how to fix it ?

Has anyone had a similar problem with reporting services. Also is there a place to formally site this as a bug

|||

We are having a very similar problem that is driving me nuts. My end users will get this situation - Report Manager banner and links at top, and blank below the color line. They all have the appropriate permissions. At first, we thought it was caused by an Internet Explorer patch, an uninstalling that patch seemed to work... for a little while. Now, they are complaining again. I get the same patches, and I still have full access (of course, I do have sys admin and sql admin rights). I have a suspicion that it is not an IE patch, but an IE security setting or security policy that may be causing it. When I looked at the Report Manager homepage in FrontPage (just to see what I could see), I noticed that banner is rendered in HTML, and it sets the language for the rest of the page to Javascript. If the Internet Explorer security doesn't allow Javascript, or even prompts for permissions, that may be preventing the display of the rest of the page, and would explain why the banner displays and doesn't just throw an error message to the end user. I am investigating this more. Let me know if you have any thoughts.

Tee Dubs