I deployed reports to a new server running Server 2003 and RS SP2. I can view my reports in IE, and export them as PDF's. But when I put them on a shared schedule, the PDF's throw a ReportRenderingException. The Excel reports are running fine. I need to run several hundred reports tomorrow...more >>

Hi, I have used render method to render the data from data source to PDF format in chinese character by using MS Gothic font family, but few character in chinese words are printing as @ symbol.(ie. that character which has single cote embeded) Help is requried to print chinese character co...more >>

Just installed SRS on a remote server. Tried to access the web service at http://<IP>/reportserver/reportservice.asmx and get 403 - Forbidden. When the system is installed, anonymous is turned off. When I turn it on I still get 403 - Forbidden. Thoughts? TIA. ...more >>

I have a main report with 4 charts. I set each chart to jump to a report with it's detail. The main report is in the main folder of the directory and the 4 reports are in a subdirectory call "details". I am getting the following error when I view the reprorts in the report manager: The ...more >>

Hi All, Have the following query in an RS report that tracks Projects and their managers BY TIME from an Analysis services Cube. I want to be able to have a query-based parameter on Geography.Division where by a user will be prompted with a dropdown list and accordingly the query will be execut...more >>

After Applying SP2 I export a file to PDF and Adobe throws and error saying "A drawing error occured". The report is several pages long and displays the information on pages 2 and after but nothing on the first page. I removed the logo and then re-exported the file and everything works fine....more >>

I was wondering if anyone knows of a way to remove parameter dependencies. I'm making a lot of reports for my company, but for some reason the Reports Server is setting up a bunch of parameter dependencies, and it's causing parameter entry to be extremely tedious (when you change a parameter ...more >>

Will there be any inbuilt control for using SRS 2005 with VS.Net 2005? I know we can use Reporting Services security extensions with exisiting SRS version but I was wondering if it would be easier to implement in next release. -- Thanks...more >>

Hello there, I have a table with several cells that contain a value. Also for those cells there's a specific background image, which is displayed depending on the value contained (displayed) in the cell. Everything works fine, but when I export the report to excel the background image is no...more >>

Hello all, I am trying to get some email subscriptions setup and I keep getting the message "The e-mail address of one or more recipients is not valid". The email address is valid and I am not sure what the problem is. If I set the email address to a local account name (i.e Administrator)...more >>

Hi managed to have a dynamic database with SQL server using something like this as my query : declare @SQL varchar(255) Select @OwnerID = '[' + @OwnerID + ']' select @SQL = @DBName + '.dbo.sp_rptFinance ' + @YearBegin + ',' + @OwnerID exec (@SQL) However each of my database uses a diff...more >>

Hi, I have a Dataset that contains some data that I would like to use in the page header. The dataset is dependant upon a passed in parameter (BOLNumber). My SQL statement for the dataset is along the lines of "select * from table where BillNumber = @BOLNumber". I've tried to setup paramete...more >>

I have a POITEM Table which has just three columns InvetoryID, DateofOrder, VendorID I have under the same InventoryID ,multiple DateofOrders and VendorrID;s. SO for eg here is a couple of lines of the data, InvetoryID, DateofOrder, VendorID ACCKAPCONS01 05/05/2005 ALTPRO0...more >>

I have a dataset that looks like this: chargeID chargeAMOUNT receiptID receiptAMOUNT 1 $10 1 $5 1 $10 2 $5 This is an example of one charge paid by two receipts. If I group by chargeID, I can then hide chargeAMOUNT from duplicating...more >>

Dynamic Controls are giving me nightmares. I have a normal drop down list called Reports: Reports - let's user select the report they want to generate The number of parameters of the report is never known ahead of time, which is why I need to dynamically create them based on the selected ...more >>

I am trying to re-create a report in RS which we currently have in Crystal. The report does a grouping of data based on client. There should be an "address" page in-between each of the client's data pages which displays the client name and address (for an envelope). This page should not have a...more >>

I am passing parameters in my report. When I bring up the reports it shows all 15 parameters. I know there is a hide parameters button but is there a way to change the default view in Report Manager so that the parameters aren't displayed when the report pops up? Thanks in advance os...more >>

I am trying to create appointment reminder letters, and at the bottom of the first page of each letter I need the clinic contact information (phone number and name). Immediately prior to this I must list various instructions regarding what to bring, what to eat/not eat beforehand, etc. Regar...more >>

Hi Hopefully someone can help me. I've installed RS on a Win 2003 Server with SQL Server 2000. Install was fine although it did tell me that as sharepoint was installed i would have to manually initiate the service. When i run rsactivate it tells me that the service is already running, but...more >>

I am using the following query for my dataset: SELECT DISTINCT vwProtocol.ProtocolNumber, vwProtocol.HSCNumber, PIName = (SELECT MemberName FROM vwMemberNames WHERE vwMemberNames.MemberID = tb_Protocol.PIMemberID), TotalAccrual = (SELECT Count(PatientID) FROM tb_Pa...more >>

ditto: Ihave had the same problem and come to the same conclusion as dragonvic regarding the invisible window ... "DragonVic" wrote: > I need to re-poen this issue and would like to get immediate attention on this. > Please see history below. > > "DragonVic" wrote: > > > I need to kno...more >>

I have a report that consists of a number of subreports. When I export to PDF I get blank pages on every second page. No data is missing, it looks like an incorrect margin setting or additional page break. If I export the original "Sub"reports to PDF, then the problem does not occur. I h...more >>

I have a requirement to run .rdl reports and also export the data for the report into EXCEL. My quest is how can I export the data, is there an dataelement in the RDL definition language that I can use. ThankYou...more >>

Hi, I am clueless on how to generate the report in Excel 2000 format. i have installed reporting services 2000 with service pack 2 in this machine. the resultant Excel file format is in version 2003. i cant view that in Excel 2000. your feedback is highly appreciated. Following is my cod...more >>

I am using Reporting services 2005 I have tried to use the "In named set" and MDX operator / filter expression in reporting services to exclude the all member of a dimension, but that option does not seem to work at all. can someone help please thanks very much! -- Message posted via...more >>