Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > april 2005 > threads for thursday april 21

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Export Multicolumn Report to Excel
Posted by Sunny at 4/21/2005 10:09:01 PM
When i export a multicolumn report to excel..all the data gets exported in a single column. Is this this way right now or i am missing something here thanks...more >>


Directly generate PDF file
Posted by A. Moesker at 4/21/2005 9:05:48 PM
Is it possible to generate directly a PDF file with a name, and not first come in the HTML page and then eport to PDF. I hope someone knows how. Kind regards A. Moesker ...more >>

Found SP2
Posted by Cindy Lee at 4/21/2005 4:16:34 PM
It's in here http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=5768960182&ssPageName=ADME:B:LC:US:1 ...more >>

caching questions
Posted by dave at 4/21/2005 3:22:02 PM
I am new to Reporting Services and would like to know if it can do the following: 1. If I cache a report with timed expiration such as 48 hours, can I programatically expire a specific report before it would have expired normally? 2. When a report is generated from cache, is it possible ...more >>

Undesired Report Caching
Posted by coronaride at 4/21/2005 3:21:04 PM
Hi, I'm sure that this is a pretty simple issue to fix, but I'm currently stumped. We have an enterprise level web application that serves MSSRS Reports to many users. The database content is changing quite often so we don't want any (or very very little) caching to take place. Nevertheless...more >>

Render Xml from image DataType
Posted by Troy Jerkins at 4/21/2005 3:06:25 PM
Sorry for the cross post, but I'm stumped. I'm trying to render the XML content that is stored as an image datatype in the SQL Server Reporting Services database.Table Catalog, Content Colmn, using ASP.NET (VB.NET). These look to tbe the RDL files that get uploaded where the TYPE column = ...more >>

Can't get sum to work with 2 groups.
Posted by Jason Agee at 4/21/2005 2:49:32 PM
Hello, I've got 2 groups (on county, and on precinct) and my Dataset looks like this: row1 : county = 1, precinct = 1, count = 500, value = a row2 : county = 1, precinct = 1, count = 500, value = b row3 : county = 2, precinct = 3, count = 700, value = c row4 : county = 2, precinct = 3, count ...more >>

RS.EXE XServer Calls
Posted by Dennis Redfield at 4/21/2005 2:47:01 PM
I have a short and simple RSS script which renders a report and writes the output to disk. When I run the script while logged on, as myself, to the RS Server the script works as desired. When I run the script from my development machine I receive the error: >>The report server cannot open a con...more >>



Export to Excel Link - Inactive -Critical - Need Help
Posted by BALAJI KRISHNAN via SQLMonster.com at 4/21/2005 2:07:48 PM
Hi all, I am using asp.net control(Reportviewer) to view the report in the web, but when I render the report, the export link is inactive and when I choose the refresh button, the Export link is activated. For the first time the Export link button is inactive. This issue is very critical,...more >>

Possible SOAP version mismatch
Posted by Paul W at 4/21/2005 1:50:42 PM
Hi, I am getting an error when I go to view my websites Report Manager. i go to http://www.mysite.com/Reports (reports maps to the Report Manager folder). when ever i go there i keep getting some generic Error Page. the only information it has on there is: Possible SOAP version mismatch: En...more >>

Report Footer Not Showing Grand Totals
Posted by Mike Harbinger at 4/21/2005 1:36:45 PM
Using the report wizard I built a report to break the page on a given customer name. The wizard built a single detail row and a header. I then added a group footer to break on customer name so I would see a total for each customer. This all worked fine. I then wanted to see a grand total so ...more >>

RS PARAMETERS
Posted by Mauryq at 4/21/2005 1:29:03 PM
I have a report with a Dataset that has a query string: exec sp_ReporteFlashVentasXRutaYDiario @Usuario, 1, @Mercado, @Agencia,@Ruta The report is working, but I want to delete the parameter @Rute and the follow error are displaying: An error has occurred during report processing. Query ...more >>

