Sol Web Solutions Blog

Sol Web Solutions Blog is aimed to help, inform, educate and enable our site visitors.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Login
    Login Login form
Subscribe to this list via RSS Blog posts tagged in SQL Server Reporting Services

Posted by on in Reporting
Line chart series to start at 0

I have a line chart series that is for accounting.  A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations.  What I'm trying to do is have the series chart line start @ 0 (we're trying to mimic another chart that does the same thing).

Hits: 16392
0

1. First create the data source in your Datasets folder.

In my case, my dataset is called dsStatusDDL because I'm pulling a status field from a SharePoint list.First create the data source in your Datasets folder.

Hits: 218016
0

Posted by on in Reporting

I had a customer request to hide a row conditionally, but when the report rendered in the browser the hidden row still took up spacing on the report.

I found this post thanks to Frank v.d. Laar:

http://www.sqldev.org/sql-server-reporting-services/hidden-rows-still-displayed-9660.shtml

Try to set the Hidden property of the Static Row Group under the Details Group, in this case the whole row will disappear instead of the content of the textboxes.

If you are using Report Builder, you need to switch to Advanced Mode (make sure that the Properties and the Grouping windows are displayed, go to the upper right side of the Grouping window and press the black triangle), click on the second "Static" item under the "(Details)" group and you can set the Hidden property on the Properties window.

Hits: 124567
0

Posted by on in Reporting

I had a requirement to add some spacing after a prefix of a textbox to align with a row below it and make the report more visually appealing. I tried the space() function within my expression, and that didn't work.

Here's what I did to resolve our scenario:

1. Left Double click the textbox that will hold this value/expression
2. Right click the textbox area and select "Create Placeholder" from the flyout menu option
3. In the "Placeholder Properties" pop-up modal, make sure to select
"HTML - Interpret HTML tags as styles" when in the "General" section

4. When creating the expression, I used the following for my padding:
=iif(Fields!datatype.Value="Issues", "Issue:"
& " " , "") & Fields!comment.Value

In my scenario, if the type was "Issues", then I needed to put:
a prefix of "Issue:" + spacing + my comment field

Thanks!

Hits: 151725
0

YOU ARE AWESOME!
I'm so blessed to
have people like you who
continue to make this
operation go.

Love the website.

Thanks for your hard work.

...thanks! I will pass it on to
our amazing web master
at Sol Web Solutions.

I LOVE the photos
on your web site.

It's really exciting to see the
site come together.
THANKS!!!

Get Started!

Help Today

Send an email here!

Sol Web Solutions will be glad to help you anytime with general or technical questions, suggestions or comments.

Website Hosting

Web Hosting

Sol News

We will not share, trade, or sell any of your information in any way. Your privacy is completely respected.