Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Error occurred during local report processing

Author  Topic 

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 01:51:18
-
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 02:54:04
that means you dont have TERMINAL_ID in the dataset which you've linked to container that contains textbox75

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 03:00:57
so how do i solve this problem?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 03:04:10
make sure you return TERMINAL_ID also in dataset which you're refering in textbox75
or map textbox75 to correct dataset which contains required column.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 03:10:22
can you teach me how to do this? im v new to this so i don't know how to do it. Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 04:11:46
do you know which dataset you've linked to inside container that has textbox75?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 04:17:51
erm i am not sure. but under textbox75 the value is =Fields!TERMINAL_ID.Value. is the information you want?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 04:30:51
nope. right click the container that contains this textbox and select properties. in properties tab what is the dataset its pointing to?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 04:38:58
erm where is the properties tab? in my textbox properties, there is the following tabs: general,visibility, navigation, font, format, interactive sort and data output.

If i click on the dropdown button on the values box, it reads 'V_OPS_DLY_AGING_DTL' dataset has no fields
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 05:33:55
what? thats not possible. which reporting services version are you using?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 05:36:22
hmm how do i check the version?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 06:14:43
click on help-> about visual studio and check the version

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 06:24:40
Microsoft Visual Studio 2005
Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727

Installed Edition: IDE Standard

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.4035.00

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.4035.00

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.4035.00
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-12 : 07:24:41
so its 2005. try clicking view-> datasets from top menu and see whether it lists the 'V_OPS_DLY_AGING_DTL' dataset. if yes, expand it and see what all fields it return

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-12 : 20:44:25
Thanks i have solved the problem now.

But i have another problem which is..

An error occurred during local report processing.
The definition of the report '/DetailByTerminal-days' is invalid.
the hyperlink expression for the textbox 'textbox2' refers to a non-existing report parameter 'Para_ServerName'.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-13 : 00:10:20
it seems you've a jump to report/url expression pointing to another report in one of your cells which is having a parameter that doesnt exist in the other report. check cell properties of each and see which of cell is having jump to report/url functionality

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-13 : 00:13:30
Can you teach me how to do it? Thanks for the help
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-13 : 00:54:32
right click on cell and select properties go to navigation tab and look in jump to url or jump to report

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-13 : 01:32:04
under my jump to url , these are my codes

=Parameters!Para_ServerName.Value & "Pages/ReportViewer.aspx?%2fEODW+Cntr%2fCntrAging+Rpts%2fsearchByTerminal&Terminal=" & Parameters!Terminal.Value & "lessthan50" & Parameters!lessthan50.Value & "morethan50" & Parameters!morethan50.Value & "&rs:Command=Render&rs:Format=CSV&rc:Encoding=ASCII"

is there anything wrong with it?

when i check the output, it gives me these details..

[rsParameterReference] The Hyperlink expression for the textbox ‘textbox2’ refers to a non-existing report parameter ‘Para_ServerName’.
[rsParameterReference] The Hyperlink expression for the textbox ‘textbox2’ refers to a non-existing report parameter ‘lessthan50’.
[rsParameterReference] The Hyperlink expression for the textbox ‘textbox2’ refers to a non-existing report parameter ‘morethan50’.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-09-13 : 02:17:33
chekc if you've Parameters lessthan50,morethan50,Para_ServerName etc in your report by opening parameters tab

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

somenoob
Posting Yak Master

112 Posts
Posted - 2011-09-13 : 02:23:37
under my Para_ServerName, i have check the parameters tab and there is no data in there.
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site