Forcing types in Excel connection?

I am using Crystal Reports 9 to build a report that involves connections to both an Excel spreadsheet and an Oracle database. The problem is, the Oracle database contains an ID field stored as text (although the data is currently strictly numeric). The same ID field appears in the excel spreadsheet. I am trying to join the spreadsheet to the database. My problem is that, since ID field in the spreadsheet contains only numeric data, Crystal Reports imports the field as a numeric field then expects it match to the Oracle database's text ID field! Obviously, this creates a type error and the report fails.

My question is: is there any way to force Crystal Reports to regard a field in Excel as text rather than numeric data? Changing the cell attribute to text in Excel didn't seem to work; Crystal still saw numbers in the field and assumed the data was numeric.

This is an urgent matter so any help at all would be appreciated. Thanks!When joining the tables convert oracles table's id to numericsql

Force new page.

I have a report that has multiple graphs on it. I would like to force a page break (new page) in between the different reports causing a report to be generated on it own page. Im assuming that Im missing something here because it seems like a easy/usable feature. Any help would be great.

Thanks,

ZDB

Hello ZDB,

Click on your chart, then press F4 to open the Properties window. In here, set the PageBreakAtStart or PageBreakAtEnd to True, depend on where you want the page break.

Hope this helps.

Jarret

For XML AUTO

Hi
I'm trying to produce XML datasets to be used in Crystal Reports, but I
cannot seem to view the XML output when produced.
It just comes back with errors, when viewed in IE.
The error is:
************************************************** **************************
********
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.

Only one top level element is allowed in an XML document. Error processing
resource 'file:///C:/Documents and Settings/hsrp...
<Order_ Order_Date="1998-10-07T00:00:00" ConvertedDate="19981007"
ConvertedDate1="19981007"/><Order_ Order_Date="19...
************************************************** **************************
********
Any ideas why this is happening?
Kind Regards
Rikesh
(SQL2K-SP3/W2K-SP4)
FOR XML produces XML fragments - not documents. You might need to add a root
element to the results in order to make it well-formed.
Cheers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"rikesh" <rikesh_patel@.website.com> wrote in message
news:ejMHMbMZEHA.3752@.TK2MSFTNGP12.phx.gbl...
Hi
I'm trying to produce XML datasets to be used in Crystal Reports, but I
cannot seem to view the XML output when produced.
It just comes back with errors, when viewed in IE.
The error is:
************************************************** **************************
********
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.