How do I deploy XSL file to Reports Server?
Posted by bwschiek NO[at]SPAM hotmail.com at 4/21/2005 1:07:29 PM
Hi: I have developed a report that uses and XSLT file to format data found in a CLOB field from our DB2 database. It works just great in Report Designer, but when I deploy to the Reporting Server, it does not render the data from the CLOB but rather an error. The value of the text box i...more >>

Grouping with non-existent data
Posted by eoghain at 4/21/2005 11:32:09 AM
I need to build a report that groups data by a given time frame increment (15 min, 30 min, 1 hour). But I need the report to show every increment weather there is data in my result set or not. So if I was to run my query for the time frame of 12pm - 1pm and got the following data: 12:00, ...more >>

RS Printing Questions
Posted by Vinny Vinn at 4/21/2005 9:46:02 AM
1. When creating a report,In the preview tab i have the ability to print out the report (using the print button) however once the report is deployed to the report server the user doesnt get the print button and can only print from the browser.Is there any way to print from the report (as oppos...more >>

Unexpected error occurred in Report Processing (rsInternalError)
Posted by Michael at 4/21/2005 9:40:25 AM
I have a newly installed Reporting Services (SQL Server 2005 Beta 2) Server and when I try to upload an RDL file, I receive the following error message: ================================== An unexpected error occurred in Report Processing. (rsInternalError) Get Online Help Access is denied: '...more >>

How to incorporate column-header click-driven sorting, and column header click-driven grouping
Posted by Bryan Avery at 4/21/2005 8:08:46 AM
How to incorporate column-header click-driven sorting, and column header click-driven grouping in SQL Server Reporting Services: Create the following report parameters with the following details (you can change the parameter names to suit your naming convention): (1) Name=3DprmSortBy Prompt=...more >>

Reporting Services Deployment Problem
Posted by Derek Fisher at 4/21/2005 7:29:02 AM
I'm new to Reporting Services and whenever I try to deploy a report I've build in .NET, I have to turn off anonymous access to the ReportServer folder in IIS. I imagine that Reporting Services wasnt installed correctly or that there is some way to fix this. However, I havent been able to fin...more >>

Rich Text Fields
Posted by TroyS at 4/21/2005 7:25:57 AM
I am trying to produce a report using MS SQL Server Reporting Services that will include data that is stored as Rich Text Format. If I use a regular TextBox, Reporting Services displays all of the RTF escape codes around the text. Do you know of a way to get the text out of a Rich Text Field...more >>

Anybody looked at LGX Report?
Posted by jhcorey NO[at]SPAM yahoo.com at 4/21/2005 7:06:22 AM
This is at freereporting.com. It seems to be very similar to Reporting Services. Has anybody here made a comparison? JC ...more >>

designing reports
Posted by Paul at 4/21/2005 6:31:05 AM
Hi - we are just putting a proposal/costs together to implement reporting services. Might seem daft (!), I know i need the report designer and it works with the visual studio .net 2003, but does that mean we need to buy visual studio .net 2003 (std/dev/enterprise?) and the designer comes f...more >>

Problem exporting to PDF
Posted by Riddick at 4/21/2005 6:29:05 AM
Hello everybody, I can't render a report to PDF and I get the following error : "Internet Explorer cannot download Format=PDF from server Internet Explorer was not able to open this Internet site. The requested site is either unavailable or canot be found. Please try again later." What it...more >>

Export to Excel Problem..! URGENT
Posted by Veeresh at 4/21/2005 3:40:02 AM
Hi All, I'm facing one problem when I'm exporting my report to excel. I have a report with 200 pages and 120 columns. When I'm exporting that report, After waiting for some time (I think its around 3 min) its asking windows challenge box for my user credentials, even after giving the correct ...more >>

Manage style of reports from one place?
Posted by McGeeky at 4/21/2005 12:00:00 AM
Is it possible to maintain the style of all of my reports from one place, say by using a style sheet or by applying a template? -- McGeeky http://mcgeeky.blogspot.com ...more >>

HELP: How to do batch PDF printing using reporting services?
Posted by Jordan Tan at 4/21/2005 12:00:00 AM
HELP: How to do batch PDF printing using reporting services? Any advice greatly appreciated. cheers, jordan. ...more >>


DevelopmentNow Blog