I'm developing a report using SQL2000 which has Agent and SubAgent parameters. The client wants the Agent parameter selection to filter the SubAgent, which is easy using cascading parameters, but they also want the SubAgent selection to filter the Agent list to show those Agent's the selecte...more >>

Can anyone shed any light on using reporting services over the web in an accessible manner. I have some basic code which pulls the code from the web service and renders it as HTML 4.0 It is all tables and not XHTML. I am really interested in using reporting services but I work for a company wi...more >>

Hello: We are using the reporting services interface to display reports. By using the security we restricted some access and everything works fine. Now we would like to change the way the parameters prompt works. Is there any way of applying styles to the pages rendered by the reporting ser...more >>

Hello: I have a subreport displaying a title (actually a table with some rows of information) that is common to many different reports. I'll like to implement this title in a subreport and link it from the main reports, but some of them are in portrait format while others are landscape. I...more >>

I have been messing with this for 2 months now. Here goes: >>I install SQL 2005 Standard SP1 with all the components being installed to a Windows Server 2003 R2 server. >>I configure RS and everything works perfectly. >>Then, I install SharePoint Server 2003 and with both Service Packs to W...more >>

I showed my boss the functionality of ad hoc reporting in SRSS and he likes it. He asked me if we could completely move away from Crystal Reports (CR) to SRSS. Does anyone have any issues with SRSS that didnt exist in CR. One question i have is programmability capabilities. Some time back ...more >>

I'm running Reporting Services 2005 and I need a report that basically shows only 10 lines per page. I'm trying to google around for answers on this, but they are not straight forward at all! ...more >>

Hi, I have a stored procedures that returns me 2 recordsets. I want to use both of these recordsets to design my report. Any pointers for materials or solutions on this. Regards, Sudhakara.T.P....more >>

I am absolutely new to SSRS (about a day into it). I am trying to figure out the reporting methodology to use for building custom reports and would really like some suggestions on the reporting architecture that I should use. The base functionality is 1) Provide a c# UI to allow end-user to...more >>

Hi, I have a requirement to add 100 users (Windows) as browsers to view a report. I was wondering if I can use some reportserver webservice method to automate these kinds of bulk permission assignments. Can you please help me which method comes close to assiging permissions to users, if it is...more >>

I AM TRYING TO SEND PARAMETER VALUE TO REPORT USING VB.NET CODE BUT ITS NOT ASSIGNING THE VALUE TO THE REPORT PARAMETER. I USING THAT CODE. iF ANY BODY KNOW PLEASE REPLY.. Imports System Imports System.IO Imports Microsoft.Reporting.WebForms Imports System.Data.SqlClient Partial Class Key...more >>

First, I add a new report in Visual Studio 2005 (SP1) to get an empty RDLC file. Then, i try to get a reference to a node in this xml file using either SelectSingleNode in System.Xml namespace or the more advance SelectSingleNode-function in the System.Xml.Path namespace. But the function ret...more >>

I'm working on an accounting project that includes payroll. The IRS provides a stock W-2 form in PDF format which we'd like use and superimpose the report output onto, e.g. fill in the blanks. Is this possible? Reporting services is in local mode. The form is http://www.irs.gov/pub/irs-pdf...more >>

Hello and thank you for any assistance that you can provide. I am looking for a way to simply print out a Reporting Services report from a stored procedure with zero user interaction. I have very little knowledge of advanced stored procedure usage other than T-SQL commands but I imagine it c...more >>

We want to include some explanatory text inside the parametersArea but can find no way to do that. Is it possible to customize the parametersArea, or to replace the default with a customized control of our own?...more >>

If I have two datasources, one pointing to Oracle and another pointing to SQL Svr and consequently, two datasets (one from each datasource); is it possible to create a third dataset from the two or somehow combine the two into a single table? Thanks, James ...more >>

When you use Sql Mgmt Studio to assign a report as a drill-through target for a model entity, you can assign reports for both "Single Instance" and "Multiple Instance". Does anyone know what this means? I had a 2+-hour support session with a member of MS SQL Reporting team, and he didn't know ...more >>

How do i customize server error messages? add some meaningful description to the server default errors...more >>

How can I control the width of the dropdown for multi-select parameters? It seems to be showing up equal width dropdowns irrespective of the size of the text. The problem crops up when the length of the text for any option exceeds the default length, I get an ugly horizontal scroll bar. I can h...more >>

I'm reporting from a web service that takes so long to return that Reporting Services times out... how can I increase the timeout value when querying for data? TIA - ekkis...more >>

I have a real (hopefully) easy question... I'm wanting to deploy a Reporting Services project to a particular folder on my virtual server. For example, whenever you deploy a project it goes straight to the home directory and creates the MODELS and DATA SOURCES folders. I would like to de...more >>

Hello, Is there a way to get the reports to automatically regenerate when a user changes a drop down or selects a radio button? Thanks Dylan...more >>