Only one top level element is allowed in an XML document. Error processing
resource 'file:///C:/Documents and Settings/hsrp...
<Order_ Order_Date="1998-10-07T00:00:00" ConvertedDate="19981007"
ConvertedDate1="19981007"/><Order_ Order_Date="19...
************************************************** **************************
********
Any ideas why this is happening?
Kind Regards
Rikesh
(SQL2K-SP3/W2K-SP4)
|||Any ideas, how to do that, someone suggested FOR XML AUTO, ELEMENTS, but
that didn't work?
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:ua2LxDNZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> FOR XML produces XML fragments - not documents. You might need to add a
root
> element to the results in order to make it well-formed.
> Cheers,
> Graeme
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
> www.microsoft.com/mspress/books/6137.asp
>
> "rikesh" <rikesh_patel@.website.com> wrote in message
> news:ejMHMbMZEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Hi
> I'm trying to produce XML datasets to be used in Crystal Reports, but I
> cannot seem to view the XML output when produced.
> It just comes back with errors, when viewed in IE.
> The error is:
>
************************************************** **************************
> ********
> The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error
and
> then click the Refresh button, or try again later.
>
> ----
--
> --
> Only one top level element is allowed in an XML document. Error
processing
> resource 'file:///C:/Documents and Settings/hsrp...
> <Order_ Order_Date="1998-10-07T00:00:00" ConvertedDate="19981007"
> ConvertedDate1="19981007"/><Order_ Order_Date="19...
>
>
************************************************** **************************
> ********
> Any ideas why this is happening?
>
> --
> Kind Regards
> Rikesh
> (SQL2K-SP3/W2K-SP4)
>
>
|||You can't do it in Transact-SQL in SQL Server 2000 (Yukon includes a ROOT
directive). You need to do it on the client. The ADO and ADO.NET classes
shipped with SQLXML have a RootTag property you can use, or you could use a
template or schema. Have a look at the documentation shipped with SQLXML
3.0.
Chers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"rikesh" <rikesh_patel@.website.com> wrote in message
news:%23BdETGNZEHA.3476@.tk2msftngp13.phx.gbl...
Any ideas, how to do that, someone suggested FOR XML AUTO, ELEMENTS, but
that didn't work?
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:ua2LxDNZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> FOR XML produces XML fragments - not documents. You might need to add a
root
> element to the results in order to make it well-formed.
> Cheers,
> Graeme
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
> www.microsoft.com/mspress/books/6137.asp
>
> "rikesh" <rikesh_patel@.website.com> wrote in message
> news:ejMHMbMZEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Hi
> I'm trying to produce XML datasets to be used in Crystal Reports, but I
> cannot seem to view the XML output when produced.
> It just comes back with errors, when viewed in IE.
> The error is:
>
************************************************** **************************
> ********
> The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error
and
> then click the Refresh button, or try again later.
>
> ----
--
> --
> Only one top level element is allowed in an XML document. Error
processing
> resource 'file:///C:/Documents and Settings/hsrp...
> <Order_ Order_Date="1998-10-07T00:00:00" ConvertedDate="19981007"
> ConvertedDate1="19981007"/><Order_ Order_Date="19...
>
>
************************************************** **************************
> ********
> Any ideas why this is happening?
>
> --
> Kind Regards
> Rikesh
> (SQL2K-SP3/W2K-SP4)
>
>
|||Is this a separate component of SQL!!!
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:uR9QRPQZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> You can't do it in Transact-SQL in SQL Server 2000 (Yukon includes a ROOT
> directive). You need to do it on the client. The ADO and ADO.NET classes
> shipped with SQLXML have a RootTag property you can use, or you could use
a
> template or schema. Have a look at the documentation shipped with SQLXML
> 3.0.
> Chers,
> Graeme
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
> www.microsoft.com/mspress/books/6137.asp
>
> "rikesh" <rikesh_patel@.website.com> wrote in message
> news:%23BdETGNZEHA.3476@.tk2msftngp13.phx.gbl...
> Any ideas, how to do that, someone suggested FOR XML AUTO, ELEMENTS, but
> that didn't work?
>
> "Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
> news:ua2LxDNZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> root
>
************************************************** **************************
> and
> ----
> --
> processing
>
************************************************** **************************
>
>
|||http://www.microsoft.com/downloads/d...displaylang=en
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"rikesh" <rikesh_patel@.website.com> wrote in message
news:OtBYZUQZEHA.3752@.TK2MSFTNGP12.phx.gbl...
Is this a separate component of SQL!!!
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:uR9QRPQZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> You can't do it in Transact-SQL in SQL Server 2000 (Yukon includes a ROOT
> directive). You need to do it on the client. The ADO and ADO.NET classes
> shipped with SQLXML have a RootTag property you can use, or you could use
a
> template or schema. Have a look at the documentation shipped with SQLXML
> 3.0.
> Chers,
> Graeme
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
> www.microsoft.com/mspress/books/6137.asp
>
> "rikesh" <rikesh_patel@.website.com> wrote in message
> news:%23BdETGNZEHA.3476@.tk2msftngp13.phx.gbl...
> Any ideas, how to do that, someone suggested FOR XML AUTO, ELEMENTS, but
> that didn't work?
>
> "Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
> news:ua2LxDNZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> root
>
************************************************** **************************
> and
> ----
> --
> processing
>
************************************************** **************************
>
>
|||The root property is available in the OLEDB provider that ships with SQL
Server 2000. So it is not part of the server-side software but the client
component.
Best regards
Michael
"Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
news:uPWrT$QZEHA.136@.TK2MSFTNGP11.phx.gbl...
> http://www.microsoft.com/downloads/d...displaylang=en
> --
> --
> Graeme Malcolm
> Principal Technologist
> Content Master Ltd.
> www.contentmaster.com
> www.microsoft.com/mspress/books/6137.asp
>
> "rikesh" <rikesh_patel@.website.com> wrote in message
> news:OtBYZUQZEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Is this a separate component of SQL!!!
> "Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
> news:uR9QRPQZEHA.1152@.TK2MSFTNGP09.phx.gbl...
> a
> ************************************************** **************************
> ************************************************** **************************
>
>
|||Thanks chaps, I'll give it a try...
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:%23Yv8W1XZEHA.2840@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> The root property is available in the OLEDB provider that ships with SQL
> Server 2000. So it is not part of the server-side software but the client
> component.
> Best regards
> Michael
> "Graeme Malcolm" <graemem_cm@.hotmail.com> wrote in message
> news:uPWrT$QZEHA.136@.TK2MSFTNGP11.phx.gbl...
http://www.microsoft.com/downloads/d...displaylang=en[vbcol=seagreen]
ROOT[vbcol=seagreen]
classes[vbcol=seagreen]
use[vbcol=seagreen]
SQLXML[vbcol=seagreen]
but[vbcol=seagreen]
a[vbcol=seagreen]
I[vbcol=seagreen]
************************************************** **************************[vbcol=seagreen]
error[vbcol=seagreen]
-[vbcol=seagreen]
************************************************** **************************
>

