.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Large white space in the right margin of the report

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :Windows Application
 

Hi.

I have a report where I hide or show a set of columns based upon the user selections in the paramters dropdown list. User could select option 1, option 2 or both. Requirement is that if they select option 1 then I need to hide the option 2 related columns. If they select option 2 then I hide the option 1 related columns. The tricky part is that they can also select both options then I need to show both options related columns. Normally I create dynamic column titles and column fields with the IIF statements and show only one set depending upon the selection and adjust the right margin. In this case I need to leave the right margin to the maximum columns width so it could accommodate the selection of both sets of columns.  The issue comes in When they select only one set of columns that leaves some ugly large white space in the right margin which is visible while previewing or printing report. Is there any way to fix this issue? This is SQL server 2005 reporting services.


Thanks for your help.




View Complete Post


More Related Resource Links

Image processing, determine white space and crop

  

Hi,


I have created a image upload for our ID card system to allow users to upload new images, edit them and submit for approval.  This is all working well with a combination of asp.net (c#) and jquery to give a seemless editor etc.

We have had a few users who I cannot believe have scanned a photo of themself and then just submitted it with the A4 page of white and little photo.


I am wondering if anyone can help with a suggestion on how I could possibly reduce the load of these coming through (I can't believe they can be this stupid), it stipulates UK passport standards.


Would my only option be to check for a single continues colour that occurs and if it reaches a certain percentage point say 60% then to just send back an error stating they need to crop the image.

Can anyone help with providing sample or that I can use to move this one on.


I am still in disbelief on this one.  the other one is they take a photo of whole body and other in it and cut straight down middle chopping the people out but supplying a photo that no use for an id photo card....but that I can't imagine being solved programatically as I need to determine where their face dimensions are and what percentage of the actual photo is taken up by it and if it below a threshold reject it.




How to set report margin

  

 Dear all professional,

If exports the report as Excel format, how can I set the page margin in excel as 0.5cm ?

 

Thanks

 


Large Dataset Downloaded Before Rendering Report's First Page

  

Greetings,

I'm hoping to understand the behavior of SSRS a bit better in the following scenario (SSRS 2008).  A single matrix (tablix) exists on the report.  No other objects are on the report.  That matrix is populated with 1.1 million rows of data totaling about 200MB.  Why does SSRS download the entire dataset prior to rendering the report's first page or am I missing something here?

When previewing the report, the local .data file bloats to 200MB indicating all dataset rows are being returned.  The matrix does not contain any sorting, all cell "can grow" and "can shrink" properties are set to false, no expressions are used anywhere, and even the table's column data types from which the data is being pulled are appropriate.  In other words, I believe I've reduced storage and CPU needs while eliminating elements that add overhead when rendering a report.

The specific scenario here is a researcher previewing the first few pages of data then choosing to download the entire dataset.  MS documentation I've read refers to "soft page breaks" when rendering as HTML and left me with the impression that perhaps SSRS needs to know the entire height of the dataset before it'll slice the report into pages.  It's odd to me though that it needs to download 1.1 millions rows of data befor

Not able to export a large SSRS report into Excel

  

Hi,

I have a requirement to export a large SSRS report into Excel. The report has more than 52 columns and around 70000 lines. The requirement is to export the report into a single excel(different sheets also would do ). Can you suggest some help in this regards?

Thanks in advance!


Will SSRS 2008 eliminate white space due to hidden columns?

  

I have many reports that hide/show columns based on either parameters or user input.  When columns are hidden the body size is not recalculated and also cannot be set through expressions.  This leads to at best extra blank pages when reports are printed, at worst reports that cannot be embedded as subreports into other reports because they off-set the elements around them when the area into which they are inserted automatically resizes in rendering.  This should be considered a bug in the current release (2005).

 

Is there any chance of this making it into the new version (either that the renderer recalculates the body width or that expressions could be used in fields such as body width)?

 


BIDS 2008 Crashes when preview a large report

  
Studio 2008 SP1 BIDS crashes whenever it tries to render a large report. It does not matter if the report was created with the wizard or manually. It does not matter if it a stored procedure or just SQL. We have several developers in our shop and we have all experienced the same problem. We have to limit the result set with something like "SELECT TOP 1000 ..." while we are developing and then remove the limit or filter when we deploy. After it is deployed there is no problem with the reporting engine rendering the html. The problem is only in Visual Studio 2008 BIDS. When it tries to render a large report it crashes. I think probably because it not rendering html but attempting to draw a representation of the report in the client area of the window. We would like to see a better solution. Any ideas?

how to prevent the white space occupied by the hidden footer

  

Hi,

I have a report which is of 3 pages. i have a footer which should be visible for the first page only and should not be visible for the remaining pages.

I have used the visibily tab and made it visible only on the first page, but when i am printing the report ithe footer is occupying the white space for the remaining pages also.

What should i do so that the footer does not occupy this white space for the other 2 pages??

Please let me know.


WPF: how to add white space in ?

  

We need to add some white space between two sentences which are located in the same line?

How do we do it? thx!

 we do following, it works, however, we not sure this is a right way to do.

<FlowDocument>
 <Paragraph>
  <Run Text="xxxxx"/>
  <Run Text="  "/>
  <Run Text="yyyyy"/>
 <LineBreak>
 </Paragraph>
</FlowDocument>

Underscore replaces space character in report name when RDL downloaded for edit

  

Hi Folks,

When I download a report rdl for edit from Report Manager, if there is a space character in the name then its replaced by and underscore.

For eg., if my Report name is "Test Report.rdl", when I download the rdl it comes up as "Test_Report.rdl". I have noticed this happening just recently and didn't occur earlier.

How do I get SSRS to stop replacing the space character with "_" ?

Appreciate any assistance on this.

Thanks,

A


remove white space between the html tag

  

hi i m using vs2005 for development

i haev desing a one web page with size ( 15 k)

now i want to remove the white space and make it in one single line .


how i can do that , thax


Unexpected Error when running large stored procedure report in SharePoint

  

I have a report which uses a stored procedure to retreive a resource intensive dataset from a Data Warehouse.  With a small scope it renders in SharePoint no problem, but when a larger scope is specified ShrePoint throws this non-descript error. 

I can execute the procedure in SQL Server Management Studio, and though it takes 2+ minutes with the larger scope (30 sec with smaller) it does return the data.  Similarly, in Business Intelligence Development Studio it returns the rendered report with data after 2-3 minutes.

Only in SharePoint and only with a larger dataset does this occur.  Timeout is set at 30 minutes and it occurs long before then.  SSRS server has over 12 gigs memory, running SQL Server 2008, SharePoint 2007 is in integrated mode. No errors in SharePoint server or SSRS server logs.  Ideas?


ERROR: '"' is an unexpected token. Expecting white space.

  

I have a project (exe) that calls my web services to extract some data and writes a result message in a text file. When I run this from the local machine where I am hosting the web services and the project exe, It runs fine and results are written in a text file as expected. But when I run this exe from another machine in the network, I get the following error:

ERROR: '"' is an unexpected token. Expecting white space. Line 1, position 50.

Stack Trace:
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.DtdParserProxy.System.Xml.IDtdParserAdapter.T
hrow(Exception e)
   at System.Xml.DtdParser.Throw(String res, String arg, Int32 lineNo, Int32 lin
ePos)
   at System.Xml.DtdParser.ParseExternalId(Token idTokenType, Token declType, St
ring& publicId, String& systemId)
   at System.Xml.DtdParser.ParseInDocumentDtd(Boolean saveInternalSubset)
   at System.Xml.DtdParser.Parse(Boolean saveInternalSubset)
   at System.Xml.XmlTextReaderImpl.ParseDoctypeDecl()
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean prese
rveWhitespace)
   at System.Xml.XmlDocument.Load(XmlRe

I want to give white space to the left of a label. Thanks

  

I want to be able to show as below in asp.net using vb

  Warehouse

             Purchasing

                          System

 

I am using labels for the above three words. Is there a way to do it.

Thanks

 


Printing and Print Preview hangs on a large report

  

Using SQL Server 2008 R2 Cumlative Update #4 (build 10.50.1746)

A report that is 119 pages long hangs after page 113 in both the print preview and printing.

A different report that is 90 pages long hangs on page 60 in both the print preview and printing.

These reports worked fine before applying the cumulative update #4.


Unexpected Error when running large stored procedure report in SharePoint

  

I have a report which uses a stored procedure to retreive a resource intensive dataset from a Data Warehouse.  With a small report it renders in SharePoint no problem, but when a larger scope is specified ShrePoint throws this non-descript error. 

I can execute the procedure in SQL Server Management Studio, and though it takes 2+ minutes with the larger scope (30 sec with smaller) it does return the data.  Similarly, in Business Intelligence Development Studio it returns the rendered report with data after 2-3 minutes.

Only in SharePoint and only with a larger dataset does this occur.  Timeout is set at 30 minutes and it occurs long before then.  SSRS server has over 12 gigs memory, running SQL Server 2008, SharePoint 2007 is in integrated mode. No errors in SharePoint server or SSRS server logs.  Ideas?



-Erik

Alternating row background for first column of a report

  

is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

<TableRows>
            <TableRow>
              <TableCells>
                <TableCell>
                  <ReportItems>
                    <Textbox Name="PartNumber">
                      <rd:DefaultName>PartNumber</rd:DefaultName>
 

left right margin

  

Hiii Coders ,

I have created my website. Now what is my requirement is that on higher resolution it should be centralized means margin from both sides should be same.

How can i get it working

plz provide me some code snippet plz

thanx and regards


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend