Forcing Reporting Services to update with new query?

Take a look and see how long the old version of the report is cached for. Andrew Watt MVP - InfoPath wrote in message news:cf32036e-8c31-4697-b1aa-a45e1bf9089c@.discussions.microsoft.com... >I had a minor error in my query that i corrected, but RS for some reason
> is still using the 'old' query rather than the new 1. >
> I have redeployed the report, rebooted the machine and restarted IIS,
> but to no avail, it is still using the incorrect 'old query. > >
> Any help?
>I had a minor error in my query that i corrected, but RS for some reason is still using the 'old' query rather than the new 1.

I have redeployed the report, rebooted the machine and restarted IIS, but to no avail, it is still using the incorrect 'old query.
Any help?|||There are many reasons that this could be happening, for example, did you check that there were no errors in the build/deploy. Is the report being deployed to the correct server and to the correct folder.

Have you tried deleteing the old report then redeploying it, this will help you to determine where this behavior is coming from. If you try this and it still doesn't work then the problem is somewhere in the report project.

Try this and post what happens.|||Thanks, i have indeed deleted the datasource and the report and redeployed them, but still the same problem.
The report works perfectly in VS2005 preview, yet i get the same error when its is deployed
(If i select an @.FromDate from any month besides september i get the error 'The value provided for the report parameter 'FromDate' is not valid for its type. (rsReportParameterTypeMismatch)' )

Here is my code:
I am trying to select clicks between date ranges
SELECT MIN(A.hitDate) AS minDate, D.AffiliateName, B.ProdType, COUNT(DISTINCT A.ipAddress) AS TOTAL
FROM ArchiveApplyTracking A LEFT OUTER JOIN
ExpertMatchConfiguration.dbo.Affiliates D ON A.affiliateID = D.AffiliateID LEFT OUTER JOIN
ArchiveCampaignIncoming C ON A.campaignID = C.ID LEFT OUTER JOIN
ExpertMatchConfiguration.dbo.ProductType B ON A.productTypeID = B.ProdNo
WHERE (A.hitDate >=@.FromDate) and (A.hitDate <@.ToDate) AND (A.ipAddress NOT IN
(SELECT ipAddress
FROM [ExpertMatchTracking].[dbo].ipTracking)) AND (B.ProdType IN (@.ProductType)) AND (B.ProdType NOT LIKE 'refused%') AND (A.deal = 1) AND (D.AffiliateName IN (@.AffiliateName)) AND (B.ProdType NOT LIKE '%prequalify%')
GROUP BY D.AffiliateName, B.ProdType
ORDER BY D.AffiliateName
There must be an error in the deployment as it works 100% in the preview
Thanks for your input
|||

Only thing I can think of is the format of the date. If the format is incorrect then it will appear to work for some dates but then it will not work for others.

|||Thanks, i cant fathom why it works fine in preview, but falls over completly in the deployed report. Nor do i think there is anything from with the date format, it is pretty straight-forward.
But thanks anyway
|||You could try to delete existing report from report server before deploying.

Forcing page breaks

