I'd like to produce dynamic reports via SQL Server 2k5 Reporting Services that can be rendered in a web browser. However, I don't want anything to do with IIS or a web server. From what I've heard, previous version of SQL Server Reporting Services needed IIS. Is this true for 2k5? Thanks,...more >>

Hi Guys When exporting my report to excel my field text gets exported as double lines. Does anybody know a way around this? eg: Line 1 Line 2 turns to Line 1 Line 2 Thanks Kez...more >>

Hello all: In SQL Server 2005 Reporting Services, when I create a subscription and specify "Report Server E-Mail" as the delivery option, it has the "To:" field greyed out with my name in there. Where is reporting services getting this value from and can it be changed? Thanks in advance...more >>

can somebody pls. help me with the following report parameter defaults? for a monthly report I need two dates as parameter defaults: The first day of the last month and the last day of last month If I run a report on - let's say March 1st, I can get the last day of the last month with ...more >>

Hi, I have a report that takes about an hour to run. When I run it, it runs for an hour or so with "Generating Report", then the result page is the standard IE "Action Canceled" page, and there is a javascript error. The javascript error is Permission denied. All other reports running on thi...more >>

I was wondering if there was an easy way to do an alternating item color in the details section like you can in a DataGrid? Thanks! ...more >>

I have a report with many subreports, and I'd like to set the Visibility.Hidden (=true) attribute of the subreports depending upon a report parameter. something like this... iif(Parameters!Type.Value=1, subreport1.visibility.hidden=true, subreport1.visibility.hidden=false) any help is app...more >>

In the Reporting Services 2005, is it possible to introduce custom functions in addition to all the built-in VB Script functions? Something similiar to introducing assemble in T-SQL. Thanks, Bing...more >>

Hi, I have a large number of parameters defined which can be null and I have to generate WHERE clause based on valid parameters, this makes things complicated becuse I have to add "AND" to the WHERE clause depending on availability of the parameters, the number of validation I have to do inc...more >>

Hi, I am having a problem with page breaks in a report that I am writing. I have set some conditional logic on a Group to only show the group under certain conditions. The logic works fine, but it creates a subsequent problem, and that is that all of the group page breaks are eliminated (I wa...more >>

I get the following error when I try http:\\localhost\ReportServer or http:\\[servername]\ReportServer (from a remote server) An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance ...more >>

I have a report with pie chart and a table. When i try to export to HTML with OFfice Web components - another browser opens without asking to "Save" or "open" and it jsut opens up the report again. Is this is wha exptected ? Thanks...more >>

Hi, I am trying to access deplyed report without parameter bar hidden on load. Is this possible? Thank you...more >>

I've installed and deployed the AdventureWorks Sample reports to Report Manager in RS 2005. When I click on any of the reports, the report just spins away and never returns the report information. I eventually (10 minutes later) just stop the browser. I made sure I have permissions to all ...more >>

Has anyone ever seen the print icon not show up in the top toolbar in Reporting Services? Normally, the print icon shows between the refresh button and the help button. We saw one instance where the print icon was not showing: it was just the refresh and help button together. Does anyone know wh...more >>

In chart for values i have two values that is Target values and actual values. My target is 80 % and i categories based on the date [1-31] that would be displayed as x-axis values. And in series i use description for providing different circuit description. But the problem when i use two...more >>

Hi all It's possible to export to excel without clickable links ? There is any commercial or open solution ? It's very important for me... Regards M.Repeæ...more >>