Is it possible to use parameters in Named Queries with Report models for eg: UserID? If yes, how can I pass the values to the userID parameter when user create and run any report in report designer based on the report model? Does anyone know of any samples\documentaion related to this? Thank...more >>

I am trying to setup and test whether data-driven subscriptions will work with SSRS reports that use MD data from SSAS. When I create a data source in Visual Studio all choices in the credentials tab get greyed out as soon as I switch from Sql Server Client to SSAS provider. Consequantly, I...more >>

I have a report that in which parameter is a number value. In my query I say: Where BAL_DUE=@BAL_DUE Now if the user puts in 100 it will only pull values that are equal to 100. How can I make it where user can say 100+ or 100- or 100> or 100< so it can pull data with 100 plus values and vic...more >>

When creating a subscription, we don't know what value to give the MonthlyRecurrence.Days property. It wants a string value, but what? Does anyone know what string value to give this property to indicate the first day of every month? ...more >>

Hello, I want to create a report model using the new Business Intelligence Development Studio which comes with SQL Server 2005. I have successfully created a data source and data view in BI dev studio and can right-click on the view & 'Explore Data' which works fine. When I come to creati...more >>

I think I either have an option set wrong or installed something wrong. When I try to create a New Data Source in Data Model project, the dropdown box for Provider is disabled and so SQLclient Data Provider is all I can do. I would like to add a connection to an ODBC data source, which I shoul...more >>

Hello! I'm trying to send reports by email. So, I create subscription in the report manager with a correct email adress for the destination. The planification is everyday at 8h00. But nothing append. I never receive a report. I don't know what's happend. Can you help me . Thanks Regar...more >>

Hi, We are trying to generate report by passing parameter values through url In our report, we have a multivalued parameter named "ABC", having values say, val1, val2 and val3. When try to generate the report with parameter ABC having values as val1 and val2 using the url mentioned below,...more >>

Hi, I need to return a list of possable options for the user to select in a parameter. I can write the class no problem, but i dont know what the correct way is return the data into the report, then add the values to a drop down parameter. I could return the list as an array, but how do...more >>

Hi I'm trying to set up a Reporting Services report which consumes data from a SSIS package. I have a really simple package which just one data flow task. This task "transfers" a few records from an OLEDB connection to a DataReader Destination. When I try to consume these data in the...more >>

Hi, I have my report test environment in a LAN and the production environment in another LAN in another country. The production environment doesn't have Visual Studio. I want to know if there's another way to deploy reports in Report Server without to use the Visual Studio. Or, can I to dep...more >>

We have a folder which has disappeared in Reporting Services. When I try to add a new folder with the same name, I get an error stating that a folder with that name already exist. I think something is out of whack in the backend database. Anyone know the easy fix for this? -- Thanks,...more >>

Hi, We have the following issue with MSRS 2000. We have a user domain\jchapell. His domain account has changed to domain\jchapel (single L) His has Content Manager rights on all reports in one specific folder. However, since the change of his account he cannot manage report properties. ...more >>

Hi All, In reading the article, "Using Reporting Services SharePoint Web Parts..." article (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx), it mentiones downloading the web part cab file from the SharePoint Products and Technologies Web Component Directory at ...more >>

When i try to edit a previously created schedule the Only choice available to me is "Set Schedule" and "On a custom schedule" the text below reads At 12:00 AM on 1/1/0001. When pressing the Set Schedule button I get the following error, pasted below. Also this is happening in the Microsoft SQL...more >>

Hi, I hava report (RDL) which is having a parameter called Plan Owner, i want the facality of "Select All" in the dropdown, this i can achive through setting the parameter as Multi-Value. But the problem is if the user select "select all" from dropdown, i uses the IN claues, i want to a...more >>