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

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

Double line spacing in SSRS

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :Sql Server
How do I achieve double spacing of lines in a large text box in SSRS?


View Complete Post

More Related Resource Links

Line Divider i n Column chart in SSRS 2008

Hi,  Any one pls tel me how to do the single line divider in Column chart in SSRS 2008 example: --------- |               | |     20      | ---------- |       100 | |               | -------------------------------   i want to show the above example. Thanks in advance Regards, Abdul2010

Character spacing issue SSRS 2005 custom font

Hello together, we are facing a strange character spacing issue in SSRS 2005 SP3 (Version 9.00.4035.00). As we export the report to a pdf file, we get unwanted spaces between each character. The report uses custom fonts. Is there any known issue related to this? I appreciate your help. Thanks!  Kind regards Moritz Mars

How do I stop line feeds in a Hierarchy field from a SharePoint list to prevent wrapping in a SSRS r

I'm developing a Reporting Services 2005 report that includes a Hierarchy field from a SharePoint 2007 list.  The Data Source for the report is an XML type. I would like to display the Hierarchy field on 1 line.  However, it is displaying in 2 or more lines in Visual Studio 2005. The field also wraps when rendering to Acrobat (PDF) file.  How can I get rid of the embedded line feed (I believe it's "&#xA").  I've tried using the Replace function in an expression, other functions and changed the properties, e.g., the CanGrow property.  Nothing seems to work.   Here's what I get: LAW>Administrative Law LAW>Criminal Law LAW>International Law   I'd like to see something like this (I'm able to add the "/"): LAW>Administrative Law /LAW>Criminal Law /LAW>International Law/

Font/letter spacing issue when printing from SSRS 2008 report page


We are developing reports in SSRS 2008.  When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...

I used several common fonts...
Arial, 10 pt (SSRS 2008 default)
Times New Roman, 12 pt (Office 2003 default)
Calibri, 11 pt (Office 2007 default)
Verdana, 11 pt
Tahoma, 11 pt

In the example above, I used normal weight, nothing fancy... If you use bold and underline, which is common for a page/column header or footer, this issue is even more apparent.

It feels similar to the following issue: https://connect.microsoft.com/SQLServer/feedback/details/482312/ssrs-report-font-rendering-issue

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

Line Graph is not showing up in SSRS 2005


I am creating line graph using BIDS 2005 ( VS 2005). When I select chart type line , I do not see a line graph insteady Scatter dots in graph surface. I have tried to add screen capture in this question but for some reason I can not paste here. I can easily switch my chart type into Columan,Bar,Pie, XY (Scatter),...etc except Line chart. Any idea or suggestion greatly appreciated!!! Thanks,



SSRS 2008 R2 - Line chart labels - visibility based on expression?


I would like to control the visibility of a data label in a line chart using an expression. For example, I have a requirement to show the data label for two compariable data points in a line chart where the horizontal axis is time (Q1, Q2, Q3, etc...) and the data points are determined based on a selected parameter. The basic idea is that a user can select to view Q3 as the end point of reporting and the chart will graph a complete time line (e.g. FY 2001 thru FYXX Q3) but only show the label for Q3 and prior year Q3.

I have tried to build an expression in the visibility property of 'Chart Series Labels' but this does not appear to work.


SSRS 2008 r2 line chart primary and secondary category axis


I want to plot series in a line Graph on UTC time which has to be placed on Primary category axis. The secondary category axis should just display the correspoding PST time(No series need to be plotted on this). Is there a way to achive this?

Can we show a line chart on multiple pages with page breaks? SSRS 2008


Hi there,

I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other. http://oi54.tinypic.com/2vifrb9.jpg

Is there a way to split the chart and show it on different pages.? Thanks in Advance :)


How to bring the stripe line into fore ground in a ssrs 2008 chart


i have created a 100 % stacked bar chart report in ssrs 2008.

in that chart created a stripe line for showing current week data.

i cant able to see  the stripe line fully.

is there any way to bring that stripe line into fore ground?

Place in each line of a variable in SSRS report, possible?



So, I'm generating a report in SSRS and found a question (or challenge).
I generated a table with the following columns: Customer,% contribution, usage time and total. As far as customer usage time I get in my database ... That is, a basic form of my report will come out + / - like this:

Customer | % Contribution | Usage Time | Total
Client1     |    0                       |  123             |   0
Client2     |    0                       |  4567      &

SSRS 2008 - Grid Spacing For Pixel Formatting -How can we Set in SSRS 2008 ?


Hi Friends,

I have a question on - How can we set Grid Spacing for Pixels in SSRS 2008 ?

In SSRS 2005, Report Properties, We have Grid Spacing, Frm where we can Reduce Pixel distance in Design mode.

I am looking for the exact same property in SSRS 2008.

Any help greatly appreciated.


Article commenting by line number


I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.

I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they can´t edit them - only add their own.

Any suggestions would be great.

New off line application working with sdf file. Need advice


Hey Folks

I am working on a project currently where I need to get data out of a 3rd party vendor's software that uses a .sdf file I looked this up and its a SQL CE file. I was hoping to just link to with with access but thats apparently not going to happen. I need to link to the database extract data from it to a csv file for later use. I also and most important I need to get the data from it and create a report that can be printed while on a customers site that my or may not have web access so I need for this program to be on and off line. I had my webapplication that I have been working on open and was able to bring up the sdf file under the server exploere however I can't seem to get anything out of it when I try to do grid views or detail views errors out.

Can I use one of Visual Studio projects to create this sort of applicaiton if so what would be the best approach. I would love to get an access odbc driver since office is allready installed on the employee's laptop's



Line Break Problem in XSLT


Hi All,

I want to add line break in the xslt but it not working.

Below is the code for adding the line break.

</P> <P>
&lt;xsl:variable name="Collection7"&gt;</P> <P>&nbsp; &lt;xsl:value-of select="$13932"/&gt;&lt;xsl:text&gt;&amp;#xa;&lt;/xsl:text&gt;</P> <P>&nbsp; &lt;xsl:value-of select="$31042"/&gt;&lt;xsl:text&gt;&amp;#xa;&lt;/xsl:text&gt;</P> <P>&lt;/xsl:variable&gt;</P> <P>&lt;td&gt;&lt;xsl:value-of select="$Collection7"/&gt;&lt;/td&gt; </P> <P>&lt;/code]</P> <P>I have tried the below code as well:</P> <P>&lt;xsl:variable name="newline"&gt;
&lt;/xsl:variable&gt;</P> <P>or</P> <P>&lt;xsl:variable name="break"&gt;&amp;lt;br&amp;gt;&lt;/xsl:variable&gt;</P> <P>or </P> <P>addign &lt;br/&gt;</P> <P>then also it not adding the line break.</P> <P>But If I write code like below then it is adding the line break and it works fine.</P> <P>

where can i download from SSRS?


Hi all,

My  machine is alread installed with Sql Server 2005.  I need to install sql server 2005 reporting services as a add-on.

Where can i download this from. Can anyone post the link here..?


Thanks in advance


MDX Query parameter from SSRS


I've a MDX Query that has where clause as shown below.
I'm designing report using SSRS 2008. How can i pass date as parameter ? I tried to setup @from and @to as parameter but not working ?
any ideas....

WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )

need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )



How to change text in columns in SSRS?


I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.

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