For security reasons DTD is prohibited in this XML document.

When we develop with the Microsoft SQL Server 2005 Reporting Service.
We got the exception on some reports.

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on
XmlReaderSettings to false and pass the settings into XmlReader.Create method.

Ther report renders well first time, but if we click the title to sort the report, it will throw the exception.

And It occurred that we use IE6 and IE7 to view the report at same time, but if we use the same version brower, there are no exception.
Can somebody help me?

My development’s environment :
Windows XP English Professional + SP2
Microsoft SQL Server 2005 Development version + SP 1 + SP 2
Microsoft Visual Studio 2005 Professional Version 8.0.50727.51 (QFE.050727-5100) + SP1
Microsoft .NET Framework Version 2.0.50727

Hi Kevin,

We found an issue like this in a recent version of pre-release SQL 2005 Reporting Services SP2. If you are running versions of Reporting Services prior to SP2, please let me know. Otherwise, this will be fixed in the the final release of SP2.

|||

I'm seeing this occur in both SP1, and the CTP release of SP2.

Please advise. Reports render some of the time, but the vast majority I revceive the same error.

|||

We just installed SP2 in our organization. I am running a very large dataset which brings out about 4 million rows. When I run this report I am getting this error.

For security reasons DTD is prohibited in this XML document......

Please help...

For security reasons DTD is prohibited in this XML document.

When we develop with the Microsoft SQL Server 2005 Reporting Service.
We got the exception on some reports.

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on
XmlReaderSettings to false and pass the settings into XmlReader.Create method.

Ther report renders well first time, but if we click the title to sort the report, it will throw the exception.

And It occurred that we use IE6 and IE7 to view the report at same time, but if we use the same version brower, there are no exception.
Can somebody help me?

My development’s environment :
Windows XP English Professional + SP2
Microsoft SQL Server 2005 Development version + SP 1 + SP 2
Microsoft Visual Studio 2005 Professional Version 8.0.50727.51 (QFE.050727-5100) + SP1
Microsoft .NET Framework Version 2.0.50727

Hi Kevin,

We found an issue like this in a recent version of pre-release SQL 2005 Reporting Services SP2. If you are running versions of Reporting Services prior to SP2, please let me know. Otherwise, this will be fixed in the the final release of SP2.

|||

I'm seeing this occur in both SP1, and the CTP release of SP2.

Please advise. Reports render some of the time, but the vast majority I revceive the same error.

|||

We just installed SP2 in our organization. I am running a very large dataset which brings out about 4 million rows. When I run this report I am getting this error.

For security reasons DTD is prohibited in this XML document......

Please help...

For new in SSIS. To send data from operational d/base to data warehouse

Hi Dear All!

I am Crystal Reports Developer and I am new in SSIS environment. I have started to read Professional SQL Server 2005 IS book. I am really confused by many tasks to choose.

I need to develop reports from data warehouse. But before I have to send the data from operational database (SQL Server 2000) to warehouse (SQL Server 2005) monthly - I have a script for retrieving the data. For my package, I chose Data Flow Task, Execute SQL Task, and OLE DB Destination, and it does not work.

Please help me if I can look similar packages performing?

Thank you!!

You data-flow needs to contain more than just an OLE DB Destination. It needs an OLE DB Source as well.

-Jamie

|||

Also, consider watching the Kimball webcast on using SSIS in datawarehouses. It's on the main page of this forum and has very good information for beginners.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=534505&SiteID=1

|||

