I don't get a Data Provider to access my oracle database. Can somebody send me his Data Provider? If you have a Provider accessing the SQL-Server you can send also this Provider. E-Mail: Data.Prov@Freenet.de I'm a novice in Report Services and Data Provider and search for days now for a...more >>

I have followed exactly what the MSDN white paper asked to implement the Form based security. I have created the useraccount database,registered few new users in there and then logged in the RS Report Manager and gave the browser rights to the new users on a folder and reports which all works ...more >>

I am wondering what account was used in my sql reporting services to connect to the SQL Server to add / change / delete the uploaded report? I have choose network service during reporting service setup and also input the SA account to create the report DB. However, I am wondering its authentic...more >>

I'm creating my first matrix based report, and find that some things that work with tables doesn't work the same way with matrix. My resultset comes from an MDX statement. It looks something like this ........................................Registered hours .............Amount ...................more >>

I have built a custom assembly, I copied it to the right folders and wrote some code to call the component. It works fine in preview mode, but when I deploy the report to another server I get the error: "error while loading code module 'x', version='x' ..." I feel I tried everything, copying ...more >>

I've got a monstrous beast of a report that has about 15 datasets. I've figured the only way i can imporve performance is if I could somehow put some of the parameterized data it pulls into a table that the other data queries could reuse. (Is it possible to use a temp table? I would think no...more >>

Hi I have a dataset with 2 columns Col1 is a list of dates and col2 is a list of Values On my report I put a filter on a list filtering out the dates with expressions. Such as = (colDate.value = myDate) But some time myDate does not exist in the dataset, so the after the filter the list ha...more >>

I am researching QueryPageSettings...But I cannot find documentation supporting the output bin and stapler. Thanks, Trint ...more >>

Hello, I am trying to color negative detail lines with the following. =iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")} It is working if the value is not zero. Some 0.00 values are black but some of them are red. What is problem? Jim. ...more >>

I am wondering if there is a simple way to tell the report server to not deliver a report if there is no data in the report. I have several reports which have table layout to display a set of data IF there happens to be data. One example is that I have a polling process looking at certain ...more >>

Hi All - I have heard that Hitachi has created a toll called RDL 2.0 that will take Crystal .rpt files and convert them to RDL - has anyone else heard\tried this product? Thanks Jim...more >>

Hi All, I have the following going on: A win 2k3 server running sql server and reporting services. I have IIS configured on it and can run reports internally on my network but when I try to access a report from the web I get nothing back. I can access my web projects but cant access and ...more >>

hi all, i have two questions : 1. is there a way to hide the toggleImage (+/-) from the report in case there is no data for the hidden group that expands when clicking the toggleImage? 2. is there a way to check from a textbox on a table header wheather a group in the table is expanded...more >>

I have a report showing a bar chart. I need to show a zero whenever I get a NULL value returned. I have read that I need to set the NoData property in the Chart control. However, I cannot find this property. Has anyone had experience doing this? if so, a point in the right direction would be n...more >>

I am a systems analyst for a state trial court IT team. I am currently focused on reporting software, and I am leaning toward Reporting Services (cost and product familiarity reasons) over Crystal Reports. Can anybody tell me (or point me towards) what advantages RS has over Crystal Reports?...more >>

How do I change SMTP server info AFTER installation? Thanks ...more >>

Hi, Is there any way to use SQL server to store and query geographical data? For example, be able to query all the records that fall withing certain geographical poligon defined by lat/lon coordinates? Rolling up zip code level information to the different levels of geography? Thanks....more >>

I am using Visual Studio .NET 2003 (with Reporting Services installed), and a cluster of SQL Server 2000 in a Citrix environment. I created a Business Inteligence Project, a Shared data source, added a new report and created a new dataset. I added tables to my Data tab, setup the relationsh...more >>

Does anyone know what the max upload size is? I want to save some documents with my reports, but I get the following errors: "Maximum request length exceeded." or "There was an exception running the extensions specified in the config file. --> Maximum request length exceeded." Thanks in ...more >>

Hi, I want to display a message such as 'no data found' if the query doesn't return any rows. Can anyone please help me? Thanks. ...more >>

Hi, I am trying to implement a custom security extension using the Forms Auth example provided by Microsoft. When i type in http://localhost/ReportServer, I can see the Logon.aspx page. But when i type in http://localhost/Reports/, I get a parser error saying -------------------------------...more >>

Hello, I have RS (client and server components) installed on a test machine (Win2k), with the SQL-Server database on a remote machine. I'm able to create reports, preview them with data, and deploy them with no issues. However, when I try to execute any of them from the Report Manager, I ge...more >>

Hi all, I recently installed Reporting Services 2000 on my server for the first time and it caused my existing web apps to stop functioning. I have a few custom dlls in the GAC and I had to end up re-registering them in the GAC and restart iis services. That fixed my apps not working. But now,...more >>

I am having a problem rendering a report in a PDF. The report has a fair amount of logic built in but the biggest problem is a list box that is the bulk of the report. The list box, as you can imagine, is to repeats groups of data...this works on the web page no problem...but when I try to expor...more >>

In my SQL db I have a date store as an int. I need to be able to convert this to a "readable" date/time format (such as 1/1/2005 12:34:56 PM) to use in SQL Reporting Services. How can I accomplish this? -- TimCinTx...more >>

I want to be able to use data returned in a stored procedure output parameter in a report. For example, I have a stored procedure that might look like this: CREATE PROCEDURE Example @outOrgName varchar(50) OUTPUT AS SET @outOrgName = ( SELECT OrgName FROM Orgs WHERE OrgID = 1 ) ...more >>

Hi - I would like to display the current values of an RS installation, i.e. the servername where the repository is installed, the database name, the username, connection type, etc. RSCONFIG.EXE looks like it can only set values, not show them. How can I do this? thanks...more >>

I have a graph that filters a DataSet for itself. I want to display a message when there are no rows after the filter. I can't seem to use ReportItems! from a textbox to reference the graph and the norows property on the graph does not seem to do anything. Does anyone know how to do this...more >>

Hi, Im currently developing various reports for my company. We have many different clients and different reports for each client. I want to develop a common website (just like reportserver) for all the reports and through NT-logon redirect a client to his reports. My question is: Is it po...more >>

Hi, I have few reports deployed on server. database is on some other server. I would like to allow all intranet users. But if user clicks on links provided in exported excel sheet, windows authentication should be enabled, so that we can filter outside users. I have enabled Integrated Wi...more >>

I have a group set up woth page breaks at the end. When I export it to Excel it generates a separate sheet (tab) for each page. Is there a way to get it to export into one sheet, with page breaks in the correct locations? -- -MT...more >>

I am getting a "Reserved Error" message when trying to import a relatively simple access report. Does anyone have any ideas on what issues with a report would cause the import to fail? Thank you ...more >>

Hi, i created a report that works fine, in preview it shows 3 pages, but in print preview it shows 4, i allready checked the sizes, Report.PageWidth is 21cm, left and right Margins are both with 1cm and body width is 18.75cm ... so 21-1-1 = 19 that is great then 18.75... what i miss ? rg...more >>

I have a series of reports and want to fire off a stored procedure to update a "Printed date" column in my database. I don't want to do this from the dataset that populates my datset as I only want this to occur if the report is successfully generated. Is there any way I can do this with the s...more >>

Hi folks, Is there a way to export the report output to MS Word from reporting services directly ?...more >>

The data structure is fairly simple Table 1 contains information about a property and the total area of it’s land Table 2 contains rental payments made on that land I need a report that shows “Property Name” “Total of Rental” “Area of Land” I have this information all OK ...more >>

i installed reporting services on the same machine where i insatalled SQl server. i did some sample reports in visual studio.net 2003. initally when i try to deploy it,iam getting 'cannot connect to http://localhost/report server.' one more insteresting thing is when i browse to http://local...more >>

I want to make my reporting service generate a report periodically (e.g. Weekly) and post the resulting PDF file to my sharepoint share located in the same Windows2003 server. How can I do this? ...more >>

hi, I would like to add the label of the bar as tooltip. Is there any way around for it?...more >>

I need to get the pathname dynamically to plug into a hyperlink since the servername will change between development to production environment. Here is an example of the desired link: http://servername/webapp/page.aspx?id=123 Here is how I would like to set the Jump to URL field: Jump to U...more >>

I found many hints that customer parameter interfaces are a possible solution for several problems. But I can't find one piece about how this can be done. Not in the documentation, not in this news group and not in google. I'm really investet many time, but don't find anything. Can one g...more >>

Hello, In the page header I have a textbox whose value I want to change based on the parameter. If param=1 then I want the value of the textbox to be Invoice otherwise I want it to be 'B/S'. How can I change the value of the textbox? Thanks...more >>

Hello All, I have to generate a report based on parameters. And each part of the report depends based a particular set of parameters. Is there a way to hide the parts of the report that i dont need to show ? Thankx Bofo ...more >>

I use some editor to edit the data in the backend. I view the report in sharepoint portal using url access of the report in reporting services with the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data of the report using an editor, I want the report to be updated with the new d...more >>

I'm really interested in Reporting Services, but I can't seem to find any documentation on how to write reports and utilize it without Visual Studio ..NET 2003. Is there any way to do that? ----- Chris Shipley HSI System Administrator CAFCA, Inc. Hartford, CT http://www.cafca.org chriss@...more >>

I was able to convert a report to PDF format and save it on my C drive. I'd like to know if there is a way to print a report without user interface. Thanks....more >>

Hello all, would like to know if its possible to have a company logo on the parameters bar that appears above the report ? Thx Bofo ...more >>

Hello, I am experiencing an issue with exporting to Excel - on some reports the last row is missing. Is there a hot fix for this and/or is this addressed in SP2 for Reporting Services? TIA. -- Chris Hanley...more >>

What arer Heirarchical Parameters?...more >>

When I try and run a report in mom2005 I get the following message: Reporting Services Error -------------------------------------------------------------------------------- An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for da...more >>