We have a report that accesses a SSAS cube and has several prompts. We are having a few issues with these prompts: 1) All but the first prompt is greyed out so you have to take them in order. The users would like to be able to take them in any order. 2) After selecting the information from ...more >>

hi, Iam new to sql reporting services and i've to finish an application on it asap.The application is something like it.I've to generate a report with 4 input parameters.so i created the rdl file and uploded it to the report manager.But i've to create a web application with 2 dependent drop downs f...more >>

Hi guys, I try to find for an answer for this problem, but to no available, it drives me crazy now. I am getting a page break on each details row in a table. The table has 3 headers, one is a subreport, and a details row which contains a subreport; there is no footers. The subreport in the...more >>

Sorry, still new at this. Where can I change the title of the report that shows up in the report server. I tried to change it and when I did and redeployed it it showed up under the old name. I figured there was a better way and place to change it. ...more >>

Good afternoon I have a hidiously complicated union select statement that i am feeding in to a chart. This creates two series and two data fields, some of these combinations dont hold usefull data and so i would like to hide them. e.g Series 1 and data field 1 = good data Series 1 and data f...more >>

I have a textbox that's several lines in height. I want to put several lines of text in one textbox to get single spacing. I don't want to use multiple textboxes, as I have to push multiple textboxes so close together it looks like a mess. In the first line below, I actually need the static...more >>

Hello, I am getting an error with Reporting Sercvices 2000 when I run my report which typically takes 30 mts in Query analyzer which pulls 5393723 rows. I have tried with the combination of MemoryLimit of 0 and MaximumMemoryLimit of 80 and also combination of MemoryLimit of 100 and Maximum...more >>

I have the following in a table : =Fields!Name.Value & vbCrLf & Fields!Description.Value and would like to set the Name to "Bold" and 10pt and the Description to "Normal" and 8pt. I have other columns and don't want to split them up or create another row. Is this possible or am I reaching......more >>

The reporting services charts always come in the same default set of colors. I know this can be changed by modifying the color palette but what I actually want is to set the color for each item programatically. The idea is if for instance I want to show the sales charts for specific cities the...more >>

When I print my report, every other page is blank. I have resized everything down to half the page, played with margins and object sizes to see if I just had an oversized item, but to no avail. Is there a setting or somthing that does this? I am at my wits end! thanks!...more >>

I dont seem to be able to add page breaks to text boxes. does anyone know why, or a way around this? thanks!...more >>

Is there a way to put a border around the bars in the cart. I didnt think there was, but I hope to be mistaken. Thanks ...more >>

I am new to Reporting Services and cross-tab reporting in general. I need to create a basic report that has dates across the top and reps down the left. The data I would like to see reflected is the number of entries created in the table by rep by day with cross sums. What I am getting is a r...more >>

I am trying to create a data source view that includes a Fact table and several related dimension tables. One of my dimension tables is quite small and uses a tinyint PK. For some reason when I bring this table into the model it thinks the PK is a System.Int32 datatype and won't allow a rela...more >>

I've been seeing an issue with several of my reports where it will refresh the page after any parameter is entered or changed. Has anyone else witnessed this or found a way to keep it from refreshing until the 'view report' button is clicked? Cheers, Ben ...more >>

Hi , I have a report with table object. The report needs drill down functionality and hence I have added two groups to the table. The data is based on OLEDB provider for Analysis services 9.0 and is fetched with MDX query. Now my MDX query is written in such a way that all levels of data a...more >>

I'm trying to demo accessing a report using the web reportviewer control and it works fine on my regular system but gets a 401 access denied when using my laptop. The report runs fine in Visual Studio but this code: Dim RVC As New ReportViewerCredentials("user1", "pw1", "") rv1.Server...more >>

Hello everyone. Does any one knows if it is possible to create reports in MS Reporting services connected to Oracle DB in Visual Basic 2005 Express edition? If any one has done it before a few simple instructions will be greatly appreciated. Thank you. ...more >>

Anyone else have issues with subscription emails after a 2005 migration? We are getting an error on about 50% of our subs with a "internal error has occured o nteh report server." I tried to update a schedule and test again and then get a "The report server has encountered a configuration error...more >>

I'm trying to get the following custom code to work but get the error: "There is an error on line 3 of custom code: [BC30205] End of statement expected." I really don't see it, but then I am new to this, so any help would be appreciated... Public Shared Function SetBgColor(ByVal Value1 As S...more >>

Good morning, all! I have a report with one field that is so long the we want it to appear on its own line: Field1 Field2 Field 3 Field4 Field5 We want Field5 to be as wide as the combined width of all four fields on the first line. How do I do that? Currently I h...more >>

Hello Gurus, now, this probably some kind of school-boy error, but I'm trying to set up a report where there are a two drop downs (start year and end year) I'm using an Analysis Services cube as the data source, and can create the report fine with the parameters being user-selectable, How...more >>

Hi, I'm new to reporting services. I'm trying to use the TOP N option to create an MDX TOPCOUNT() like result set in my report. I can't figure how to build an expression using Top N. I'm on data table -> propoerties-> Filter tab. I would appreciate any help. Thanks Supriya...more >>

hi, is it possible to make "dynamic reports" for users with different user rights. depending on their rights one user sees all the columns and another one with less rights sees just the first column? thanks ...more >>

hi, is it possible to use the paramter values - entered by a user - as parameters for another dataset? thanks ...more >>

Hello everyone. I'm trying to work with Visual Basic 2005 Express Edition and Reporting Services. I downloaded and installed sample project, but no matter what I do I can not see reports in designer. They openning as xml files only. Any idea? Thank you, Yuri ...more >>

How do i add eith AM or PM at the end of the date in the expression of a textbox this is what i currently have format(Globals!ExecutionTime, "dd/MM/yy hh:mm") but i want it to output 02/08/06 5:02 PM thanks in advance...more >>