Hello, I want to filter records right in the Data Source View. I did a "Replace Table with new Named Query" but how can I get it to filter records by User!UserID? Thanks, -Will ...more >>

Hello, I have a report with the following structure in a table: table1_Group1 Header table1_Group2 Header Detail Record: =Fields!X.Value table1_Group2 Footer =Avg(Fields!X.Value) table1_Group1 Footer =Avg(Fields!X.Value, "table1_Group2") In the table1_Group1 Footer, I want t...more >>

Is it possible to install multiple instances of RS on one server? if so, how do I do that? The reason for needing this is that I have two groups of customers. One group should be authenticated through Active Directory, while another group should use cookies for authentication (they are auth...more >>

Is it possible to output records in a dataset while not showing the duplicates. The dataset that I am using returns records like the following. title1; problem1; associateddata1 title1; problem1; associateddata2 title2; problem2; associateddata1 Even though first two rows do not look like...more >>

Hey, I have a little format issue with Excel 2003: I am working in reporting services - creating a report. The SQL store procedure returns a date with the following format: MM/DD/YYYY HH:MM PM/AM In my report on that perticular text field I have the following format: dd/mm/yyyy H...more >>

I have been creating some reports with RS2005, and encountered an odd problem: Going into the data tab, I can edit my data set, and see that my parameters are properly mapped. Leaving 'edit', I click on 'Refresh Fields', and instead of being prompted for the 4 parameters I expect to see, the...more >>

I have developed a scatter chart and have set bot the the x-axis and y-axis scales manually. However neither the minimum nor the maximum are being respected. I am not trying anything complicated, just trying to set some blank space around the plotted data so that the plot points don't go right...more >>

Is there away to import a Word Doc or Template in to Report services? Thanx in advance, Greg ...more >>

I get the following error for five of my fields on my report when no recordset is returned. They all happen to be items that are being pulled from another table. So it seems that if there are no IDs to link to the other table, I get this error. Can anyone tell me how I can get around this to s...more >>

I have a dataset and i need to order the results in a particular way which is neither asc/desc or numeric In the dataset, i have a particular column with the following values: Active Not Active Completed Cancelled I want to sort in the order as noted above. Is there a way to specifiy to s...more >>

We would like to support Report Builder / Report Models in our application, and we know that Report models are generated from SQL Server relational or Analysis Services multidimensional databases. Based on our superficial understandings of report models, it seems that we should be able to cre...more >>

Based on the tutorial in http://msdn2.microsoft.com/en-us/library/ms170667.aspx We have a prototype that works with our custom data extension in Reporting Services 2005 such that we can generate a report based on a given query text. Right now in order to view a report, we always publish the...more >>

Is ther any way to make form authentication with using standard edition instead of using reporting service enterprise edition. I currently use 2000 sql server standard and reporting service standard edition. ...more >>

Can Reporting Services use an XML File as the Datasource for the report?...more >>

I posted before w/ no reply from someone from MS... trying again... Hello, We have never been able to get the printing to work on any of our reports using SQL Server Reporting Services SP2. During the time we have been fighting to get this to work we had added on the SP, so we totally r...more >>

MS SQL Server 2000 Developer XP SP 2 laptop Visual Basic .Net MS .Net Framework 1.1 MS development Environment 2003 SQL Server Report Designer V8.00.743.00 When I go to Tools - Connect Database - Fill out the credentials for my server. Test connection - Test Connection succeeded. Click ...more >>

We currently have a box running with RS 2000 and a separate box running SQL 2000 containing our report catalog. Is it possbile to have a mixed mode? The box our catalog is stored on is on a huge cluster and we are not prepared to migrate it yet....more >>

Hi there I have uploaded some reports to our reporting services server, however I want to be able to have them emailed to clients outside the network at the end of each week, Can you explain how to do this? Regards Tim...more >>

Can you build a dataset in a web application and send it as a parameter through the report viewer control and have reporting services use this dataset as the binding dataset for your table in Reporting Services? IF so, can you help me or direct me to some article that will show me how to do ...more >>

Hi all, I have two Report Parameters: StartDate and EndDate, each of which pulls values from a dataset. My question is, Is there a Selected Index property (similar to ASP.NET dropdown lists) in RS? I want to be able to get the 2nd Item value in the StartDate dropdown list (The first i...more >>

Hi, I've implemented a data extension to use a custom business class to return a dataset. This all works fine but I cannot seem to get parameters working. Has anyone got any code snippets of creating parameters and the parameters being available at run-time & design time. All the exampl...more >>

Hi, I am a newbie in reporting services with a pretty easy question. How can display percentage values of a column depending of the column sum? Example: _______________________________________________ row1 3 30% row2 5 50% row3 2 20% _______________ sum 10...more >>