Hi, Presently visual studio 2005 in SQL server 2005 reporting services has business intelligence project templates. I would like to know as to how to add Visual basic and Visual C# project templates to Visual Studio 2005. I am new to SQL Server 2005 reporting services. I would highly a...more >>

Sorry for the cross-post, but I'm not sure what the best place to post this is, and I'm getting a bit desparate. Part of our product uses the SQL Server Reporting engine to create reports in Excel and PDF format. To do this I am using the LocalReport object the Microsoft.ReportViewer.WinFor...more >>

Hi I was wondering how one can start designing reports in Reporting Services 2005. Kind regards Ricky ...more >>

anything new or updated for reporting services in the RTM of SP2? ...more >>

How do I limit table rows in a report, right now it shows all rows and that makes it difficult to see what the columns are. SQL 2000 -------------------------------------------------------------------------------- Jeg beskyttes af den gratis SPAMfighter til privatbrugere. Den har ind...more >>

Where do we get the same DLLs from? Reporting = Querying and PRINTING If the endusers CANNOT print the same way the developer do, then we have a serious problem with Reporting Services!!! On Feb/14/2007 Problem: Printing from Development is very different than from Production despite of us...more >>

I am rendering my first report on a web page. How do I take the binary data stream and place somewhere on a web page. I would like to have a web page with the usual things like navigation and render the report within this. How is this done? Regards, Chris. ...more >>

I need to convert Microsoft Visual FoxPro reports (FRX files) to RDL format. FoxPro report has groups. I think I must create nested List elements to simulate grouping and add report fields to those list elements. I have analyzed some possibilities: 1. Generate RDL XML from VFP FRX file us...more >>

Hi, as many others here in this group I have some trouble using RS 2000 and the options "Jump to report" or "jump to url". I have two report and I want to jump from report1 to report2. For that I can use to options either "Jump to report" or "Jump to url". I can jump from report1 to report2. On ...more >>

Hi, I try to configure sharepoint with RS to work together using the new SP2 functionality. I install the sharepoint x64 tool and configue RS with a new database and change his setup to use the sharepoint integrated mode. everything is green. now I open the application management page bu...more >>

I am using SSRS and when I connect to the website using http://servername/reports it goes right through, but using the FQDN http://servername.domain.com/reports I get a login box. I know this has to be simple, but I am stumped... ...more >>

I've tested a query in Query Analyzer and it returns the desired results. However, the same query in a SQL report finishes without errors but the report is completely blank. Similarly formatted reports work fine. Here's the query: SELECT CRMAF_Task.modifiedonutc, CRMAF_Task.modifiedbyna...more >>

Hello, I have the following scenario and I would like to know what my options are: I am using Reporting Services 2005 to generate a pre-printed report (an invoice for example). My WinForms application (.NET 3.0) has a screen through which the users can enter the report parameters (the dat...more >>

Problem: The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) The problem only occurs when I deploy the report. While in design I can run t...more >>

We have a database that has GUIDs that we need to use for looking up records in a database and displaying a report. Problem is that the user can select many records to be displayed in the report and we cannot use URL access as the querystring will be too long. We tried web services, but the ma...more >>

I have a very simple query in a Report, SELECT BeltType AS Grouping, SUM(CommittedSavings) AS CommittedSavings FROM Project.Project GROUP BY BeltType What I really want to be able to do is to create a list of Parameters that the user can choose instead of just Belt Type, i.e. ...more >>

I have a report that displays summary information, I've setup a subscription on the report that attaches a web archive copy of the report to the distribution list. When the report is rendered for the attachment in the middle of the result set for no apparent reason it randomly displays the v...more >>

Hi. This is an OLAP question. I have a dimension which is a father-son dimension. I built the cube in analysis server. In the analysis browser I can see the dimension fine, I hant my reporting services report to show that dimension. The problem is that the report won't show me that dimensi...more >>

Hi, I've a big trouble. According the documentation, the <Filters> section of a rdl file contains a collection of <Filter>. But there is no information how this collection is handled. It seem that the datasource is filtered based on every <Filter> with AND. If you are in the Filters tab ...more >>

Has anyone succeeded in specifying a report that should be drilled-to from a specific field? I have followed all the instructions I could find, but always get the error: The 'DrillthroughSourceQuery' parameter is missing a value Is it necessary to learn the gory details of .rdl and semanti...more >>

Hi, I have a parameter that get his available values from a query. I want that user will have the option to select from the values list OR to type in his own value. Is there a way to do that? Thanks, ...more >>

Using this table: ID Date Prod F1 F2 F3 __ ____ ___ __ __ __ 1 2007-02-15 11:13:09.890 ABC 5 10 20 2 2007-02-15 11:26:28.873 ABC 8 5 66 3 ...more >>

Hello: Is it possible to create cross-tab reports in SQL Reporting Services, similar to the cross-tab reports that can be created in Crystal Reports? Thanks! childofthe1980s...more >>

