Stack Overflow
Stack Overflow

Questions tagged [reportbuilder3.0]

Version 3.0 of Microsoft Report Builder creates reports, charts, tables and dashboards for use on Microsoft Self Service Reporting Server. This program is designed for use by business and end users as opposed to proficient programmers.

Version 3.0 of Microsoft Report Builder creates reports, charts, tables and dashboards for use on Microsoft Self Service Reporting Server and SharePoint. This program is designed for use by business and end users as apposite to proficient programmers.

Report Builder 3.0

This tag should be used for questions about:

  • The program itself;
  • Reporting outputs; and
  • Formatting.
894 questions
187
votes
6 answers

Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in Report Builder 3.0. Is this true? If not, is there…
Ayrton Senna
  • 3,735
  • 5
  • 34
  • 52
51
votes
1 answer

Report Builder 3.0 SWITCH expression DEFAULT/ELSE

I am trying to display a different logo based on the users franchise number. Parameter = UserFranNr If the value <> 99 and <> 87, then the embedded image to display is ID0. (Embedded image names are strings.) This works with nested IIFs but seems to…
Dennis Post
  • 613
  • 1
  • 5
  • 4
27
votes
4 answers

Sql PIVOT and string concatenation aggregate

I would like to use a pivot SQL query to construct a result table where the concatenate text as a result within the DATA section of the pivot table. i.e. i have the following result from using a simple…
Mortalus
  • 10,574
  • 11
  • 67
  • 117
24
votes
5 answers

Using 'like' in ssrs expressions

I'm trying to highlight a field when the value has the word 'deadline' in it. I'm trying to use the expression: =IIf(Fields!Notes.Value like "%deadline%","Yellow","Transparent") in the BackgroundColor property. It's not highlighting the field (not…
blsub6
  • 395
  • 1
  • 3
  • 7
19
votes
5 answers

How do I find a specific textbox within a SSRS 2008 R2 Report

I have a large report that I built in Report Builder 3.0. The report consist of several tablexes and several (800 - 1000) textboxes. When I get an error in an expression, the system says I have an error in Textbox205 for example. Is there an easy…
Teddy Jackson
  • 191
  • 1
  • 1
  • 3
16
votes
2 answers

Joining two datasets to create a single tablix in report builder 3

I am attempting to join two datasets in to one tablix for a report. The second dataset requires a personID from the first dataset as its parameter. If i preview this report only the first dataset is shown. but for my final result what i would like…
mushcraft
  • 1,994
  • 1
  • 19
  • 27
14
votes
2 answers

Is it possible for me to include a sub report in a tablix row that is grouped by an ID?

Is it possible for me to include a sub report in a tablix row that is grouped by an ID and pass that ID into the sub-report to be ran? Basically, the sub-report would return data from a second dataset based off of the ID that is being used in the…
Nick G
  • 1,209
  • 8
  • 34
  • 58
14
votes
2 answers

Set Tablix row height to a specific number in SQL Server Report Builder 3.0?

I'm trying to set the row height of the detail row to a specific value, like 0.5 in. If I click on the Tablix handle for the detail row; it selects the row but the Size property does not expand for the Height property or allow entry for something…
Dan Metheus
  • 143
  • 1
  • 1
  • 4
12
votes
3 answers

SSRS - Expression using different dataset fields

I have a report with multiple data-sets. Different fields from different data-sets are used in different locations of the report. In one part of the report, I need to do a calculation using fields from two different data-sets. Is this possible…
Zolt
  • 2,761
  • 8
  • 43
  • 60
10
votes
3 answers

Report Builder 3.0 - Dataset Credentials Do Not Work

I am using SSRS 2008 R2 and Report Builder 3.0. I set up a shared data source via the browser (http://myserver/reports/) wherein the "credentials are stored securely in the report server" to use with multiple reports. Testing the connection via the…
alphadogg
  • 12,762
  • 9
  • 54
  • 88
10
votes
1 answer

#error when summing numbers in report builder?

I'm trying to sum some numbers up in a grouping, and sometimes a #error would show up instead of an actual number. I understand that this may happen when dividing by 0 or when there are nulls in the dataset, but in the dataset, I only see valid…
confusedKid
  • 3,231
  • 6
  • 30
  • 49
9
votes
1 answer

how to show entire report in single page using Report Builder?

I am using MS Report builder 3.0 to create one of my report.The report is the tabular report and sometimes the size of table grows long about 2 to 3 pages. But i want to show the entire report with in single page without having to click next page…
Ujjwal
  • 209
  • 2
  • 4
  • 10
8
votes
2 answers

Report Builder 3.0 vs Visual Studio 2012 for creating SSRS Reports

I have always used Visual Studio to create my SSRS reports but I have recently been advised to switch over to and use report builder 3.0. I am wondering, are there are any advantages to using one over the other for SSRS report development? Any known…
Juan Velez
  • 741
  • 5
  • 15
  • 29
6
votes
2 answers

SSRS: Dropdown is not populated in filter in Report Builder

Whenever I try to apply filter to an attribute, which has ValueSelection= Dropdown, the dropdown is not populated and error message "The requested list could not be retrieved because the query is not valid or a connection could not be made to the…
Dmitry O
  • 181
  • 1
  • 8
5
votes
2 answers

How can I remove unused datasources from Report Builder?

I am using Report Builder 3.0 to create, deploy and manage reports for my .NET application. I create a new datasource with network credentials which are stored in the report server and point to that shared datasource when I build the reports. My…
Lynette Lynn
  • 53
  • 1
  • 4
1
2 3
…
59 60