I don't know how I can succinctly express my problem other than I've got all the latest bits for SQL Server 2000, Reporting Services, service packs, etc... installed. I have Share Point Portal / IIS 6 / Windows 2003 / SQL Server 2000 all installed on same box. I followed all directions to ...more >>

I install Reporting Service for SQL Developer Edition (English Version) onto a WinXP (English also), and the regional setting is United States. However, the installation wizard is in Chinese and the Report Manager is in Chinese also. The online book is Chinese (Taiwan). How can I change the R...more >>

I have checked and rechecked I have read the posts many times, but I still can't get it to work quite right. After configuring the security extension I can successfully register a user (admin). I can deploy a report via the .NET IDE. I am prompted for the user name. The report is deploye...more >>

Hi all, I'm having a problem with a series of reports I'm developing that allow the user to design their own reports. They involve passing parameters (and sometimes not passing parameters) between many different reports. The issue I have is this: I have an opening page with no paramete...more >>

Some users are getting the following error message when they attempt to export to any of the avialable file formats. "Internet Explorer cannot download Format=EXCEL from sqlreports.cnf.com. "Internet Explorer was not able to open this Internet site. The requested site is either unavailable ...more >>

I am exporting report document to a file share every 1 hour using Subscriptions. Sometimes the PDF document that the subscription created is corrupted. This happens at random. This is the error I get when I open the PDF either in 5.0 or 6.0: In 5.0: "There was an error processing a page....more >>

I have 2 textbox within my detail table that has 2 subreport. Then in each subreport, it contains 1 stored procedure. Is it possible to do some calculation with those two textboxes? Example: Textbox1 - Textbox2 = 1234 Can someone tell me if this is possible? If not will RS 2 might have...more >>

We have created a report that creates a historical snapshot. In the header, we use the Now vb function to return the current date/time. However, the Now function does not evaulate at the report execution time. Rather, it seems to evaluate upon the first opening of the report for viewing. Thus,...more >>

Hi all, When you install the SQL Reporting, you have the option to add the mail server. Where can I find this infomation after the installation. In my case I didn't add it during the installation so I need to add my mailserver! Thanks! Björn ...more >>

For a report I am creating, I need to display rich text format content, that will be saved in the database, on a reporting services report. This data will include bolds, bullets, italics, indents, etc. Is there a way to show this content formatted correctly in Reporting Services? We were ...more >>

Hi All MSTR Mentor's I have a RDL, where the stored procedure returns 10 fields among that 1 field is the creditcard# which is encrypted, I need to decryt the creditcard # and display it in the report. I use a .net custom aseembly which has a decrypt function and it is added as a reference ...more >>

We have our Web Apps and Report Server running in separate IIS Application Pools. The issue is when a long running report (> 2-5 min) is called by the Render method from the web app (streams PDF to the browser), then the user of the web app closes the browser and goes to lunch, the w3wp.exe u...more >>

I am trying to render a report as an image to one page. The report is rather wide, with 13 columns +. It is primarily made up of a matrix, with the keeptogether property set to true. I have double checked all the properties and made sure they adhere to microsofts recommendations for renderi...more >>

Hello, Is there a way to use something like LOOKUP COMBO in reporting services. What I want to do is, to be able to GO AND LOOK FOR some value from another table in a report.. The report name is mainreport mainreport : [Product Code] 1243 Intervention# Labo...more >>

in MSDN managed newsgroup list: http://msdn.microsoft.com/subscriptions/managednewsgroups/list.aspx There is a typo in the URL for Reporting services Browser view. http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=micrsoft.public.sqlserver.reportingsvcs Instead of microsoft, it's...more >>

I have a stored procedure that takes some parameters. I can execute it in the data tab in vb.net and get my results. How do i take these results and form a report? Is there a way to capture the fields that are returned in order to drop them into a report? I'm doing all this in vb.net. Th...more >>

This happend twice on two different servers. A 33MB reporting service log was generated every 3 minutes until it took up the entire C:\ drive. The log file has a header then repeat some message as in the following exerpt for 30+ thousand times. Then it starts another log file endlessly until t...more >>

I need assistance to install RS2005. What software I need (with beta indexes)? What is order of installation? Thanks...more >>

I have a store procedure that executes from the Data tab in vb.net. It prompts me for the two parameters and executes sucesfully. The problem comes when i go to preview the report and enter my two parameter values on the RS toolbar i get the following message. Procedure 'stp_excess_stock' ex...more >>

I have a main report with 4 subreports. Which subreports are visible on the report is determined by the user at runtime via a custom parameter page. I have implemented the show/hide without any problems but the report seemed to be running very slowly. The issue is that even if a subreport i...more >>

I am having a weird problem with just one report in production. When exporting to PDF format only, the browser prompts for user authentication. No matter what you type in the window (even admin for server) it just keeps popping up. When you click cancel you see the following error. HTT...more >>

Can Reporting Services display images from SQL Server where field is a = reference to an image? For example, if the field called images contains = the text" ~/Images/Image.jpg" ? I know it can be done if the object is = embedded, but what about the case where there is just an address? If = so...more >>

Here is my current setup. I have Report Services sp1 installed on a Windows 2000 machine with SQL Server 2000. We have successfully configured RS to produce reports over the internet via SSL. The actual viewing of the report over the internet works great. However, in Visual Studio I receiv...more >>

I have a report that needs to "jump" to 2 URL's at the same time. I also need them to open in a second and third window leaving the first open to the orginal report. Can this be done? I have the report right now that can "jump" to one of the links in the cell. But it uses the original window....more >>

Installation of WS2003SP1 broke reporting services SP2Beta. I now get "The request failed with HTTP status 401: Unauthorized." I've re-set the database credentials via RSCONFIG. I think it's in IIS, but I can't seem to find it. Any help would be appreciated....more >>

The legend scales with the Chart. My client would the rectangles in the legend to be perfect squares. Is this possible? -- Callidus Software Designer...more >>

On some of our RS machines the Verdana font doesn't render correctly in PDF format, there is no spacing between the letters (all at the same location). Other fonts like Arial render correctly. Is this a known issue? sp1 has been installed (I know there were some issues with this before servi...more >>

Hi, I have a report consisting of a chart and 4 tables. I have written a stored procedure to return different (single) result depending on the input parameter. E.g. @Param is 1 for chart, 2 for table 1 and so forth. The issue here is, although with different dataset created, I am not able to ...more >>

Hi Guys, Can somebody explain me cleraly the difference between Query and Report Parameters. Report Parameters r automatically created when u put some variable in a query. 2) One more thing is there a way we can hide query string in the IE as I dont want the users to see the report UR...more >>