Category: .NET

21 Mar 2017 18:47

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	5

Issue with Crystal Report

Hi All,

I have a issue with crystal report which was developed long before.
When I pass a parameter and start running the report I am getting a issue like "Object not found".
It is clear that the particular SQL object/Column is not more available in the database so its displaying the error.

Issue something like this,


if{(table.Column1)} = "Test" then
2
Else
3


But my issue is how to find where is this formula percent, The Crystal report not showing exactly where this formula coming from. It is just showing the issue alone.

How to find, from which field this formula is applied?



                                


#769091
24 Mar 2017 09:02
Joined: 03/05/2013
Level: Gold
Points: 15822
Points: 2
Hi,

As you said this is because of column present issue, I suggest you to check whether column is exist first, if it is exists then do whatever you want.

Ex:

if(table.Columns.Contains("ColumnName"))
{
     // do your stuff here
}


Hope this helps you...
--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog :  http://naveens-dotnet.blogspot.in/
#769105
25 Mar 2017 11:45
Joined: 13/06/2007
Level: Gold
Points: 21327
Points: 2
I think you need to backtrack your crystal report design, first check if the formula is attached in crystal report design or its in your code behind, try to remove columns one by one and check if the error goes off.
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS] 
#769254
18 Jun 2017 09:47
Joined: 16/10/2011
Level: Silver
Points: 313
Points: 2
Hello,

If the formula is present in the crystal report then you can check it in the field explorer and see the formula variables and parameters.
Regards,
Dhiraj C. Solanki

Issue with Crystal Report

About dotnetspider.com

Quick Links

General

Services