Please help me solve this problem

Hello All,
I am new to crystalreport am using crystalreport 8.5. I have to provide the link for
a column whose value is > 1000. i don't want to suppress the values other than1000.
My Problem is the link should be enabled only when the value is > 1000. Please share your experience to solve this problem.
Thanks in advance
Vasuformat the field of the column using a formula..

if(value>100, "link text" & value, value)

?|||Thanks a lot cjard. it works well. the link is enabled for value > 1000
thanks and regards
Vasu

Please assist with common error 2147467259

I'm not sure if I'm even starting at the right place.

We have a web portal that we use to send email TSN Templates. When we press this link, it queries our SQL database but then times out. When we go to our logs to see waht has happened, this is what we get: Can anyone point me in the right direction?

Timestamp: 15/08/2007 9:00:13 AM
Message: HandlingInstanceID: 5228cfc1-fbc3-4c64-98ab-468d0a99ba85
An exception of type 'System.Web.HttpException' occurred and was caught.

08/15/2007 19:00:13
Type : System.Web.HttpException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Message : Request timed out.
Source :
Help link :
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite :
Stack Trace : The stack trace is unavailable.
Additional Info:

MachineName :
TimeStamp : 15/08/2007 9:00:13 AM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.0.2697.40343, Culture=neutral, PublicKeyToken=d6be776f5b1b3d1f
AppDomainName : /LM/W3SVC/1/ROOT-1-128316415134243452
ThreadIdentity :

WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine:

Application Domain: /LM/W3SVC/1/ROOT-1-128316415134243452
Process Id: 36976
Process Name: C:\WINDOWS\SysWOW64\inetsrv\w3wp.exe
Win32 Thread Id: 35804
Thread Name:
Extended Properties:

For more information, see Help and Support Center at

This is an asp.net / enterprise library problem.

You may want to post in these links.

http://forums.asp.net

http://www.codeplex.com/entlib/Thread/List.aspx

But from the message all I can see is that the application is timing out either when connecting to database or when sending email, I cannot tell for sure, with the limited information above.

Thanks

Pivot Error

i am fallowing this link

http://sqljunkies.com/Article/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk

last 15 th i am unable to understatnd the value to set tht pivotkey value for the output columns

INPUT COLUMNS LEGEND ID

CUSTOMER 861

PRODUCT 864

ID

OUPUT COLUMNS SOUREC COLUMN PIVOT KEY VALUE

CUSTOMER 861 ?

HamQty 864 ?

MILKQTY 864 ?

BEERQTY 864 ?

BREADQTY 864 ?

CHESSQTY 864 ?

HAMQTY CANNOT MAPPED WITH PIVOTKEY VALUE ERROR I AM GETTING

PLEASE HELP ME

You have run into a special degenerate case for the Pivot transform.

You do not have a pivot value. You simply have customers that purchase products, but you have no measurement such as “quantity” associated with the purchase. The existence of the row acts as a measure.

So what is the pivot value? There is not one.

You can set the lineage ID for the output columns to “-1” this is a special case use. When you do so, the value “TRUE” will be put into columns that have matching existing rows in the source.

This also means that your output columns need to be BOOLEAN typed so they can hold the value TRUE. (or NULL if not matched)

to use your example:

Input data

Customer(861) Product (864)

(the set key) (the pivot key)

-

JohnCheese

JohnBread

BillHam

Turns into

Customer CheeseExists BreadExists HamExists BeerExists

-- -- -

JohnTRUETRUENULL NULL

BillNULLNULLTRUENULL

Your output columns would be:

NameType SourceColumn PivotKeyValue

-- -

Customerchar861

CheeseExists VT_BOOL-1Cheese

BreadExistsVT_BOOL-1Bread

HamExistsVT_BOOL-1Ham

BeerExistsVT_BOOL-1Beer