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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|