ssrs-2008

querying data from Sharepoint using Report Builder 2.0: missing fields

I'm using SQL Server 2008 with Report Builder 2.0 to try and query data from a Sharepoint List, as described in this tutorial. The report is set up to use an XML data source with the connection string set to http://mySharepointSite/_vti_bin/lists.asmx. However, I cannot seem to get all the fields from the Sharepoint List, even if I spe...

How do you let end users customize report columns in SSRS?

I'd like to create a report where users have the ability to choose what columns they want to see from a predetermined list. They should also have other options like applying an aggregate function for footers (average, sum...). How do I accomplish this with SSRS? (this will be a first report attempt with SSRS). ...

SSRS for Sharepoint, Images in a report from a Sharepoint List URL?

Greetings Sabios, I have several reports I run successfully where the data comes from a Sharepoint list in the form of an XML dataset. I am however having trouble with one. I have a report that pulls an image file onto the main body of the report. This data too comes from a Sharepoint list in the form of an XML dataset which sends me t...

Grouping Hierarchical data (parentID+ID) and running sum?

Hello, I have the following data: ID parentID Text Price 1 Root 2 1 Flowers 3 1 Electro 4 2 Rose 10 5 2 Violet 5 6 4 Red Rose 12 7 3 Television 100 8 3 Radio 70 9 8 Webradio ...

SQL Server 2008 Express SSRS: export to CSV

Do Reporting Services in SQL Server 2008 support export to CSV? I only see Excel/Word/PDF in the dropdown list on in the SSRS localhost server when previewing report. I found in internet that SSRS 2008 seems to support CSV but I don't see it; is it Express limitation? I haven't found any notes about this limitation. ...

Entire Table is pushed to the next page when rendering a SSRS 2005 Report (as .pdf) in SSRS 2008

I have a SSRS 2005 report that I'm rendering in SSRS 2008 as a .pdf. The report contains (among other things) a table that's very simple: header row, details, no footer, no aggregation, no grouping, keep together = false, pageBreakAtStart = false, pageBreakAtEnd = false, repeatHeaderOnNewPage = true. I resized the table to be much narrow...

Can't Deploy or Upload Large SSRS 2008 Report from VS or IE

So far in this project I have two reports in VS2008/BIDS. The first one contains 1 tablix and is about 100k. The second one contains 3 tablixes (tablices?) and is about 257k. I can successfully deploy the smaller report from VS and I can upload it from the Report Manager in IE. I can view/run it from Report Manager and I can get to t...

SSRS 2008 export to MS Word A4 issue

I have a simple report maid in bids 2008 and deployed to a ssrs2008 server. it has this report properties: page unit : Centimeters page size : Orientasion: Landscape paper sise: A4 width : 29,7cm Height: 21cm all margins ar 2,5cm Showing and printing this report works fine making it perfekt on a A4 paper. expor...

Unable to create data driven subscription for ssrs report

I have a SSRS report which displays daily status report for the team members. The dataset of the report depends on User!UserID as a parameter which is passed to the SQL Query to fetch the data. I want to create a data driven subscription on this report so that every user gets his/her daily status report each morning. But when I click on ...

what is the work around for User!UserID when creating data driven subscription

I have a report that uses User!UserID. But "Data Driven Subscription" cannot be created on reports using the "User Collection" or having data source with Windows Integrated Security. What is the work around for this? ...

Reporting Services - dynamically pick right data source / dynamically change WHERE clause?

I have a brain-teaser for all you SQL Server 2008 Reporting gurus out there :-) I have a report which displays a bunch of data, including the UserID and OrgUnitID for users. It's a server report which I'm rendering on the server, from within an ASP.NET application. My requirement is that a "normal" user can only see his own data rows...

How to show the "Home" folder for SSRS 2008 in SQL Management Studio

Our Sys Admin just installed SSRS 2008 for me to play around with and see if I can get all our 2005 projects running on it. However, when I log onto the report server with SQL Management Studio 2008 there is no "Home" folder listed in Object Explorer. With our SSRS 2005 server I get a Home folder that contains a list of all our reports ...

Reporting Services: dynamically add filters to server report

I have some server-based reports (*.rdl) which returns data from a SQL Server 2008 view. The user would like to be able to dynamically add filtering, e.g. show me only data with Language = English, or show me only data for a given organizational unit or stuff like that. The number of filter criteria is reasonably small (four or five...

How to create MSI package for SSRS solution in VS2008

Hi All, I created the Reports in SSRS and i deployed in my local Report Server. Now one of my client wants that solution in their server(Development) in a Package. But i have no idea how to create MSI package for SSRS.... So please help me, i want to deliver that Package please Thanks in Advance Vinay K ...

Reporting Services: Show item in header if body contains ...

Hello there, as reporting services are not very agile with page header/footers (like word is with sections) I am doing some hiding/showing of items which are all stacked in the page header. Currently I do a simple expression for visibility IIF(Globals!Pagenumber = 2, True, False) As I have growing tables beginning on page two I do no...

SQL Reporting Service SSRS PDF Export Missing the Bookmarks?

Hi all. I'm using SSRS 2008, and in visual studio during preview, then save to pdf. the bookmarks don't export, or atleast the PDF reader dosn't think there are any (in Adobe Reader, click Document - Navigation - Bookmark (but bookmarks is missing)) Has anybody ever exported thier SSRS bookmarks with the report? And had them working? ...

In SSRS I enter a date parameter . How do a calculate a future date from that Parameter (say 120 days from it?)?

I have naught but a static XML file to provide me the following data: Event Start Date End Date I must display a subset of this data within a 120 Day range of the input Parameter (Usually defaulted to today() but, not always). How can I code paramters for a date range? It looks so simple but, I have spent all day on it. ...

Can't Deploy Report Models in SSRS 2008

I created a data model in BIDS for SSRS 2008 SP1. When I try to deploy, I get the following error: Exception of type 'Microsoft.ReportingServices.RsProxy.AccessDeniedException' was thrown. When I Googled the issue, all I can find is information such as this: Open “Report Manager” using http:///reports; Click “Site Settings”...

Report Builder 3.0

I'm using SQL Server 2008 (non-R2) and trying to use Report Builder 3.0. When I try to connect to the report server, I get an error: Connection Failed. Unable to connect to the server that is specified in the URL...... However, I am using the same connection as my Report Builder 2.0 and that works fine. Can RB 3 not work with ...

How to avoid that the Parameter Pane Area in Drill-Through Report is hidden

I have a report that via a text box property action triggers a drill-through report (and gives it two parameters (start date, end date)). That all works fine in the report designer, however after deploying the report on the server the pane in the drill-through reports is hidden. Is there a way I can change this behavior. Our users want t...