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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to remove blank spaces between the subreports

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
How to remove blank spaces between the subreports if subreports don't have data to show up?
for example if in my reports there are 7 subreports. if subreports 2 and 4 don't have any data then there is blank space between 1 and 3 and 3 and 5.

View Complete Post

More Related Resource Links

How to remove the blank spaces between subreports in sql server reporting service?


In Sql server reporting service the blank spaces or white spaces are coming in between the subreports, when we place the subreports in the main reports.

If any one know how to remove the blank spaces between the subreports, please reply me. Its very urgent.

While Printing an Infopath Form it Prints lot of Blank Spaces Before RichText Field


I had an infopath form with few rich text field. When i copy some content from somewhere and paste in the richtext Box then while Printing the form I get Lot of Blank Spaces Infront of the rich text box.

I tried creating teh print view too but still i get bunch of empty pages printed before by richtext box control.

Is there a way we can remove those blank spaces.....

I am not able to find out what is going wrong here....

Allow blank spaces in textbox

Hi,   I have a simple issue..the user types his/her name in a textbox. Accidentally if a space is entered after a name or before, is it possible for me to trim it while accepting and not raise any error (which actually arises when the textbox is empty)? Actually, not raising an error is the issue!    Thanks!

problem parse xaml and blank spaces


Hi, I have a problem parsing an xaml with characters 
 and space blanks, the space that show me is different that show in Silverlight.

this is the code to parse the xaml

            xml_node = nodo.OuterXml;
            text = (System.Windows.Controls.TextBlock)XamlReader.Parse(xml_node);

            if (text.Height != double.NaN)
              text.Height = double.NaN;

            text.Text = text.Text.Replace(' ', (char)160);

            if (text.Visibility != Visibility.Collapsed)

And this is the code of xaml:

  <TextBlock x:Name="Elemento_300920102232365" Canvas.Left="121.488" Canvas.Top="125.682" Width="1705.799" Height="2169.455" Text="&#xD;&#xD;&#xD;Jamón de Bellota (reserva) / Pernil de Bellota (reserva)                         17'00 €&#xD;Anchoas del Cantábrico / Anchoves del Cantàbric  &

How to remove auto generated right blank column from the wpf datagrid?


i have already use this.


How to remove white spaces - asp.net 4.0


hello everybody. i want to remove all white spaces at both html and javascript files. how can i achive this.


using iis 7.5

asp.net 4.0

asp.net web site project


thank you 

Can someone show me how to remove blank columns from a matrix report with parameters?


I have a drilldown matrix report with 5 parameters that I group on. The users have the option of selecting any of these parameters when they preview the report. They can also select No grouping as one of the parameter option.   When I run the report and select for example, 4 parameters and the No grouping option, I get blank columns.  When I select no grouping, no data is displayed.  As a result, I get blank columns.  Is there a way to hide the blank columns?  I would appreciate any suggestions.  See table example below:



How to remove blank item from infopath form in drop down list



how to remove the blank item from the drop down box which is used in infopath form..




How to remove spaces from varchar column


Hello guyz;

I got a varchar column that I want to remove extra spaces from its contents.

what I want to do is keeping only 1 space between each 2 words ...I don`t want to keep more than one space between each 2 words

Remove Spaces in an SQL Statement


I have a query which is shown below:


Decalre @sql as nvarchar(max)

set @sql = 'Insert into XYZ( [x],



  THe query was wriiten by one of my developers and each column started on anew line.

The problem here is when i tried to use the following statement

EXEC sp_executeSQL @sql1

the execution is failing because the whole @sql is not fitting into nvarchar. As far i know if i use so_executesql the max length allowed is 4000, but my query is longer than tht, hence there is error becuase everything could not fit into into Nvarchar

IS there a way that i can trim the empty spaces while executing.

I have a tedious process where i bring all the columns into one single one. Is there an easy process for this?


Remove #Region from whole web site


Hi All,

I need to deliver source code to client and my boss need to remove all the comments and #region sections from the whole web site source code.

So is there any functionality available in visual studio 2010 or may be in an other 3rd party tool available to do so, which can remove all the #region from all over the source code ?

Otherwise my developers has to do donkey work.... :(( and I don't wish it. 

Any help or tips/tricks would be appreciated.


Web deployment project - web.config section replacement does not add remove tag


I have a web application that is actually installed as a component of a third party site.  In some configurations, I need to remove certain connection strings and re-add them.  I'm replacing this web.config section with a xml file that includes the following:

      <remove name="MyOverridenConnection"/>
      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

For some reason the remove tag is left out during the substitution and I end up with the following in the installed config:

      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

Is there any way to issue removes in replaced sec

Remove characters in a string


i have a string like this   sravani/, asdfff/, lsdsf/
i want to remove last character '/'  in the above string...
which function can i use?

pls help me....

How To Remove a Query Parameter from a URL


for a string such as this:


how would I remove the parameter id 12?


Delete spaces created by combining 2 fields


Howdy, this is kind of a continuation of an answer I got from this thread:  http://forums.asp.net/t/1592766.aspx

My users will enter a city/station where an incident occured, and the date.  The trigger below does work, but it will occasionally put spaces between the citystation and the date.  I think this happens when the citystaion name is not very long, but not sure.

(ex: city____08242010)

How can I make sure that if the incidentid is going to have spaces, that sql deletes those spaces?  I need the id to be space free.





TRIGGER [dbo].[tr_AddID1] ON [dbo].[tblIncidents] INSTEAD

Remove HTML formatting


Anyone know how to remove html-formatted-string to plain text programatically?

I want to get the same result as if i ctrl+a in a browser's page and then ctrl+v in a notepad.

I was googled how to strip html string, but didn't find the good result.

Removing tag using regex: "<(.|\n)*?>" causes some problems:

* The html-table is not nicely converted to tabbed plain text. It produces *crazy* table in plain text.

* the html-alternate-image lost

* the list ( <ul> & <ol> ) is not conveted well. No numbering or bullets in plain text

SharePoint Workflow E-mail Hyperlink has the Spaces Between Two Words Are Removed

I have a very simple Workflow, that includes href link to Infopath form.
If the form name includes spaces, the URL redirects to a The Form has been Closed message, indicating that it cant find that form.
In our scenario, the file name of the document/form in SharePoint when saved is called "Travel Request - <submit date>"  as noted with spaces.
The Hyperlink URL in the email generated by the workflow appears to encode all values in the name after the first two words (after Request).  See below.  after the word Request the spaces are encoded properly.     its replacing the first space with it appears %0d%0a (CR LF)
The URL below is what is displayed when right clicking, and selecting Edit Hyperlink in the email

I can reproduce this in development and production.  Any ideas on how this can be resolved?

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