Thanks Jamie for your suggestion. Moreover, I will try to use SQL command in Data Access mode for OLE DB Source.

Corres

|||

Thanks Phil for your suggestion. To be honest, it is a bit complicated for me for now, but I have found a lot of useful info for me. Thanks.

Corres

|||When I started, I watched that webcast several times in order to pick up on several topics... Just give it time and play around with data and you'll get the hang of it.

For new in SSIS. To send data from operational d/base to data warehouse

Hi Dear All!

I am Crystal Reports Developer and I am new in SSIS environment. I have started to read Professional SQL Server 2005 IS book. I am really confused by many tasks to choose.

I need to develop reports from data warehouse. But before I have to send the data from operational database (SQL Server 2000) to warehouse (SQL Server 2005) monthly - I have a script for retrieving the data. For my package, I chose Data Flow Task, Execute SQL Task, and OLE DB Destination, and it does not work.

Please help me if I can look similar packages performing?

Thank you!!

You data-flow needs to contain more than just an OLE DB Destination. It needs an OLE DB Source as well.

-Jamie

|||

Also, consider watching the Kimball webcast on using SSIS in datawarehouses. It's on the main page of this forum and has very good information for beginners.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=534505&SiteID=1

|||

Thanks Jamie for your suggestion. Moreover, I will try to use SQL command in Data Access mode for OLE DB Source.

Corres

|||

Thanks Phil for your suggestion. To be honest, it is a bit complicated for me for now, but I have found a lot of useful info for me. Thanks.

Corres

|||When I started, I watched that webcast several times in order to pick up on several topics... Just give it time and play around with data and you'll get the hang of it.

For MS Development Team - SP2

Hello,
I am experiencing an issue with exporting to Excel - on some reports the
last row is missing. Is there a hot fix for this and/or is this addressed in
SP2 for Reporting Services?
TIA.
--
Chris HanleyMost likely:
http://www.ReportingServicesFAQ.com/ow.asp?SP2ForRS%3F
chanley54 wrote:
> Hello,
> I am experiencing an issue with exporting to Excel - on some reports the
> last row is missing. Is there a hot fix for this and/or is this addressed in
> SP2 for Reporting Services?
> TIA.

For EXPERTS: System.NullReferenceException: Object reference not .

