Can we declare any variables in the sql server 2000 reporting services? because I need to make an array for my tables, for ex: in my database(sql server) it has many tables like tble27,tble28,tble29,tble30.. etc. all of the fields inside the tables are the same. every table has name,age,sex...more >>

Windows XP Pro Client w/ Visual Studio .net 2003 installed Windows 2003 Server Domain Controller w/ SQL 2000 report Services Installed and functioning. Receive following error during RS install, will not allow me to continue? System Check Results IIS is either not installed or not co...more >>

Hi, I apologize for my ignorance, but does anybody know how to dispaly HTML data in reporting services. I have a table storing HTML source data in one of the fields and i would like to display is without all the tags. Would it be possible? Any help would be appreciated. thanks W...more >>

Have a cell in a table that is being populated by a field in database that contains the date and time in this format mm/dd/yyyy hh:mm AM. I need it to be the otherway around ie. dd/mm/yyyy hh:mm AM/PM. But when i try and use =Format(DateTime.Value, "dd/MM/yyyy hh:mm") is get an error saying...more >>

What do I need to istall to be able to create reports? Do I need to install VS 2005 as well? thanks ...more >>

Hello, I am new to Reporting Services and am having the following error when I try to view any reports through report manager on a test box. Directory Listing Denied This Virtual Directory does not allow contents to be listed. I did not set up reporting services on this box, and have only b...more >>

When I try to export a 2400 pages report to pdf get the reporting services error: exception of type Microsoft.Reporting.Services.ReportRenderingException was thrown. index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index. The repor...more >>

We are attempting to install SQL Reporting Services using a network service account for the ReportServer service. This configuration will fail without installing QFE 859. There is allegedly a hotfix installer which will apply the necessary hotfix, but the Microsoft KB articles go in circles ...more >>

In my data set I want to use a where clause with IN. E.g where name in ( 'a', 'b', 'c') But I don't want to hard code the list I want the user to enter it as a parameter. Does SSRS support parameter lists? where name in ( @names ) -- McGeeky http://mcgeeky.blogspot.com ...more >>

I have several reports in RS, a few of those reports have data driven subscriptions (DDS). I now need to move those reports, along with the DDS to the new server that's located off site and I don't have direct access to the new server. How can I achieve this? Thanks in advance...more >>

How can I pass a null datetime? Exampl http://localhost/LUSReportService/RenderPDF.aspx?ReportName=MeetingNoticeMemorandum&RequestedBy=LISSHOC&Legislature=79&Session=R&CalendarDate=6/10/2005%2012:00:00%20AM&CalendarTime= ...more >>

We recently installed SP2 for reporting services. Everything seemed to work fine for about 2 days, and now I'm getting errors and I can't access reporting services at all. Accessing http://server/reports gives the following error: Unable to communicate with report server. Please verify that...more >>

We currently have a SQL 2000 database and we want to write some reports to access that data. If we write reports in 2000 reporting services, will they work on Yukon later? Another option is to install a Yukon DB, replicate the SQL 2000 data there and run reports off of that server. Is this do-...more >>

I saw this header from back in April, but it has since been expired from Microsoft's news server. Anywho, for some reason, my trace log file for the ReportingServices Service is filling up at about 1 Mb per minute. I have dropped the trace level down to 2 for now, but this does not fix the cor...more >>

Hello All, Hopefully this is an issue with a simple solution - I've searched around though and can't seem to find an answer. In on RS Solution I have multiple reports. Is it possible to take a datapoint from one report and utilize it in another report in the same solution? TIA, MYK ...more >>

Hey all, Is there anywhere that I could download trial version of SQL 2005 Reporting services alone...not the whole junk of SQL Server 2005. I need just the Reporting services. another question is I have SQL 2005 Developer Edition CTP(community tchnology preview) DVD and I am looking at a...more >>

Hi, I used a webservice (a reference web) in my webapplication in order to view my report. However, my report has a parameter. I don't know what to do. Are they any function with the ReportingService to do this? What are the steps to give a parameter to my report? ...more >>

Hi, I've installed Reporting Services on my laptop and built some folders and reports, works great. But when other persons tried to access my reports they only got an empty Home-folder when connecting (to http://myserver/Reports). I tried to change properties at IIS/default website/reports/...more >>

Hello. Can I make a report for example with all the columns and make a program in asp.net in which the user can select the columns he wants to see? Thanks. ...more >>

I am trying to open the report in a Fram called MainFrame using this URL http://demo.online-pmsi.com/ReportServer?%2fDEMO+CUSTOMER+ANALYSIS%2fCUSTOMER+ANALYSIS&Customer=233787&Detail=0&rs%3aParameterLanguage=&rc%3aParameters=False&rc%3aLinkTarget=MainFrame What is wrong with it, it keeps open...more >>

how to include sort by in the parameters...more >>

Does anyone know how one can control/modify/overwrite standard X and Y axis in chart control? I am even reconsidering rewriting the whole char component since it is far from what is must look like. Thanks, -- Martin Kulov http://www.codeattest.com/blogs/martin MCAD Charter Member MC...more >>

HI, We have Server Reports in our application deployed on the Report Server(local host). What all steps need to be done when we make an MSI of the project for deplying reports on the new server? Do we need to first deploy the reports on new server and then make an MSI? Need help. Thanks in ...more >>

Hello, I've installed new CTP June of SQL2005. And I'd like to create new report in reporting services with connection to Analysis Services 2000. So, I've created datasource, looks fine, test connection succeeded. When I'm starting to create report, after selecting datasource, when I click on ...more >>

hi folks ---------------------------------------------------------------------------- create MyProc @Param1 int=0, ..@ParamN int=xx, @Debug bit=0 as if @Debug=1 begin -- some code when in Debug mode Select @Param1, ..@ParamN end -- Resultset Select * from pubs.dbo.Authors go...more >>