Hello,
Apologies if this is a silly question. I am using Reporting services with
ODBC to convert print image text files into pdb files. Each record/line of
the file has one character code then the data for the line of the report. I
used odbc to describe the file to have 2 columns. The columns are ID and
Data.
Now for the question: I need to force a page break whenever the contents of
the ID column are a '1'. THis sounds like it should be really easy, but I
cannot seem to figure out how to do this.
ThanksI have an example on www.msbicentral.com which allows you to do a page break
after X number of lines. The example (if I remember correctly) uses an
expression for the page break. You could simply change the expression.
Search for Page or Page Break in the Downloads->Reporting Services ->RDL
section
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:DB2E845D-875B-4770-8C3E-4D0E06ACCFBE@.microsoft.com...
> Hello,
> Apologies if this is a silly question. I am using Reporting services with
> ODBC to convert print image text files into pdb files. Each record/line
> of
> the file has one character code then the data for the line of the report.
> I
> used odbc to describe the file to have 2 columns. The columns are ID and
> Data.
> Now for the question: I need to force a page break whenever the contents
> of
> the ID column are a '1'. THis sounds like it should be really easy, but I
> cannot seem to figure out how to do this.
> Thanks|||Wayne,
Thanks for the tip. Unfortunately, I cannot seem to get it to work. My
data is tabular and not a matrix (tho I have tried both). When ever I add
any group the order of the data gets all fubar(ed) and I cannot seem to stop
it from doing this. The darn reports takes all the ID=1 rows(which is the
first line of each page) and puts them all at the top of the report.
Any more help you can off would be appreciated, but as always the search
continues.
Thanks
Stan
"Wayne Snyder" wrote:
> I have an example on www.msbicentral.com which allows you to do a page break
> after X number of lines. The example (if I remember correctly) uses an
> expression for the page break. You could simply change the expression.
> Search for Page or Page Break in the Downloads->Reporting Services ->RDL
> section
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Stan" <Stan@.discussions.microsoft.com> wrote in message
> news:DB2E845D-875B-4770-8C3E-4D0E06ACCFBE@.microsoft.com...
> > Hello,
> >
> > Apologies if this is a silly question. I am using Reporting services with
> > ODBC to convert print image text files into pdb files. Each record/line
> > of
> > the file has one character code then the data for the line of the report.
> > I
> > used odbc to describe the file to have 2 columns. The columns are ID and
> > Data.
> >
> > Now for the question: I need to force a page break whenever the contents
> > of
> > the ID column are a '1'. THis sounds like it should be really easy, but I
> > cannot seem to figure out how to do this.
> >
> > Thanks
>
>|||I would love to hear a better answer, but if there isn't any other way...
How about using a custom function that acts as a counter that incremented
every time there was a 1? So the data would look something like:
counter ID Data
0 | 0 | xyz
0 | 0 | xyz
0 | 0 | xyz
1 | 1 | xyz
1 | 0 | xyz
1 | 0 | xyz
2 | 1 | xyz
2 | 0 | xyz
2 | 0 | xyz
etc.
Then, you could group by that function and put page breaks after each group.
A simple function could look something like:
Private x As Integer
Public Function addone(ByVal num As Integer) As Integer
x = x + num
Return x
End Function
The function doesn't actually need to be on the report, just use it to
group. Insert a group and for the expression:
=code.addone(Fields!id.value)
Mike G.
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:191002EE-50DD-4FEA-80DC-70A5D3A95DB4@.microsoft.com...
> Wayne,
> Thanks for the tip. Unfortunately, I cannot seem to get it to work. My
> data is tabular and not a matrix (tho I have tried both). When ever I add
> any group the order of the data gets all fubar(ed) and I cannot seem to
> stop
> it from doing this. The darn reports takes all the ID=1 rows(which is the
> first line of each page) and puts them all at the top of the report.
> Any more help you can off would be appreciated, but as always the search
> continues.
> Thanks
> Stan
>
> "Wayne Snyder" wrote:
>> I have an example on www.msbicentral.com which allows you to do a page
>> break
>> after X number of lines. The example (if I remember correctly) uses an
>> expression for the page break. You could simply change the expression.
>> Search for Page or Page Break in the Downloads->Reporting Services ->RDL
>> section
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>> I support the Professional Association of SQL Server (PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>> "Stan" <Stan@.discussions.microsoft.com> wrote in message
>> news:DB2E845D-875B-4770-8C3E-4D0E06ACCFBE@.microsoft.com...
>> > Hello,
>> >
>> > Apologies if this is a silly question. I am using Reporting services
>> > with
>> > ODBC to convert print image text files into pdb files. Each
>> > record/line
>> > of
>> > the file has one character code then the data for the line of the
>> > report.
>> > I
>> > used odbc to describe the file to have 2 columns. The columns are ID
>> > and
>> > Data.
>> >
>> > Now for the question: I need to force a page break whenever the
>> > contents
>> > of
>> > the ID column are a '1'. THis sounds like it should be really easy,
>> > but I
>> > cannot seem to figure out how to do this.
>> >
>> > Thanks
>>|||Mike,
I was on this track, but could not get it right. You hit the nail right on
the head.
Thanks!!!
Stan
"Mike G." wrote:
> I would love to hear a better answer, but if there isn't any other way...
> How about using a custom function that acts as a counter that incremented
> every time there was a 1? So the data would look something like:
> counter ID Data
> 0 | 0 | xyz
> 0 | 0 | xyz
> 0 | 0 | xyz
> 1 | 1 | xyz
> 1 | 0 | xyz
> 1 | 0 | xyz
> 2 | 1 | xyz
> 2 | 0 | xyz
> 2 | 0 | xyz
> etc.
> Then, you could group by that function and put page breaks after each group.
> A simple function could look something like:
> Private x As Integer
> Public Function addone(ByVal num As Integer) As Integer
> x = x + num
> Return x
> End Function
> The function doesn't actually need to be on the report, just use it to
> group. Insert a group and for the expression:
> =code.addone(Fields!id.value)
> Mike G.
> "Stan" <Stan@.discussions.microsoft.com> wrote in message
> news:191002EE-50DD-4FEA-80DC-70A5D3A95DB4@.microsoft.com...
> > Wayne,
> >
> > Thanks for the tip. Unfortunately, I cannot seem to get it to work. My
> > data is tabular and not a matrix (tho I have tried both). When ever I add
> > any group the order of the data gets all fubar(ed) and I cannot seem to
> > stop
> > it from doing this. The darn reports takes all the ID=1 rows(which is the
> > first line of each page) and puts them all at the top of the report.
> >
> > Any more help you can off would be appreciated, but as always the search
> > continues.
> >
> > Thanks
> >
> > Stan
> >
> >
> >
> > "Wayne Snyder" wrote:
> >
> >> I have an example on www.msbicentral.com which allows you to do a page
> >> break
> >> after X number of lines. The example (if I remember correctly) uses an
> >> expression for the page break. You could simply change the expression.
> >>
> >> Search for Page or Page Break in the Downloads->Reporting Services ->RDL
> >> section
> >>
> >> --
> >> Wayne Snyder, MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >> www.mariner-usa.com
> >> (Please respond only to the newsgroups.)
> >>
> >> I support the Professional Association of SQL Server (PASS) and it's
> >> community of SQL Server professionals.
> >> www.sqlpass.org
> >>
> >> "Stan" <Stan@.discussions.microsoft.com> wrote in message
> >> news:DB2E845D-875B-4770-8C3E-4D0E06ACCFBE@.microsoft.com...
> >> > Hello,
> >> >
> >> > Apologies if this is a silly question. I am using Reporting services
> >> > with
> >> > ODBC to convert print image text files into pdb files. Each
> >> > record/line
> >> > of
> >> > the file has one character code then the data for the line of the
> >> > report.
> >> > I
> >> > used odbc to describe the file to have 2 columns. The columns are ID
> >> > and
> >> > Data.
> >> >
> >> > Now for the question: I need to force a page break whenever the
> >> > contents
> >> > of
> >> > the ID column are a '1'. THis sounds like it should be really easy,
> >> > but I
> >> > cannot seem to figure out how to do this.
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>

Force No Page Break

Hi --
I have a Report that generates a table with a lot of rows. Reporting
Services breaks my report up into 13 pages. I'd like it to be all one giant
table. Is there a way to force no page breaks?
Thank you!In RS 2005, html only you can do this. It is a report property (not a table
property) called interactive size. I believe you put in 0 for it no not have
page breaks.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dev648237923" <dev648237923@.noemail.noemail> wrote in message
news:%23$WNcbc0GHA.3568@.TK2MSFTNGP03.phx.gbl...
> Hi --
> I have a Report that generates a table with a lot of rows. Reporting
> Services breaks my report up into 13 pages. I'd like it to be all one
> giant table. Is there a way to force no page breaks?
> Thank you!
>|||Thanks -- I set it to 0,0 and that worked great!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eL6Iubd0GHA.1040@.TK2MSFTNGP06.phx.gbl...
> In RS 2005, html only you can do this. It is a report property (not a
> table property) called interactive size. I believe you put in 0 for it no
> not have page breaks.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "dev648237923" <dev648237923@.noemail.noemail> wrote in message
> news:%23$WNcbc0GHA.3568@.TK2MSFTNGP03.phx.gbl...
>> Hi --
>> I have a Report that generates a table with a lot of rows. Reporting
>> Services breaks my report up into 13 pages. I'd like it to be all one
>> giant table. Is there a way to force no page breaks?
>> Thank you!
>>
>

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 --
> >>
> >>
> >
> >
>
>

for any button click event

Hi All,

I am new to sql server 2005.

I have developed an new report using sql server 2005

repoting services in Business intelligent Development studio

so any one can help me how to include this report

on any aspx page

ex for any button click event the report must be generated.

So please any one of you help me out.

Sandy,

From the FAQ's at: http://www.microsoft.com/sql/technologies/reporting/faq.mspx

Q. How can I add Reporting Services reports to my application?

A. Visual Studio 2005 (Standard and Enterprise editions) contains a set of freely redistributable Report Viewer controls that make it easy to embed Reporting Services functionality into custom applications. Two versions of the Report Viewer exist, one for rich Windows client applications and one for ASP.NET applications.

If you want more granular control, once the report is published to the report server you will notice that it has a URL. Simple link to that URL with a hyperlink, or, do a response.redirect or server.transfer on a button's click event. Once you have the full url to the report you can start playing with it to get the results you want. (i.e. Button 1 passes parameter(s) A, button2 passes parameter(s) B etc.)

For more guidence I suggest:

http://msdn2.microsoft.com/en-us/library/ms365308.aspx

http://www.microsoft.com/sql/technologies/reporting/default.mspx