all groups > sql server reporting services > march 2005 > threads for wednesday march 9
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 31
multiple resultset in the report
Posted by ALI-R at 3/9/2005 11:30:49 PM
I have a stored procedure which returns multiplr resultsets ,and I'd like to
show it in different tabls in my report.Is it doable???
Thanks for your help.
Ray
... more >>
Is Legal convert Crystal RPT to RDL?
Posted by Jerry at 3/9/2005 8:27:02 PM
From Crystal [Licence.pdf]
4.6.5 (Excerpt)
"End User agrees not to alter, disassemnle, decompile, translate, adapt or
reverse-engineer the Runtime Software or the report file (.RPT) format"
"End user agrees not to use the runtime software to creato for distribution
a product that convert... more >>
Landscape printing setup
Posted by Sachi at 3/9/2005 8:19:03 PM
Hi,
Anybody able to workout a solution to set report to landscape settings and
export it to PDF successfully with that same settings?
No Idea when SP2 is going to release. Had to workout a roundabout soultion.
Please any one repond....
Thanks in advance,
Sachi... more >>
Re: Exporting to Excel Error : (rrRenderingError)
Posted by Constantine at 3/9/2005 8:11:02 PM
When exporting some reports to excel.
This error appears
-----------------------------------------------------------------------------------------
Exception of type
microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception ... more >>
VB.Net 2003 Render Method
Posted by Kevin at 3/9/2005 8:05:07 PM
The Reporting Services Render Method can be used as part of a Web Project.
Can the Render Method also be used in a Windows Form Project?... more >>
Pull an Image from a Database onto a Report Problems
Posted by Jeremy Wright at 3/9/2005 6:47:51 PM
Does anyone know if the following is possible? If so, any pointers on how
to accomplish it?
I have a table in SQL 2000 containing two fields "StoredDoc" and
"StoredDocExtension".
The StoredDoc field is a ntext field. the StoredDocExtension is a char
field.
When uploading an image to th... more >>
Default Value for Parameters
Posted by Dario Concilio [MCP] at 3/9/2005 5:57:05 PM
Hi,
Can I set a Default Value for Parameters?
Thanks
Dario Concilio
... more >>
nothing happens when selecting "new folder" ?
Posted by scott at 3/9/2005 5:42:37 PM
When i connect as local admin to http://server/Reports/Pages/Folder.aspx and
select NEW FOLDER , nothing happens (also when selecting anything else on
this bar nothing happens, like data source etc..) When moving the cursor
over the option it does change. I can select properties.
is this no... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Summing matrix rows & columns
Posted by Bill Youngman at 3/9/2005 4:47:05 PM
I have the following matrix in my report -
* Fields!GroupItemName.Value is a matrix row and Fields!UserName.Value =
is a matrix column.
* Documents Processed (=3DFields!DocCount.Value)/Avg Time =
(=3DFields!AvgTime.Value)/Total Time (=3DFields!TotalTime.Value) are =
static rows
What ... more >>
Reporting Services installation:Authz is not installed on this mac
Posted by Omar Vera at 3/9/2005 3:43:04 PM
Hi all,
I am installing Reporting services in the following machine:
Win2K + SP4, both of them including in the same installer
SQL Server 2000 + SP3, installed separately
But when I am installing Reporting Services I receive the following warning
in the result of the system prerequisites che... more >>
Reporting Services with Oracle 8i
Posted by Harold at 3/9/2005 3:33:03 PM
I want to know if Reporting Services has problems connecting with Oracle 8i
functions (no procedures), also if it has problems with output parameters in
Oracle procedures and functions.
Thanks.... more >>
Cant PREVIEW SAMPLE REPORTS
Posted by pmud at 3/9/2005 3:29:02 PM
Hi,
I tried to view the sample reports provided by microsoft, but I cant even
preview them....I get the error::
AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
DENIED....
But the wierd thin... more >>
cant load rep mgr without user + pass prompt ?
Posted by scott at 3/9/2005 3:10:55 PM
When loading Report Manager on the hosting Rep Service machine i cant access
any options without a password + user. I cant get any to work.
When setting up Rep Services in every option possible i defiend a local
service account at first. I then uninstalled the software and installed
again u... more >>
The underlying connection was closed: Could not establish trust relationship with remote server.
Posted by Jake Smythe at 3/9/2005 3:04:57 PM
Hello,
I have a couple of problems trying to setup a production box.
Pre Installation...Created our own ssl cert and attached to default
web(unfortunetly have no budget to purchase outside certs)
Installation: Selected option to redirect homepage to reports page.
Se... more >>
Reportes ok desde /reportserver pero no ok en /reports
Posted by Jfrc at 3/9/2005 2:29:05 PM
En blanco
Hola!
por favor alguien me podria dar un luz con este tema los reportes en la =
lan funcionan siempre ok y en internet desde el portal /reports =
simplemente no fucionan y no saca ningun tipo de error, simplemente no =
funciona y si el mismo reporte lo busco en web via /rep... more >>
HOWTO: Get a table to display that has a Null DataSet
Posted by Jeff at 3/9/2005 1:41:12 PM
HOWTO: Get a table to display that has a Null DataSet
I have a table that is designed with static text that I what to be displayed
every time regardsless of the tables dataset contents, with rows or a NULL
dataset.
I have multiply datasets in my RDL.
How can I do this?... more >>
Report Caching
Posted by PD at 3/9/2005 1:25:13 PM
If a report (report A) is set-up for caching and is then used in another
report (report B) as a sub-report, will report A be rendered from cache when
report B is executed?... more >>
Web Service activation error
Posted by poul0004 at 3/9/2005 12:41:07 PM
Hello all-
I have read and attempted to follow all of the doc I could find on the
Microsoft site and this newsgroup regarding the following error.
I have just completed an install of RS on Windows Server 2003 with IIS 6.
This is the Report Server. The Report Server database is hosted on ... more >>
main page blank after new install ?
Posted by scott at 3/9/2005 12:06:45 PM
Hi,
I installed reporting services on 2003 (IIS6, front page ext, asp.net, no
vb.net). When connecting to http://server im directed to
http://server/Reports/Pages/Folder.aspx . The main form header shows HOME /
MY SUBSCRIPTIONS / HELP but the main page is blank.
Anyone know why and how t... more >>
No attachments in subscription mail messages
Posted by Stefan Cremers at 3/9/2005 11:45:08 AM
We have reportingservices installed on the sql box. It's a W2K SP4 server
with sql2000 SP3a.
We have deployed several reports. All reports we have deployed after
installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV) but
when the report is rendered in the body of the messa... more >>
crashing excel when printing exported RS report
Posted by David at 3/9/2005 10:03:03 AM
We are having a problem with some reports that get exported to excel and then
trying to print. we don't get this with all reports just some.
Here is what happens:
The report generates fine in RS. We then export to excel. We tell excel to
print and then get a 'Memory can't be read' error and ... more >>
Reference to a non-shared member requires an object reference
Posted by JL at 3/9/2005 8:49:05 AM
Hi,
I tried to use a custom assembly, written in C#. I received the following
error:
"[BC30469] Reference to a non-shared member requires an object reference..."
Here's the detail info for the custom assembly:
*I have 2 C# files. I did not write the code. So my C# knowledge is
lim... more >>
Processing Time Perfomance
Posted by David Swanson at 3/9/2005 8:45:05 AM
First, a general question. What is a "reasonable" time to expect the
ProcessingTime to take. Now I know that is pretty vague and largely depends
on the grouping/filtering defined in the RDL.
Our problem. We have a several main reports that each embed 7-10 subreports
from a pool of 15 or ... more >>
System.Net.WebPermission and Data Processing Extension?
Posted by letuce dance at 3/9/2005 8:39:01 AM
I have created a Data Processing Extension
Inside the extension I’m trying to do this:
XmlDocument xml_document = new XmlDocument();
xml_document.Load("http://localhost/information.xml");
sounds pretty simple. Ya right nothing that has to do with rs is simple.
It throws a
<IPermis... more >>
move project to another developer
Posted by Jason Wang at 3/9/2005 8:37:03 AM
When another developer open my report project in his machine, he could not
look at the report on design view. The user id on data source is a SQL user
id, not Windows ID. How do I fix the problem?... more >>
Report to show current year revenue only if last year has no reven
Posted by DCount17 at 3/9/2005 6:31:05 AM
I need to create a report that correctly displays ONLY accounts that have
revenue for the current year and no revenue at all for the previous year
(calendar year). The sql below does not do it.
SELECT DISTINCT a.ACCTNBR, a.ACCTNAME, SUM(f.REVENUE) AS REVENUE FROM
FORD.dbo.DATA... more >>
user permissions
Posted by jcrodri NO[at]SPAM gmail.com at 3/9/2005 5:47:50 AM
Hi,
anyone know how can I asigment a user permision for an expecific
report, but programatically, in a .NET Web Aplication???
Thanks
... more >>
connecting Lotus Notes data in VS .NET Report Designer
Posted by Charles Chung at 3/9/2005 4:41:01 AM
my company is requesting that I convert notes db views into a report using
MSVisualStudio.Net. I downloaded the LotusSQL driver and created a
datasource. The driver was also downloaded to the appropriate Reporting
Services server.When I am in VS I can preview the report. However, when I am
i... more >>
|