I have a problem with a default implementation of Reporting Services with SP2
in one box, with SQL 2000 SP4.
The tool works fine, I have 10 Reports working without problems, but when I
want to execute one of them, this error message appears :
aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Error
inesperado al procesar los informes. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error
inesperado al procesar los informes. --> System.NullReferenceException:
Referencia a objeto no establecida como instancia de un objeto.
In English is something like:
System.NullReferenceException: Object reference not set to an
instance of an object.
Iâ'm using a sql function inside a DataSet and I probed it in SQL Analizer
and worked ok ( it took 20 seconds, is heavy) but when I executed the Report,
appeared that message. I changed the report execution timeout from the
Report Administration but still having the error.
If anyone have an idea ... I need help !!
Thanks!!
LEO.
Heres is my log:
aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error
inesperado al procesar los informes., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Error
inesperado al procesar los informes. --> System.NullReferenceException:
Referencia a objeto no establecida como instancia de un objeto.
at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d A_0)
at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
A_0, Boolean A_1)
at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
A_0, IList A_1, RenderingPagesRangesList A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
Boolean A_1, Int32 A_2)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0,
ReportItemCollection A_1)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0)
at Microsoft.ReportingServices.ReportProcessing.a0.b()
at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages A_0)
at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages A_0)
at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
A_0, Boolean A_1)
at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
A_0, IList A_1, RenderingPagesRangesList A_2)
at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
Boolean A_1, Int32 A_2)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0,
ReportItemCollection A_1)
at
Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance A_0)
at
Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
A_0, Boolean A_1)
at
Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
A_0, Boolean A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4, DateTime
A_5, CreateReportChunk A_6, ab& A_7)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- Fin del seguimiento de la pila de la excepción interna --This sounds like a bug. If you need further assistance, I suggest
contacting Microsoft Product Support. If it is indeed a bug and not user
error, any fees will be refunded.
--
| Thread-Topic: For EXPERTS: System.NullReferenceException: Object
reference not .
| thread-index: AcWTjhy6HiRzY1eyQ9OOA8fay/B5TA==| X-WBNR-Posting-Host: 24.232.107.196
| From: =?Utf-8?B?TGVv?= <Leo@.discussions.microsoft.com>
| Subject: For EXPERTS: System.NullReferenceException: Object reference not|||For the one report that has this problem - can you try to republish the RDL
of that report under a new name and check if the report runs then?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Leo" <Leo@.discussions.microsoft.com> wrote in message
news:4306B254-7122-4B67-851B-39331212141C@.microsoft.com...
>I have a problem with a default implementation of Reporting Services with
>SP2
> in one box, with SQL 2000 SP4.
> The tool works fine, I have 10 Reports working without problems, but when
> I
> want to execute one of them, this error message appears :
> aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
> error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: Error
> inesperado al procesar los informes. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Error
> inesperado al procesar los informes. --> System.NullReferenceException:
> Referencia a objeto no establecida como instancia de un objeto.
>
> In English is something like:
> System.NullReferenceException: Object reference not set to an
> instance of an object.
>
> I'm using a sql function inside a DataSet and I probed it in SQL Analizer
> and worked ok ( it took 20 seconds, is heavy) but when I executed the
> Report,
> appeared that message. I changed the report execution timeout from the
> Report Administration but still having the error.
> If anyone have an idea ... I need help !!
> Thanks!!
> LEO.
> Heres is my log:
> aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Error
> inesperado al procesar los informes., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Error
> inesperado al procesar los informes. --> System.NullReferenceException:
> Referencia a objeto no establecida como instancia de un objeto.
> at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> A_0, Boolean A_1)
> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> A_0, IList A_1, RenderingPagesRangesList A_2)
> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> Boolean A_1, Int32 A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0,
> ReportItemCollection A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.a0.b()
> at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
> A_0, Boolean A_1)
> at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
> A_0, IList A_1, RenderingPagesRangesList A_2)
> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> Boolean A_1, Int32 A_2)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0,
> ReportItemCollection A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
> A_0, Boolean A_1)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4,
> DateTime
> A_5, CreateReportChunk A_6, ab& A_7)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- Fin del seguimiento de la pila de la excepción interna --
>|||BTW, is this a report server that was upgraded from RS 2000 Beta 2, to RS
2000 RTM, and then to RS 2000 SP2?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:e55j%23%23%23kFHA.3260@.TK2MSFTNGP10.phx.gbl...
> For the one report that has this problem - can you try to republish the
> RDL of that report under a new name and check if the report runs then?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Leo" <Leo@.discussions.microsoft.com> wrote in message
> news:4306B254-7122-4B67-851B-39331212141C@.microsoft.com...
>>I have a problem with a default implementation of Reporting Services with
>>SP2
>> in one box, with SQL 2000 SP4.
>> The tool works fine, I have 10 Reports working without problems, but when
>> I
>> want to execute one of them, this error message appears :
>> aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
>> error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
>> Error
>> inesperado al procesar los informes. -->
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Error
>> inesperado al procesar los informes. --> System.NullReferenceException:
>> Referencia a objeto no establecida como instancia de un objeto.
>>
>> In English is something like:
>> System.NullReferenceException: Object reference not set to an
>> instance of an object.
>>
>> I'm using a sql function inside a DataSet and I probed it in SQL Analizer
>> and worked ok ( it took 20 seconds, is heavy) but when I executed the
>> Report,
>> appeared that message. I changed the report execution timeout from the
>> Report Administration but still having the error.
>> If anyone have an idea ... I need help !!
>> Thanks!!
>> LEO.
>> Heres is my log:
>> aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Error
>> inesperado al procesar los informes., ;
>> Info:
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Error
>> inesperado al procesar los informes. --> System.NullReferenceException:
>> Referencia a objeto no establecida como instancia de un objeto.
>> at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
>> A_0, Boolean A_1)
>> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
>> A_0, IList A_1, RenderingPagesRangesList A_2)
>> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
>> Boolean A_1, Int32 A_2)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0,
>> ReportItemCollection A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.a0.b()
>> at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages
>> A_0)
>> at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
>> A_0, Boolean A_1)
>> at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
>> A_0, IList A_1, RenderingPagesRangesList A_2)
>> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
>> Boolean A_1, Int32 A_2)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0,
>> ReportItemCollection A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
>> A_0)
>> at
>> Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
>> A_0, Boolean A_1)
>> at
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
>> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4,
>> DateTime
>> A_5, CreateReportChunk A_6, ab& A_7)
>> at
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
>> A_0,
>> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
>> CreateReportChunk A_4, Boolean& A_5)
>> -- Fin del seguimiento de la pila de la excepción interna --
>>
>|||Hi Robert. Thanks for your response.
I just republish the same report with a different name but still showing the
error.
RS was upgraded from RS2000 (8.00.743) directly to RS2000 SP2 (8.00.1042)
Its difficult to analize, because the sql function executes normally in SQL
Analizer (takes 18 seconds aprox), but RS shows that error.
Otherwise, the report executes ok with some parameters, but don't work if
those parameters mean to process lot of SQL registers (f.e: <All the tickets>
to process)
Is there a bug that don't support certain number of registers to process? I
don't think so ... but .....
Thanks again.
Leo.
"Robert Bruckner [MSFT]" wrote:
> BTW, is this a report server that was upgraded from RS 2000 Beta 2, to RS
> 2000 RTM, and then to RS 2000 SP2?
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:e55j%23%23%23kFHA.3260@.TK2MSFTNGP10.phx.gbl...
> > For the one report that has this problem - can you try to republish the
> > RDL of that report under a new name and check if the report runs then?
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Leo" <Leo@.discussions.microsoft.com> wrote in message
> > news:4306B254-7122-4B67-851B-39331212141C@.microsoft.com...
> >>I have a problem with a default implementation of Reporting Services with
> >>SP2
> >> in one box, with SQL 2000 SP4.
> >>
> >> The tool works fine, I have 10 Reports working without problems, but when
> >> I
> >> want to execute one of them, this error message appears :
> >>
> >> aspnet_wp!webserver!294!07/25/2005-16:06:56:: e ERROR: Reporting Services
> >> error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
> >> Error
> >> inesperado al procesar los informes. -->
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> >> Error
> >> inesperado al procesar los informes. --> System.NullReferenceException:
> >> Referencia a objeto no establecida como instancia de un objeto.
> >>
> >>
> >> In English is something like:
> >>
> >> System.NullReferenceException: Object reference not set to an
> >> instance of an object.
> >>
> >>
> >> I'm using a sql function inside a DataSet and I probed it in SQL Analizer
> >> and worked ok ( it took 20 seconds, is heavy) but when I executed the
> >> Report,
> >> appeared that message. I changed the report execution timeout from the
> >> Report Administration but still having the error.
> >>
> >> If anyone have an idea ... I need help !!
> >> Thanks!!
> >> LEO.
> >>
> >> Heres is my log:
> >>
> >> aspnet_wp!processing!3a4!07/28/2005-12:48:29:: e ERROR: Throwing
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> >> Error
> >> inesperado al procesar los informes., ;
> >> Info:
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> >> Error
> >> inesperado al procesar los informes. --> System.NullReferenceException:
> >> Referencia a objeto no establecida como instancia de un objeto.
> >> at Microsoft.ReportingServices.ReportProcessing.ReportItemInstance.b(d
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.o.a(MatrixHeadingInstanceList
> >> A_0, Boolean A_1)
> >> at Microsoft.ReportingServices.ReportProcessing.o.a(ReportItemInstance
> >> A_0, IList A_1, RenderingPagesRangesList A_2)
> >> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> >> Boolean A_1, Int32 A_2)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0,
> >> ReportItemCollection A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.a0.b()
> >> at Microsoft.ReportingServices.ReportProcessing.c.c(ProcessingStages
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.c.d(ProcessingStages
> >> A_0)
> >> at Microsoft.ReportingServices.ReportProcessing.ac.a(ProcessingStages
> >> A_0, Boolean A_1)
> >> at Microsoft.ReportingServices.ReportProcessing.a4.a(ReportItemInstance
> >> A_0, IList A_1, RenderingPagesRangesList A_2)
> >> at Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItem A_0,
> >> Boolean A_1, Int32 A_2)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0,
> >> ReportItemCollection A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.a9.a(ReportItemColInstance
> >> A_0)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.bb.a(ParameterInfoCollection
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.bb.b(ParameterInfoCollection
> >> A_0, Boolean A_1)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report
> >> A_0, ProcessingContext A_1, Boolean A_2, GetReportChunk A_3, az A_4,
> >> DateTime
> >> A_5, CreateReportChunk A_6, ab& A_7)
> >> at
> >> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> >> A_0,
> >> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> >> CreateReportChunk A_4, Boolean& A_5)
> >> -- Fin del seguimiento de la pila de la excepción interna --
> >>
> >>
> >
> >
>
>

