Hi, I received an error message after running a report by pushing the Preview button: ORA-00972:identifier is too long ORA-06512:at "SYS.DBMS_UTILITY", line 114 ORA-06512: at line 1 Here is the Oracle proc: CREATE OR REPLACE PACKAGE BODY MPC IS PROCEDURE Report_Performance_Main_5 (i...more >>

I have several report that require parameters. These parameters all need to have default values. When the report is displayed, the report is generated automatically. How do I prevent the report from being auto-generated and only generate the report when the "View Report" button is clicked? ...more >>

I got my custom assembly working fine until I add writing to a log file. Then I get a FileIOPermission error. I have the following code in my policy file: <PermissionSet class="NamedPermissionSet" version="1" Name="ReportHelperFilePermissionSet" Description="A special permis...more >>

Does anyone know how to show the data point for a pie slice outside the pie and connected to the slice by a line. The Pie Chart in SRS does not appear to have this functionality as does a similar pie chart with the base Dundas software. ===================== Thanks! Keith p.s. Get off t...more >>

I have a report in which I sort out the top x customers withs best revenue. Here I have sort on total revenue field. But when i toggle the customer I need to get the data sorted by period instead of revenue so that they can see how the different periods went. Is it possible to have another sor...more >>

Are there any issues or can I just install SP4 ? Jack ...more >>

I recently installed SQL Reporting Services on a Windows Server 2003. Whenever i try to open the repot Manager, i get the following error : An internal error occured on the report Server. See error log for more details (rsInternalError). The system cannot find the file specified. Attached is...more >>

Quick question... I have a report with a subreport. Can I reference a field/textbox in the subreport from the main report? For example, if I have a sum calculated by the subreport, can I display that in the report? Thanks!...more >>

Is it possible to produce graphs with multiple x or y axes?...more >>

Our billing system runs SQL Agent jobs in the middle of the night and we want to generate reports that automatically get sent to a printer. I don't care if they are in PDF, EXCEL, CSV, text or whatever format. I just want them to print without a user having to click on them. The reports are...more >>

Hi, I need some help with making the Printer Delivery Extension play nicely with RS equipped with Forms Authentication/Custom Security. We have been using the forms authentication for some time but just recently decided to implement the Printer Delivery Extension. The Problem: With Form...more >>

No, I haven't found a fix for it, I keep getting ignored, I am sick and tired of this BUG, I love Reporting Services, but it is costing me time and it is going to make it very difficult to convince my Boss that Reporting Services is "the" reporting tool. "MJ Taft" wrote: > DID YOU GET A ...more >>

We have a custom .net webb app front end that uses the SOAP methods for rs. For reasons that are not important to explain, we have several different types of parameters..we have a couple that we would like to have the user do an external search (there are too many values to set the parameter ...more >>

I'm having a couple of problems with the HTML that is generated for a report I'm writing. I want the entire report to come back at once (it is several hundred pages long) rather than the page at a time that the RS interface gives you. I call the report via the following URL address http:/...more >>

Hi. I have another problem. Anyone please? Your answers will be greatly appreciated. My code is like this : =iif(Fields!TDeact.Value = 0, "N/A", Fields!TDeactn.Value/Fields!TDeact.Value) - this code is to eliminate the problem: "attempted to divide by zero"; however, it does not work. Still...more >>

I have tried the PrinterDeliverySamples with RS2000 without success. I have read about new printing functionality with RS 2005. Is direct printing per subscription to a printer supported wit hthe bnew version or not? Or do they still just offer those $()§$!"& PrinterDevliverySamples? Than...more >>

Is there a way that I can put a textbox down that will say something like this report took 132 Seconds to generate?...more >>

Hi, I've created one mailing label report with 2 Across Than 3 down.But it displays the data like 1 4 2 5 3 6 Is there a way to change the default orientation from Down then Across to Across and then down like this ? 1 2 3 4 5 6 Thanks & Regards Malkesh...more >>

Problem: My subscriptions are being deleted, I guess when i re-deploy the reports? It has happend twice, but I do not know the reason, It just seems to happen! As of today, we use 6 different subscriptions, 3 of which produce 6000 reports to be distributed to email recipients, and 3 producing...more >>

hi, i've got a "parameter" that is of date type, but is there any way so that it only shows the "short date" format --- don't want the time. thanks, ...more >>