Showing BigInt in Crystal Reports

[Crazyec]

I have created a table in MS SQL Server which have a BigInt field. I wanna show it in the crystal report, but it always got 0 (my crystal report version is 8.5)
Anyone has suggestions?

 

[synapsevampire]

Create a SQL Expression something like:

CAST(table.bigintfield AS varchar)

-k

 

[Crazyec]

Since I do that by adding the table to the report, may I know how to edit the SQL in the report? Thank you.

 

[synapsevampire]

You don't edit the SQl in the report, you right click SQl Expressions in the field explorer and select NEW.

Then Crystal inserts it into the SQL.

SQL Expressions are one of the lesser used, most powerful things in Crystal, especially in CR 8.5, you can even do correlated subqueries with them.

In your case it will just add the cast statement into the Select part of the sql, so the database does the heavy lifting.

-k

 

[Crazyec]

Thank you k,
It works great.
One more question on that. I need to mark the Thousands Separator, is there any function for that?