Footer problems

Hi all,
I've got a couple of problems with some reports that I'm developing:
1) I'm trying to print a Group Footer at the bottom of the page in a fixed
position, regardless of how many detail records there are. Is there a way
to do this?
2) I have another report that is supposed to give page totals on each page,
as well as a grand total at the end of the report. Since I can't put any
fields in the Page Footer, and I can't use the Global Page variables in the
Body, how can I get these totals to appear correctly?
Thank you very much in advance,
JimJim wrote:
> Hi all,
> I've got a couple of problems with some reports that I'm developing:
> 1) I'm trying to print a Group Footer at the bottom of the page in a
> fixed position, regardless of how many detail records there are. Is
> there a way to do this?
> 2) I have another report that is supposed to give page totals on each
> page, as well as a grand total at the end of the report. Since I
> can't put any fields in the Page Footer, and I can't use the Global
> Page variables in the Body, how can I get these totals to appear
> correctly?
> Thank you very much in advance,
> Jim
I'll tackle number 2 first;
In a table footer you can use the 'RunningValue' function instead of
'Sum' and make sure the footer is set to 'Repeat on each page'.
Number 1 is not currently acheivable.
Rectangles are the key to semi-absolute positioning, but unless your
report is alway a one page report (i.e. an invoice) you won't be able
to do it.
Merry Christmas
Chris|||HI
I am also trying to do the same. But I cannot achieve it. Which scope do I
have to give' Can you please give me an example?
"Chris McGuigan" wrote:
> Jim wrote:
> > Hi all,
> >
> > I've got a couple of problems with some reports that I'm developing:
> >
> > 1) I'm trying to print a Group Footer at the bottom of the page in a
> > fixed position, regardless of how many detail records there are. Is
> > there a way to do this?
> >
> > 2) I have another report that is supposed to give page totals on each
> > page, as well as a grand total at the end of the report. Since I
> > can't put any fields in the Page Footer, and I can't use the Global
> > Page variables in the Body, how can I get these totals to appear
> > correctly?
> >
> > Thank you very much in advance,
> >
> > Jim
> I'll tackle number 2 first;
> In a table footer you can use the 'RunningValue' function instead of
> 'Sum' and make sure the footer is set to 'Repeat on each page'.
> Number 1 is not currently acheivable.
> Rectangles are the key to semi-absolute positioning, but unless your
> report is alway a one page report (i.e. an invoice) you won't be able
> to do it.
> Merry Christmas
> Chris
>|||Hey Soan,
I actually have found out how to do this stuff, although it was pretty
nasty. MS needs to come up with something better than it has thus far.
First off, the RunningValue function did not work for me in the table
footer. What I ended up doing was adding another Detail row, and added an
expression to the Hidden property of that row that hides it unless it goes
at the bottom of the page. I calculated the number of detail rows that fit
on each page, then used the Mod function of the RowNumber as such:
RowNumber(Nothing) Mod x = 0, where x is the number of rows that fit in a
page. I then added a TextBox to that new Detail row and included the
RunningValue function in it; that worked!
As for positioning on the page, well, that is similar. I have two stored
procedures, one of which calculates the total number of detail rows that
will show up on the report, then subtracts that from the (number of pages *
max rows per page). I then created a dummy table with no controls in the
detail row (no header or footer row either), and set the row source to that
extra row calculation sproc. This worked, but I hate it.
FYI, I tried Chris' solution of using rectangles, but I couldn't get the
Height property to accept an expression (according to BOL, it shouldn't
anyway), so I have no idea how he meant I could use rectangles.
Jim
"Soan" <Soan@.discussions.microsoft.com> wrote in message
news:01963902-278F-4A66-BE25-276F8115F8B1@.microsoft.com...
> HI
> I am also trying to do the same. But I cannot achieve it. Which scope do I
> have to give' Can you please give me an example?
>
> "Chris McGuigan" wrote:
>> Jim wrote:
>> > Hi all,
>> >
>> > I've got a couple of problems with some reports that I'm developing:
>> >
>> > 1) I'm trying to print a Group Footer at the bottom of the page in a
>> > fixed position, regardless of how many detail records there are. Is
>> > there a way to do this?
>> >
>> > 2) I have another report that is supposed to give page totals on each
>> > page, as well as a grand total at the end of the report. Since I
>> > can't put any fields in the Page Footer, and I can't use the Global
>> > Page variables in the Body, how can I get these totals to appear
>> > correctly?
>> >
>> > Thank you very much in advance,
>> >
>> > Jim
>> I'll tackle number 2 first;
>> In a table footer you can use the 'RunningValue' function instead of
>> 'Sum' and make sure the footer is set to 'Repeat on each page'.
>> Number 1 is not currently acheivable.
>> Rectangles are the key to semi-absolute positioning, but unless your
>> report is alway a one page report (i.e. an invoice) you won't be able
>> to do it.
>> Merry Christmas
>> Chris|||Hi Jim/Soan,
Soan, you asked about scope, generally I use 'Nothing' which instructs
RS to work it out for you! For basic reports you could use the dataset
name (in double quotes!).
You can set a group footer to repeat on each page (see 'Edit Group
Properties' and check 'Repeat Footer on each page')
Use the RunningValue function of the form
RunningValue(Fields!Amount.Value, Sum, Nothing), this should do it.
Note! This is not a page total but a running total!
Jim, your method is fine as long as you don't start grouping or have
conditionally hidden lines, then tracking where you are on the page
becomes a nightmare.
The rectangle solution only really works if can get prints on one page.
You place a rectangle exactly where you want it on the page and how big
you want, then place a data region inside it and make the data region
display what you want, i.e. the totals.
As Jim said, Microsoft haven't really provided an adequate way of
achieving this.
Regards
Chris
Jim wrote:
> Hey Soan,
> I actually have found out how to do this stuff, although it was
> pretty nasty. MS needs to come up with something better than it has
> thus far.
> First off, the RunningValue function did not work for me in the table
> footer. What I ended up doing was adding another Detail row, and
> added an expression to the Hidden property of that row that hides it
> unless it goes at the bottom of the page. I calculated the number of
> detail rows that fit on each page, then used the Mod function of the
> RowNumber as such: RowNumber(Nothing) Mod x = 0, where x is the
> number of rows that fit in a page. I then added a TextBox to that
> new Detail row and included the RunningValue function in it; that
> worked!
> As for positioning on the page, well, that is similar. I have two
> stored procedures, one of which calculates the total number of detail
> rows that will show up on the report, then subtracts that from the
> (number of pages * max rows per page). I then created a dummy table
> with no controls in the detail row (no header or footer row either),
> and set the row source to that extra row calculation sproc. This
> worked, but I hate it.
> FYI, I tried Chris' solution of using rectangles, but I couldn't get
> the Height property to accept an expression (according to BOL, it
> shouldn't anyway), so I have no idea how he meant I could use
> rectangles.
> Jim
> "Soan" <Soan@.discussions.microsoft.com> wrote in message
> news:01963902-278F-4A66-BE25-276F8115F8B1@.microsoft.com...
> > HI
> >
> > I am also trying to do the same. But I cannot achieve it. Which
> > scope do I have to give' Can you please give me an example?
> >
> >
> > "Chris McGuigan" wrote:
> >
> >> Jim wrote:
> > >
> >> > Hi all,
> >> >
> >> > I've got a couple of problems with some reports that I'm
> developing: >> >
> >> > 1) I'm trying to print a Group Footer at the bottom of the page
> in a >> > fixed position, regardless of how many detail records there
> are. Is >> > there a way to do this?
> >> >
> >> > 2) I have another report that is supposed to give page totals on
> each >> > page, as well as a grand total at the end of the report.
> Since I >> > can't put any fields in the Page Footer, and I can't use
> the Global >> > Page variables in the Body, how can I get these
> totals to appear >> > correctly?
> >> >
> >> > Thank you very much in advance,
> >> >
> >> > Jim
> > >
> >> I'll tackle number 2 first;
> >> In a table footer you can use the 'RunningValue' function instead
> of >> 'Sum' and make sure the footer is set to 'Repeat on each page'.
> > >
> >> Number 1 is not currently acheivable.
> >> Rectangles are the key to semi-absolute positioning, but unless
> your >> report is alway a one page report (i.e. an invoice) you won't
> be able >> to do it.
> > >
> >> Merry Christmas
> >> Chris
> >>