Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2008. More info in the tag.

This tag is for questions specific to SSRS 2008.

6153 questions
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
2 answers

How to consume a WCF service with SSRS 2008 R2

Are there any good tutorials available for querying for WCF services from within SSRS? My WCF service is running fine, but when I try to query it from SSRS, I get contract mismatch exceptions. Some Googling suggests that querying WCF services in…
Vishal Bardoloi
  • 652
  • 5
  • 18
10
votes
4 answers

SSRS 2008, custom dll, file not found

I've been fighting with SSRS now for a while and it's beyond silly. When I add a reference to a dll (which is part of the same solution) it gives me nothing but a [rsErrorLoadingCodeModule] Error while loading code module: …
jeriley
  • 1,313
  • 12
  • 20
10
votes
4 answers

Simple Way to View SQL Query (ies) Generated by SSRS Reports?

Is there a simple way to view the SQL Queries actually generated by SSRS other than running profile traces to capture them? Is there some way from within the BIDS editor to see this?
DavidStein
  • 3,149
  • 18
  • 41
  • 62
10
votes
3 answers

SSRS tablix Sorting not working on Date column

I have a SSRS report one Stock#_______Description_____Colum1_____Colum2_____Colum3 ABC__________XYZ_____________4334________4354_______454 detail part Transaction#_______Date 1__________________yyyy/MM/dd } Need to be…
Builder
  • 1,046
  • 2
  • 10
  • 30
10
votes
3 answers

How to percentage and count in SSRS Pie Chart

I have a Pie chart generated using SSRS. I would like to Show both Count and percentage in the Pie chart. Right now, I am able yo show the count in pie charts as well as in the report. I want to show the name of the partition and also the…
user2831167
  • 167
  • 2
  • 5
  • 15
10
votes
3 answers

Excluding the time in a "date/time" parameter for SSRS reports

In my SSRS report, I wanted to allow the users to specify a date (that would be used to filter the data on a report). When I did this, the parameter also includes the time. Is it possible to just allow the user to select a date, without showing…
Matthew Dunsdon
  • 133
  • 1
  • 1
  • 8
10
votes
1 answer

SSRS Report Does Not Refresh Via URL Access

I want to display the output of an SSRS report in an IFrame of another application. I set the source to something like…
Mike
  • 101
  • 1
  • 1
  • 3
10
votes
10 answers

User '' does not have required permissions, SSRS 2008 on Windows 8

When you try to log into SSRS's root site at http:// (servername)/Reports it displays: User '' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been…
djangojazz
  • 14,131
  • 10
  • 56
  • 94
10
votes
5 answers

SSRS dataset not refreshed after changing MySQL stored procedure

SSRS dataset not refreshed after changing MySQL stored procedure. I created an SSRS report in which the dataset gets data from MySQL stored procedure. In this scenario the output is generated correctly and so is the report. Later I modify some…
siva
  • 111
  • 1
  • 1
  • 5
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
3 answers

"Toggle items must be textboxes that share the same scope as the hidden item" in ssrs report

I'm working on drill down functionality in SSRS report with reference to tututial given at http://ssrs2008.blogspot.in/2010/09/creating-drill-down-report-with-sql.html But I'm getting error Toggle items must be textboxes that share the same scope…
Mohan
  • 907
  • 5
  • 22
  • 45
9
votes
3 answers

SSRS: Is it possible for an action to load a subreport?

I want to have users click on a column of a histogram and have that action load a subreport contained based on an attribute of that column. This would make SSRS reports a bit more interactive and a lot more useful. I noticed that when specifying…
Michael J Swart
  • 3,060
  • 3
  • 29
  • 46
9
votes
4 answers

ssrs expression to split string possible?

so in my query i have select columnx from tblz it returns 001.255556.84546 I want to be able to split this via '.' and put it into three columns. column1 = 001 column2 = 255556 column3 = 84576 is this possible?
user222427
9
votes
2 answers

SSRS show/hide tablix column programmatically based on parameter in rdl file

I have a SSRS rdl file that contains a 3-column tablix table, I want to show and show any of the columns programmatically based on the rdl paramter. I can achieve that by setting the Hidden property of a column to an expression:…
Pingpong
  • 7,681
  • 21
  • 83
  • 209
1 2 3
…
99 100