Stack Overflow
Stack Overflow

Questions tagged [report-builder2.0]

for non version related use [reportbuilder] tag, Use this tag for specific question on version 2 of SQL Server Report Builder

63 questions
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
10
votes
3 answers

Count rows of a filtered tablix in SSRS

I want to show row count of my filtered tablix in a text-box inside my SSRS report header. I googled quite a bit but nothing helped. Suggestion at this link gives me count but that is restricted to count of rows coming on current page. Even if my…
TechnicalSmile
  • 1,387
  • 5
  • 16
  • 30
9
votes
2 answers

Move a column in Report Builder 2.0

How can I simply move a table column left or right in Report Builder using the UI (or text editor if necessary)? I've tried to drag and drop, looked at menus, etc, and I can't find that option. Is it in there? So far I've had to delete and…
Dave
  • 4,949
  • 6
  • 50
  • 73
8
votes
1 answer

reportviewer bar chart, bar width incorrect

I have a problem with a report that is build using report builder 2.0, on a sql2008 database (latest service pack installed), reporting services Version 10.0.5500.0. The problem is that the bars are wider then they should be. Each bar should be as…
Rutger
  • 1,163
  • 3
  • 12
  • 29
5
votes
0 answers

Prompted for credentials when using a shared data source with Report Builder 2.0 over the Internet with forms authentication

SQL Server 2008 (not R2). I am trying to allow users to build and deploy SSRS reports on a reporting server that the users can only access over the Internet. I have created a custom forms authentication provider. I can now connect to the reporting…
Josh Weiss
  • 51
  • 3
4
votes
7 answers

SSRS - Adding "LIKE" filter criteria to report builder

I want to add a LIKE filters with wildcards in SSRS report builder. I tried this using contains clause present in filter data section of report builder. I tried both '*' and '%', but of them failed. I tried MyFieldName contains 2451 - this…
TechnicalSmile
  • 1,387
  • 5
  • 16
  • 30
3
votes
3 answers

Report Builder: How to sort parameter list

The situation: I am generating reports using Report Builder 2.0 and a Report Model that I have created. The question: How does one sort a parameter list alphabetically? Simple question, but I can't find the answer for the life of me. Kudos to…
James Jones
  • 8,653
  • 6
  • 34
  • 46
1
vote
0 answers

SQL Server 2005 Report Builder 2.0 - TFS Reporting : DATEDIFF between Start and Finish dates of a workitem

First of all thank you on advance for taking the time to access my question here. I'm using Report Builder 2.0 for TFS Reporting with the TFS OLAP Cube as the main datasource. I need to calculate the time taken between the start and end (completion)…
MrOnigiri
  • 191
  • 1
  • 4
1
vote
1 answer

ssrs export to CSV including HTML code?

I'm working on a report, using SSRS, that i want to export to multiple formats (excel, pdf, csv...) When i'm trying to export to csv format, after the data values, it's including html code why? can I override this behaviour with any change on the…
DJPB
  • 5,429
  • 8
  • 30
  • 44
1
vote
2 answers

Query useing two databases in SQL Report Builder

I am new to SQL Server Report Builder 2.0 and I need to compare two different databases in one query. Basically I need to check if values from one database table exist in a different database's table. I know I can add multiple Datasources to my…
user912447
  • 696
  • 1
  • 11
  • 31
1
vote
3 answers

Report Builder 1.0 vs 2.0. Search function disappeared?

We have a client who is migrating from Report Builder 1.0 to Report Builder 2.0. Yes, I realise they are very behind the game, and RB3 has been out ages, but there are internal reasons why they are making this decision ... This being the position…
Marcus D
  • 1,074
  • 1
  • 12
  • 27
1
vote
2 answers

Changing NaN to 0

This is my current expression below which works fine until the answer is zero and then I am presented with NaN in my report. =sum(IIF(Fields!RestrictedTo.value = "Not applicable" or Fields!RestrictedTo.value = "Limited to item" or…
Clem_Fandango
  • 254
  • 2
  • 18
1
vote
3 answers

Override sort in SQL Server 2008 Report Builder 3.0?

I created a dataset with a SQL query in Report Builder 3.0. I did NOT specify an order by in the query, but instead used union all to stack the results in the order I wanted. The first column in this dataset is called Product. When I create a…
Ray
  • 3,137
  • 8
  • 32
  • 59
1
vote
0 answers

SSRS/Report Builder - Export to Word Shows Hidden Rows

SSRS and Report Builder drive me absolutely crazy at times. In this instance, I have a report where I have 2 rows which are hidden if there are no images attached to that item. When exporting to PDF it works perfectly, however when I export to…
Indy-Jones
  • 668
  • 1
  • 7
  • 19
1
vote
1 answer

SSRS ReportBuilder crashed on me, now it won't re-open a report

I’ve been editing a report (ReportBuilder 3.0) and was playing about with the positioning for a legend entry on one of the charts. It let me save the report, but when I ran it in IE it displayed an error in the chart placeholder. When I went back…
Jon295087
  • 731
  • 1
  • 8
  • 28
1
2 3 4 5