I get the following error in Report Manager when running a report. The report runs perfect in visual studio when I preview it. Reporting Services Error _____ * An error has occurred during report processing. (rsProcessingAborted) Get Online Help * The sort expression for the gro...more >>

Re-Post Can somebody advise me if there is a known 'issue' with RS in that it is best not to try and build parameters that are to be used as Guids? I am getting: "Default value or value provided for the report parameter 'year' is not a valid value" TIA My rdl snippet: <Query> ...more >>

I've noticed in the expression editor that pasting rich text (like copied from a web page) preserves the formatting. This makes stuff look really screwed up in the expression editor. I noticed this copying stuff from this newsgroup and pasting it into the expression editor....more >>

Hi, After installing RS on Windows 2003, opening RS reports (using Report Manager or not) pops up an authentication login dialog. How can this be avoided? We wish to be able to open reports without requiring authentication ...more >>

Hi I have written the following Union Query to Calculate a list of commonly used dates for use as StartDate Values in my report. I was wondering if it is possible to allow the date to be manually entered into the parameter field as well as been able to select the common inputs from a dropdo...more >>

Is there a way to sort columns dynamically in a table? I have a drill down table where I would like to give the users the ability to either click on a button or a click on a column name to dynamically sort by a specific column. I used to have three separate tables, each sorted a different ...more >>

Sometimes when a report is deployed after changes, the changes do not show up on the Reporting Server, however the changes do show up in VS. Changing the report and deploying again have no affect on the displayed report. Also, sometimes a report will display one way on the server, but be a ...more >>

I have a simple report where I want to have a dropdown list box that is populated from a sql query (no problems here). Then I want to take the value from the selected parameter to lookup another value in a query, then pass the returned value to a stored procedure as a parameter. ...more >>

I'm trying to format a text box color using an expression = (Field!Name.Value < 0, "Red", "Black") but system send this error The color expression for the textbox 'Field name' contains an error [BC30451] name 'Iff' is not declared. Please let me know what can I do...more >>

I am trying to impersonate a user through the web.config of the webapp that I'm using to view reports. Reports are pulled back through the ReportViewer object, and so, pulled back through an IFrame. I impersonate the user which we set up in the report server, so that we can bypass windows aut...more >>

can somebody pls help me with the formula for a datetime parameter that is say 7 days past today. this will be used as the end date parameter. my start_date parameter default is =(today) thanks...more >>

I have a report that I'd like to display across the page (as opposed to down as is default). Can someone tell me if there's any way to rotate a table? Thanks in advance, Dunc ...more >>

I have a pretty simple report that uses two data sets; one for header info, and one for detail info. In my header, I want to display a concatenated version of the reported-on user's first name and last name, and am using the expression: =First(Fields!FirstName.Value, "Header_Info") & " " & ...more >>

For some reason the expression for the hidden property of a text box =iif(Fields!FunctionalResults.value is system.dbnull.value,False,True) isn't working. It's always not showing up. Anyone tell me what I'm doing wrong? Thanks, David ...more >>

Hi, How to use Analysis Services with reporting Services?...more >>

I have a report that I've developed that accepts several datetime parameters. In the Report properties, I've set the report Language to English (United Kingdom). I am calling my report via the Web Service from an ASP.Net application. The ASP.Net application Culture and UICulture are set f...more >>

Does anybody know if the next version of MS Reporting services will include a way to export directly to word or rtf? ...more >>

I've read already a lot of threads, dealing with several databases on different servers as data source. They all recommend to use linked servers. But what, if we have to deal with Access databases?...more >>

I am converting a report from a Clipper application and the existing reports shows States with some additional information in a format I am finding hard to reproduce. On first glance the report looks like a simple tabular format. There are something like 10 rows in the table with 3 columns. Th...more >>

Hi, I'm trying to display a basic report in an aspx page using the ReportViewer component. The report displays but a graphic and simple chart are not displayed. It seems like it has had good try because link regions in the graph do actually work, but no visual chart. Any ideas! ...more >>

I have a report from a legacy system that I am recreating in Reporting Services. The report is 6480 pages of information with about 35 rows on each page and it takes about a good 5-10 minutes to generate the report in Reporting Services. The real problem occurs when I try to export the report to...more >>

What I have is 3 columns. The first and second are data from a database, the third is a conditional difference of the two. That is, column 3 is C1-C2 if that is > 0, else it is 0. So I have: C1 C2 C3 1 2 0 2 1 1 I can get that to work fine, using Iif(). The probl...more >>

I've got a dataset which returns a single field. I've put the field in a table, and what I want is for that table to display as two columns per page, instead of just one. Top to bottom, left to right. How do I do this? -- ...more >>

I have a non-complex list of about 20 fields in a WSS site. I want to use the list as the data source for some reports in reporting services. Can I do that? If so, how? Will the format be correct? Any help would be much appreciated........more >>

Hi there Does anyone know how to hide the banner on the top of the subscriptions page when you are viewing via a URL. I have managed it in the reports by setting the parameters to false etc but cannot do it in the subscriptions. Thanks in advance Dave ...more >>

When I try to execute my script using the rs command i can’t Generally I use to type: rs –s http://myServer/reporrserver ; –i myScript.rss but they are some predefined values that don’t allow me to execute my command because it tries to look for the server: htt...more >>

In the Report Designer, I insert some page breaks after data regions. When exporting to excel format, the pages are displayed as several worksheets in the excel. But I found no way to specify the name of worksheet in Report Designer.Is there any ways to do that? Thanks....more >>

Hi, The parameter OmitFormulas seem inefficience. All formulas in Report Designer are transforming to data in Excel and not to formulas. I'm using SP1 and Excel XP. Thanks Tonio (french)...more >>