Hi , I am using SQL reporting services 2000 + SP2. In one of my report I am using custom .Net 1.1 assembly. I have given the reference for the same in the report. The report gets deployed without any issues. Recently we had to upgrade this custom assembly to .Net 2.0. Now when I try to d...more >>

Hi All, I try to install reporting services with a french version of SQL 2005 Express Advanced on W2003 std SP1 Install of SQL2005 OK When setup programm reach reporting service installation, i get an error message( in french) : "Le programme d'installation de SQL Server n'a pas pu récu...more >>

I would like to define a new field in one of my Report Model entities, by creating an expression that references some attributes of an entity related by a role. Is this possible? Also, is there a kludge I can use to handle the fact that there is no IIF function available? -- Helen W...more >>

I have a main report with subreports in it. How do I suppress the above message or capture it and display a friendlier message? Thanks. Cole ...more >>

How can reporting services be launched using the windows task scheduler? We need to run reports in batch mode at night and place the output in an excel file. We'd like to move all of these scheduled access jobs to reporting services. ...more >>

I'm wondering if RS2005 and ASP.net 1.x are compatible.... Thanks in advance. Chieko ...more >>

I am having a problem when I add a function to the Code window it isn't recognized. When I do a compile I get an error because the expression doesn't 'see' the new function. I have closed the .rdl, I have closed down Visual Studio. Has anyone else run into this problem? Thanks in advance. ...more >>

I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly over the last two days, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the repo...more >>

I have a table with a single column that spans multiple pages and wastes most of the page, leaving a blank area on the right. it is possible to "snake" the table such that the data fills in across multiple columns, the way newspapers print their articles? TIA - e...more >>

The "Setup Progress" window displays the selected components to be configured. After completion, the window displays a red x beside Reporting Services. On all the other results, you can click and view a log generated during installation. Clicking on the "Reporting Services" (that didn't instal...more >>

Here's my current query which works: select a.owneridname, a.name as account, b.new_total, b.new_yearname from filteredaccount a left outer join filterednew_customergoal b on a.accountid=b.new_accountid But I want to have a column in my results for new_total where new_yearname=2006 and ...more >>

Hi! Does anybody know how a currency value can be formated so that the currency symbol (=A3 or $) is not shown? /erik ...more >>

Can one specify the prder in which datasets are executed in the report? Thanks Sanjeev Order in which datasets executed ...more >>

Hi I am getting an error like An internal error occurred on the report server.(rsInternalError) The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use max pool size was reached Could anyone please sol...more >>

I have a simple query but I need the parameter to select the column name of the WHERE clause. SELECT col1, col2, col3, col4 FROM Table WHERE @colname = 1 The query builder is changing this everytime I set a parameter as a column name. Is there a way to do this? ...more >>

Hi all, Simple question: In Visual Studio I have 30 different reports under reports folder. Is there a way to set the correct folder \ URL for each report. These reports are not going all in the same location? I have only seen that you can set this in one place in solution properties ...more >>

I'm fairly new to SQL Server 2005 Reporting Services. Is there a way to export the entire raw dataset of a report to CSV? Often the "printable" version of a report has a small subset of the fields that are relevant to the user. I would like the export to contain several additional fields. I'...more >>

I'm fairly new to SQL Server 2005 Reporting Services. Is there a way to export the entire raw dataset of a report to CSV? Often the "printable" version of a report has a small subset of the fields that are relevant to the user. I would like the export to contain several additional fields. I'...more >>

Hello All, I've got a rather astonishing difficulty, and I wondered if any of you could provide some insight. I have many subscriptions set up, for a particular report, each providing a separate "vendor" parameter to the reporting engine. For most of these, all is well, but there are one ...more >>

I have a report that returns a column with number values that I want to round to 1 decimal place. I am able to do this using the format expression #,##0.0. However, some line items have a null value. For these line items I need to display "-". However, I need to do it using a format express...more >>

Hi, 1. If a table has a relation to itself example : employee id emp name manager id 1 Melissa 2 2 Steven 100 This means Steven is the manager of Melissa. Is it possible to make a report in Report Builder to have a list with of...more >>

With Reporting Services (SQL Server 2005), if you include a parameter with a data type of DateTime, you get a calendar control for the parameter on your report. How do you change the first day of the week from Sunday to Monday? Thanks, Craig...more >>

I have been selecting the column name textbox at the top of a column with an int value in sql server. When I go to Interactive Sort/Sort Expression, I just put the same expression as the one below the column name in the details "=Fields! qtySold.Value". The results is not what I was hoping for:...more >>

Hello. I've just created a new report and I added a prameter of type "DateTime". I didn't even used it in the query. Whan I preview the report I have the small calendar Icon. after I pick a time from the picker and press "View Report" I get the error: "the value provided for the report param...more >>

Here is the problem I am having. I have 2 instances of SQL Server setup on one machine. Both with Reporting Services installed. I am running SQL Server 2005 build 2153 for both, on Windows Server 2003 Enterprise. I have IIS setup correctly. I went through and configured each so that every...more >>