Hi everybody, I have been evaluating the usefulness of Report Builder as an Ad-hoc query tool and have come upon a most unpleasant issue: hopefully someone will be able to help and explain whether this is the designed behaviour or this is a bug to be fixed. The problem shows up when interro...more >>

g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl The expression for the chart 'chart1' has a scope parameter that is not valid for RunningValue, RowNumber or Previous. The scope parameter must be set to a string constant that is equal to the name of a containing group w...more >>

When I make a dataset as parameter how can I make an ALL value which doesn't select the single values but all values instead. Like Month: all, jan, feb, etc. when I choose all it's supposed to ignore it in the where clause, I tried with case but it didn't work out, any clues on this one ...more >>

I'm having a serious problem with the Reporting Services designer. I have a report with 2 parameters offered as dropdown lists. The first time I go into the designer, I can change the value of the dropdownlists (with some flashing behavior that doesn't make sense) and execute the report. Howev...more >>

Is there a way to store an expression inside a table, and have the expression being pulled from the table to execute during run time? I want to dynamically create an expression based on the value of a column of the table. Using the IIF statement will work but it's going to be a very long neste...more >>

I've got an amount field in a report where I want the values to have the sign (if negative) on the right. But I also want the numbers to line up properly. I can't seem to find a way to format this. In Excel, you'd use a format like #,##0.00_);#,##0.00-. But that does not quite do it in Reporti...more >>

Hi, I need to format part of an expression as money. The expression is ="Total Aged Balance : " & SUM(Fields!Invoice_Total.Value). How do I do that? Thanks Jerry ...more >>

We use Oracle database and SQL server 2005 Reporting service Beta2. I made a simple SQL report using query: select sum(spend) from travel_cost where department in (:p_dept) I set parameter p_dept to be Multi-value: dept1 and dept2. When I run report, if I only select dept1 or dept2,...more >>

Is it posible to put the Globals!PageNumber on a table, I know it gives an error, but is there any work around? Thanks in Advance, Fabian von Romberg...more >>

When attempting to call the Fireevent method of the reporting service I get "The permissions granted to user 'xxxx' are insufficient for performing this operation." The user in question has the following roles on the folder where the subscriptions and reports exist: "Browser, Content Manage...more >>

Ok, I have tried for days to get certain textboxes and tables in page body to repeat on multiple page reports...Will not work. Any help is appreciated. Thanks, Trint ...more >>

Is there a way to hide the address bar, while exporting the reports to PDF or Excel. Currently when i click export it opens up a new window with the address bar containing the whole URL including the parameters i am passing. ...more >>

I have a field that dislays time (e.g. 11:37 AM). The value of this field is =Fields!Time_Received.Value This works fine and RS displays the correct time values. However, if I export the query to Excel the cell format defaults to Custom and the data displayed is all incorrect. Excel will sh...more >>

Hello, I have a Reporting Services report that gets exported to Excel. A DTS package (running on SQL-Server 2000) then attemps to import that Excel file into an existing table. Occasionally, I receive the following error: Error Source: Microsoft JET Database Engine Error Description: Exter...more >>

I am having problems exporting to excel. When I try to export a report from the SQL Server Reporting Services website the conditional color formating doesn't come acrost. The nonconditional color formating comes acrost just fine. If I try to export the same report from Visual Studio the for...more >>

Hi, I have a table with 100 rows in the following format ------------------------------------------------------ country name state name city name ------------------------------------------------------ USA NY NY USA NJ Newark USA FL Orlando USA FL Miami USA CA LA USA CA SF Ch...more >>

Ok, This is serious! I have to check for SOLD TO and SHIPPED TO addresses...if they are equal, the SHIPPED TO is left blank. Here is the expression that works great (If they are EXACTLY THE SAME): =IIF(Fields!address.Value = Fields!shippedAddress1.Value,True,False) Here is the problem: We con...more >>

Hi, Is it possible to display the Category Fields diagonally ? Thanks...more >>

is it possible to use the case statement in the reports.plz give the example thanks...more >>

I have developed my Custom Data Provider extension by using the ample provided by Micorosft Reporting Service. In my extension I am using another thirdpary dll UltEik.dll to fetch informtaion from Ultimus Soaftware. My report is working fine in Designer but when I am deploying it to Repor...more >>

Hi, When I upload reports to the report server they are displayed with a button along the top named "New Subscription". One of my colleagues does not get this button when he uploads his reports. We would prefer that the button was not available. What is causing this button to show up and...more >>

Hi, I'm using the Visual Studio designer to create my RS reports. When I add a new project to the solution, the new project wizard allows me to choose ODBC as the datasource type I want to use. However, I amn't given the ODBC option when I try to add a datasource to an existing project. I wor...more >>

Hi, i just created a form using the reporting service and try to fill in one character each in one textbox from a string data field. for example address string "abc def" put "a" in textbox 1, "b" in textbox 2 and so on including the space until all seven textbox filled. Can anyone please a...more >>

I have a doubt on group expressions. Can anyone tell me the significance of creating a group in a table where the group on expression is =1? ...more >>

Hi, Is is possibe to author a report for distribution over an Intranet using Reporting Services and provide slice and dice functionality to the user in IE? Analysis Services will be used for the Cubes and hopefully Visual Studio for constructing reports. Can this be achieved without lo...more >>

hi all We have a reports with parameter but I would like use subcription but is = no avalilabe (is ok. if you want parameter how you use subscription )well = i have a solution use a default parameter.=20 So I would like use Parameter=B4s reports with suscription using default = paramerter ...more >>

Has anyone created their own reporting application to work with Reporting Services. We require a good deal of customization of the display (especially the parameters) and I have not had any luck customizing Report Manager to meet our needs. So, I am looking at creating an asp.net page with a us...more >>