Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
1 answer

Keeping a large table into one page in ssrs 2008

I have a quite big table in the ssrs 2008. When I run the report, everything is good on the web. But when I save the report as pdf, the table is displayed into 2 pages instead one single page. I tried to set InteractiveSize -> height:0 cm and I…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

Why is this IIF comparison failing

I have to work with a database that returns string data that is both alpha characters but also uses numeric characters. For example 1 record may return the string"1000" the next may return the string "blah" All alpha strings will always be…
Perry
  • 1,277
  • 2
  • 17
  • 39
0
votes
1 answer

SSRS - Dataset using different dates (Table)

I'm creating a report with all of the sales made from each product category. I added a table that contains on the column side: Months and for Rows I have the Product Category (i.e. Chairs, Tables, etc.). So it should be looking something like…
user3175024
  • 41
  • 1
  • 1
  • 5
0
votes
1 answer

the query works fine in SQL server, but not in SSRS

the report query has a parameter that can take one of two values: ActiveCustomers or AllCustomers and based of what user picks the data get filtered. My problem here is the query works fine in SQL server, but is not working in SSRS unless I hard…
Fatemeh Shakhsesalim
  • 51
  • 9
0
votes
0 answers

How to change order of the table displays (page number) to keep the tables sequential

I have a report in ssrs 2008, which includes 2 tables and 1 rectangle to keep them in separated pages like: Table 1 rectangle (it is blank - page break before is selected from its properties) Table 2 Both the tables are grouped by NAME, in their…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

Calling update procedure (that accepts XML parameter) multiple times in SSRS report

I have a procedure that accepts parameter @Data of type xml and updates an order in order table. I have to call this procedure in a SSRS report for any order that need to be updatad and update the order table from one source table. Right now I have…
Fatemeh Shakhsesalim
  • 51
  • 9
0
votes
1 answer

Can't tell how report sorting parameter list (subreport routed through tablix)

I have a subreport placed inside of a tablix. The report the tablix is in takes a parameter that is a list of order numbers (A4, B7, etc.). The dataset splits the parameter, separating the order #s and routing them to the subreport. When I enter…
Dom Vito
  • 507
  • 8
  • 38
0
votes
1 answer

Custom Assembly Reference in SSRS 2008, SQL Server 2014 and Visual Studio 2015

I have a report project with 20 reports. Some of the reports are referencing a custom dll. I have copied that dll in the two mandatory folders 1.C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting…
Serial Kisser
  • 131
  • 2
  • 14
0
votes
1 answer

Inside bracket values goes to negative when getting a csv output - ssrs 2008

I have a matrix in ssrs 2008 and have an expression in one of its columns like: = Fields!Name.Value & "(" & Fields!Score.Value & ")" This is working fine and bringing the values inside the brackets like Jack(7.04) or John(6.39). Name is a nullable…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

How to assign a display order of the tables in a single report in ssrs 2008

I have a report in ssrs 2008 including 2 different tables. TABLE A TABLE B Both table are grouped by Name by adding a rowGroup. Note that there is also a page break "between each instance of the group" is enabled. So, When I run this report, it…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

access another dataset inside an expression

For each row in my report, I have one field where I need to check another dataset to determine the data that goes in there. This is the query for that dataset: select t1.this, t2.that from thisTable t1 left join thatTable t2…
SkyeBoniwell
  • 6,345
  • 12
  • 81
  • 185
0
votes
1 answer

Expression in a report

I have a report that shows the way people have contacted our business - phone, email etc. When people run the report, they choose the contact method via a drop down parameter. They can select one / many / all contact methods. I have added a chart to…
Will F
  • 417
  • 2
  • 6
  • 17
0
votes
2 answers

Change SSRS subscription save path in bulk

We are about to change one of the file servers and will be renaming it to something else. We have thousands of SSRS subscriptions saving reports to this server so I need to find a way of mass changing the destination server of where the reports end…
rmon2852
  • 220
  • 1
  • 7
  • 19
0
votes
1 answer

Is there any way to check user's permission on SSRS 2012?

There are several folders on SSRS Reporting server, we add users into those folders using AD directory. We never had this problem but now one user, he was not in reporting server before but now user can see all the folders and all the reports on…
James
  • 1
  • 4
0
votes
2 answers

Display Only the Most Current Record on Report

We have a report that outputs Table A. We added Table B to the report model (we added some fields to the report from Table B), which is a many-to-one relationship to Table A. Now when we run the report, we are getting multiple rows, which is to be…
Kocheese
  • 25
  • 1
  • 2
  • 10
1 2 3
…
99
100