Hi, I'm new to Reporting Services. However, I am sa on the reporting services database server and also admin rights on the server. I deployed my report to the reporting services server without errors, however someone else (not sa equivalent on the database, and not admin equivalent) cannot d...more >>

Just a general question. My understanding of shared data sources is that they are configured in the web-based report manager. Now, what will happen after a redeploy of that same report? Will the use of the shared ds been overwritten? Does the use of the Project Level property OverwriteData...more >>

Hi, Is there anyway i can show tool tip texts on the bar charts? like when i place my cursor on the bargraph - it should give me the value. thanks Ramani...more >>

I would like to do the following in a RS dataset select fnRegProgress(regId, @beginDate, @endDate) from regulations fnRegProgress is a SQL server user defined function but it could also be a stored procedure. I'm passing in RS report parameters as function input parameters. Error is "syn...more >>

I have a report that I need to check the actual URL to determine some hyperlinks within the report. Reason being is that we have two identical copies of a single report for security purposes. This report have links that need to be different depending on where the report is. Instead of having t...more >>

I have a report which takes few parameters. I have set some defalut value for them. The default values work good when i Preview teh report. But when i deploy the report to the Report Server, the default values get lost and the user has to type them all again. Any clue on how to solve this issu...more >>

Hi, I would like to get the symbol for the currency under the environment the report is being run.... Is there a way to do it? For example, in the US it would display a $ in UK, it would display either the Euro or the pound symbol etc.... Thanks...more >>

Hi Since reporting services does not come with a waterfall graph, I was trying to use a stacked bar chart and customize it to resemble a waterfall chart... I would like the color of the bottom portion of a stacked bar to be transperant so that is is not visible in the chart. The only piece i...more >>

Hi there, Since enabling anonymous access for the virtual directory 'ReportServer' in IIS, I can no longer access Report Manager ('Site Settings' link goes away). The reports that users can access are not data sensitive, so I would prefer not to use any type of security mechanism (e.g. for...more >>

From sample posted, I tried the following but results in #error. Any suggestion? Here is the actual expression: = Iif(Fields!cprice.Value - Fields!ccommission.Value = 0,0, (100 * Fields!ccommission.Value/( Fields!cprice.Value- Fields!Average_Cost.Value)))...more >>

I have a report that consists of a table containing invoices grouped by Customer. I'd like to keep all invoices for any given customer on the same page, but without needing a page break after each customer (each page can fit about 12 or so groups on it). Does anyone know how to do this? ...more >>

Hi, I have a custom aspx page which access RS (Reporting Services) using the webservice interface. I'm using the delegation (defautcredentialcache) to send the user authentication to RS. RS and my web application are on the same server. this works fine in 2 cases: * NT authentication ...more >>

Hello All, I get the following error when running the sql stmt below. "An error occurred while reading data from the query result set. Syntax error converting datetime from character string" The variable is declared in the report parameters as an integer. The code works fine in query analyz...more >>

I have one production SQL server 2000 with Reporting services SP2 installed on it. I have a redundent IIS 6.0 just purchased. I went to install RS on it and point it to the production machine but it won't install because the CD I have is RS SP1 which isn't compatible with SP2. How can I get...more >>

I'm having a problem when I have a text item in a table - the text is bold and underlined; preview/print preview looks fine; but when I export the report to PDF, the underline extends beyond the text to the right. If the text is normal weight, the underline is fine. Is this a known issue? (m...more >>

My question: Does the end-user reporting tool (report builder) in Sql Server 2005 exist in the Standard Version or is it only in the Enterprise Version? I have found a couple of conflicting articles on the web. Thanks in advance....more >>

I wrote some code in the VB Code Module (Menu Report/Properties tab Code). Now I can't enter more characters. It works until a specific amount of characters and not more. Is this possible?...more >>

I'm trying to use the following expression to hide various text boxes in a report depending on the age of an invoice: =(CType((Fields!InvoiceDate.Value), DateTime).Subtract(Now).Days > 30) And (CType((Fields!InvoiceDate.Value), DateTime).Subtract(Now).Days < 60) The expression seems to be ...more >>

Can a report be exported to an Excel sheet directly without showing it into my web application? Thanks a lot! :)...more >>

I have a client MS Access 2000 application that calls a reporting services report (via the url). I am able to pass parameters, render the report to pdf without an issue. What I would like is to have an additional option that would allow printing of the pdf rendered version without user inter...more >>

I am porting a ASP reporting application to use 99.99% SQL-Server 2000 Reporting Services. How do i add a parameter value to a textbox which is a Jump to URL?? I want to jump to a webpage to enter data for a specific invoiceID. One of my reports is a debtors arrears overview. The user can ...more >>

hi, It's me again, i'm searching a radar component for my report (for MS SQL reporting services) but i can't find it; where can i find this kind of chart ? Thanks in advance aVr...more >>