Stack Overflow
Stack Overflow

Questions tagged [reportbuilder]

ReportBuilder can refer to either the Microsoft Report Builder tool for SQL Server Reporting Services (SSRS) reports, or to the Digital Metaphors Corporation reporting solution for Delphi developers on the Window platform. Always use an appropriate companion tag.

ReportBuilder can refer to either:

  • the Microsoft Report Builder tool for SQL Server Reporting Services () reports;
  • to the Digital Metaphors Corporation reporting solution for Delphi () developers on the Window platform.

Always use an appropriate companion tag when using the tag.

685 questions
24
votes
4 answers

Carrying out a SUMIF like operation using SQL Server Report Builder

I'm trying to produce a conditional sum in SQL Server Report Builder 3.0. My expression looks like this: =Sum(Iif(Fields!ProjectTypeID.Value=2,Fields!kWp.Value,0)) I'd hoped that this expression would produce a sum of the kWp of all projects of…
Daniel Neal
  • 4,165
  • 2
  • 20
  • 34
14
votes
2 answers

I can't see "Report Builder" button in the Report Manager on SQL Server 2005

I am a member of all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder). If I login with a Local Administrator account, I can see and use it fine. Any ideas?
vitule
  • 15,612
  • 11
  • 33
  • 37
14
votes
2 answers

SSRS Report Builder - Issues From Experience?

I'm looking into the idea of rolling out the web-based SSRS Report Builder to our end users to allow them to create their own reports against our production application databases. From what I have seen so far, this tool is easier to use than the VS…
Sam Schutte
  • 6,666
  • 6
  • 44
  • 54
12
votes
5 answers

How do I make wildcards work in a like operator in SQL Server reporting services?

I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it to act like %@test% so I can pass '' to get all…
David Silva Smith
  • 11,498
  • 11
  • 67
  • 91
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
10
votes
2 answers

How to keep a specific row as the first result of a query (T-SQL)?

I'm writing a SQL query to get a list of parameters for a report in Report Builder 3.0. I needed to add an extra row with the value 'All' to the results like this: SELECT 'All' UNION SELECT DISTINCT Manager FROM IS_Projects This…
confusedKid
  • 3,231
  • 6
  • 30
  • 49
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
7
votes
1 answer

How can I get SSRS and Chrome to work together?

Chrome is my preferred browser; I need to interact with SQL Server Reporting Services, though, and when I navigate to a report created with Report Builder (*.rdl file), in Chrome I get no contextual menu. When hovering over the report, it does…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
7
votes
4 answers

Fast Reports Non Database

I have been using Report Builder for some years, but I am getting tired of the cha-ching, cha-ching. It is a great reporting tool for "non database" reports. I have started playing around with Fast Reports and I am utterly flustered with it. It…
t j
  • 413
  • 1
  • 7
  • 12
7
votes
1 answer

How to set multiple integer ReportParameter in c#?

I am using Report Builder and loading the report in c#, also setting some parameters in c# too: My question is, how do I set a ReportParameter of multiple integer values when I have it stored in an array? I have tried the following: …
Bill Software Engineer
  • 7,362
  • 23
  • 91
  • 174
6
votes
1 answer

Report Builder 3.0: How to convert string representation of dates in mm/dd/yy format using CDate

I'm building a report using Report Builder 3.0. The source system I'm working with has strings representing dates in the format of mm/dd/yy, but I want to show this to the end users as dd-MMM-yy instead. Using CDate on the string will give me errors…
confusedKid
  • 3,231
  • 6
  • 30
  • 49
6
votes
3 answers

Fastest way to locate record in TQuery resultset

I am wondering what the best (read: fastest) way is to locate a record in a resultset of a Tquery SQL statement. Until now i'm using TQuery.Locate and if i'm right that is the only statement that can be used to search in the resultset. So how can…
Bascy
  • 2,017
  • 1
  • 21
  • 46
5
votes
1 answer

Is it possible to display a PDF in a Report Builder report?

We use report builder to generate reports on our software developed with Delphi 2010. I have a lot of reports that display an image, but: Is it possible to display a PDF in a report builder report just like we display a JPG? One of our customers…
Rafael Colucci
  • 6,018
  • 4
  • 52
  • 121
5
votes
2 answers

Report Builder: Can I link to a specific part of a report?

I would like to link to a specific section of a report from another report. A quick search on the internet didn't give me any suggestions, so I thought I would ask you smart folks here ;-). I'm really looking for something like anchors in HTML but…
confusedKid
  • 3,231
  • 6
  • 30
  • 49
5
votes
8 answers

How can I embed Microsoft SQL Server 2008 Report Builder into my forms?

I don't want to open Report Builder from Report Manager. I want to embed Report Builder into my forms. Is there any way?
mokaymakci
  • 1,373
  • 1
  • 18
  • 30
1
2 3
…
45 46