I just started with reporting services. I created report that has two groujping items in the table. Everything works fine just I always get second row for the top level group on the second page. This doesn't make any sense to me 1) I am using HTML rending and I don't need all this pages 2) the ...more >>

Is there any way, within the admin to specify that yesterday and today for start date and end date. Someone suggested =Today.AddDays(-1) but I don't think they meant in the admin. Could you tell me where i am supposed to apply this default. Regards, Bryan...more >>

Hi , I have some Reports that don't always return data. I want to check if the report returned any data and if it does then send it out the plp on the subscription list. What would be the best way to approach exception reporting In RS ? ...more >>

Hi I have a function that checks if a user is in a Windows domain group. (John is in Administrator group?). What kind of security permissions is required to execute my function? <????????)> _ Public Shared Function UserIsInGroup(ByVal Group As String) As String Dim currentIdentity As Windo...more >>

I have been using RS Books online.I just want know apart from this is there any other book available out there that would give me a knowledge on ADVANCE progamming in RS. or is the RS books online the best. any suggestions are welcomed...thanks ...more >>

Can someone give me some guidence? I am trying to set a report datasource to a existing datasource and I keep getting an error of: rsMissingElement 400 The required field DataSource is missing from the input structure. http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc...more >>

Hi, We are exporting all of our reports to pdf for printing. If I export a drill down report at the highest level of detail, it displays exactly as it looks in reporting services. However, if I go back to the report and drill down a level, then exporting to pdf, it still displays the highest leve...more >>

Hi We are currently contemplating a Crystal Systems, but I came across MS Reporting Services. Any ideas on which is more superior or MIS and CRM data? Kind Regards Rikesh ...more >>

Is there a way to avoid having RS do word wrap (in a textbox) in the middle of a word? I want it to wrap, but I'd like it to wrap on whitespace rather than just tearing a word arbitrarily into parts. Thanks in advance, Bill ...more >>

I'm trying to set up a textbox in a report so that the text is displayed vertically. I've found the Advanced button and the tb-rl setting, but what I need is "bottom to top" rather than "top to bottom". Of course there is no such setting available. Is there a workaround? Regards, Bill ...more >>

Hi there I have a problem with displaying the columns of my report. I have a stored proc that creates my columns dynamically based on the data, eg TonsHarvested1998, TonsHarvested2000, etc. These are sample column headers returned by my proc. I have no idea as to how I can display this data...more >>

Hi, I have a Table with 2 headers... and the report spans multiple pages. I need one header to be repeated on each page and the other header not to be repeated on each page. Now, if I set 'RepeatOnNewPage' property of one row to 'false', it automatically changes the same property of the other he...more >>

Is it possible to control the appearance of a table cell at run-time? - For instance, if the cell has a blank value i want to turn off the "top" border on the cell otherwise the report displays the borders even though the row is blank. Is there any way to handle it through expressions? thanks...more >>

I have implemented custom forms authentication with Reporting Services and everything worked fine. I was able able to deploy reports from Visual Studio 2003, VS would prompt me to enter a valid UserID and Password. Recently, I have changed workstations and installed a new copy of visual studio ...more >>

I have a tablur report like this Product @Year1 (Price) 1 1.00 2 2.00 3 2.00 I want to add another column @Year2? Product @Year1 (Price) @Year2(price) 1 1.00 1.34 2 2.00 ...more >>

Hi there I am trying to create a report with a proc that has dynamic column headers. eg TonsHarvested1998, TonsHarvested2000, etc. The problem I am experiencing is that these columns are not displayed in the fields editor box and I have no idea as to how I can get them displayed in my textb...more >>

Hello, I have a server that provides images (image server). These images are accessed by my report. In order to improve the security access to the images, I need to set the authentication on the image server. Reporting Services sp1 doesn't support it (as declared) then I'm looking for an altern...more >>

I'm new to RS but how does one deal with encrypted data within reporting services. That is we have a table that has encrypted data. Is there fuctionality within RS that allows the decrypting of that data in generation of the report. If there is, someone point me in the right direction. ...more >>

When I call the render method: reportPath = "/POSReports/Region" format = "PDF" result = rs.Render(reportPath, format, historyID, devInfo, parameters, _ credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs) I get the following er...more >>

Hi Ng, I was wondering if there is a way to change the colors of the bars in a chart. Or the colors of the pieces in a cake chart? Thank in Advance G. Schmelzer ...more >>

I can configure a working subscription to e-mail through my SMTP server when sending only the LINK to a report BUT NOT if I attach the report to the e-mail in say excel or xml format. I have tested using a command line SMTP utility and have been able to send both a plain text message and a pla...more >>

Hi all, is it possible to control row output on a report? We are using MS Analysis Services Cubes as datasource and experience some difficulties displaying ragged hierarchies (parent child dimensions). Reporting Services will create a subtotal for each group, even if that group only conta...more >>

In SQL Reporting Services, Is there anyway to create a parameter in which a user can be prompted to choose multiple values from a list? Ultimately, the multi-selected values would be passed to the Dataset query as an "IN" qualification. Example: SELECT first_name, last_name FROM employee...more >>

Is it possible to hide or disable some fileds of parameters on report? Thanks. ...more >>