Crystal Reports Forum : Tips and Tricks http://www.crystalreportsbook.com/forum This is an XML content feed of; Crystal Reports Forum : Tips and Tricks : Last 10 Posts Sat, 14 Mar 2026 16:37:49 +0000 Wed, 07 Sep 2022 04:25:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 8.04 30 www.crystalreportsbook.com/forum/RSS_topic_feed.asp?FID=19 Tips and Tricks : Sorting of datetime field is not working http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23017&PID=75329#75329 Author: kevlray
Subject: Sorting of datetime field is not working
Posted: 07 Sep 2022 at 4:25am

The other way is to use formulas and break out the time parts and do sorting/grouping by them. i.e., left(cstr({datetimefield}),2) to get the hours.
]]> Wed, 07 Sep 2022 04:25:52 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23017&PID=75329#75329 Tips and Tricks : Sorting of datetime field is not working http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23017&PID=75328#75328 Author: lockwelle
Subject: Sorting of datetime field is not working
Posted: 06 Sep 2022 at 5:27pm

DateTime sorting is not as straight forward as you would think.

I always build a group, then I can go into the grouping properties, and for DateTime you need to specify if it is by the day, the week, and a couple of other ways.

Try them out. Most likely it is set for By Week, which I think is the default.

Hopefully, this will get you pointed in the right direction.]]> Tue, 06 Sep 2022 17:27:14 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23017&PID=75328#75328 Tips and Tricks : Sorting of datetime field is not working http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23017&PID=75327#75327 Author: DDSJ
Subject: Sorting of datetime field is not working
Posted: 05 Sep 2022 at 4:18am

I have a datetime field in report which have time values (ascending order) like :
00:01:00,07:00:00, 13:01:00, 14:00:19
I have applied the ascending sorting in the report using record sort on this field but records are displayed in below manner:

07:00:00, 13:01:00, 14:00:19,00:01:00

The 00:01:00 value field is always displayed in last instead of first place.

Do not know why this is happening.

Please help.

Thanks
]]> Mon, 05 Sep 2022 04:18:03 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23017&PID=75327#75327 Tips and Tricks : Way to display string when field of int type null http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75326#75326 Author: DDSJ
Subject: Way to display string when field of int type null
Posted: 05 Sep 2022 at 4:11am

This solution worked for me.
Thankyou so much for the support.
]]> Mon, 05 Sep 2022 04:11:10 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75326#75326 Tips and Tricks : Way to display string when field of int type null http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75325#75325 Author: lockwelle
Subject: Way to display string when field of int type null
Posted: 02 Sep 2022 at 8:25am

Here a trick you could use:

Have 2 fields the same size and the same location. If the value is null, hide one and display the field/cell with NA in it. When it is not null, hide the NA cell and display the calculation results.

if there are a lot of calculated cells, this can be tedious...

HTH]]> Fri, 02 Sep 2022 08:25:31 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75325#75325 Tips and Tricks : Way to display string when field of int type null http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75324#75324 Author: DDSJ
Subject: Way to display string when field of int type null
Posted: 02 Sep 2022 at 12:59am

The difficulty is that I cannot convert number to string in formula field as I have to display the report in multiple languages and my formulas have calculations which fails if I convert number to text. So is there any way to provide border or lines on field when value of field is null if to display NA is not possible. Either way will work.(NA or border around null)
Please help

Thanks in advance


Edited by DDSJ - 02 Sep 2022 at 1:01am]]> Fri, 02 Sep 2022 00:59:53 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75324#75324 Tips and Tricks : Way to display string when field of int type null http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75313#75313 Author: kevlray
Subject: Way to display string when field of int type null
Posted: 23 Aug 2022 at 3:55am

in a formula. You can for display purposes convert the number to a string.  That way you can display the NA.  I.e., if isnull(fieldvalue) the 'NA' else cstr(fieldvalue)
]]> Tue, 23 Aug 2022 03:55:57 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75313#75313 Tips and Tricks : Way to display string when field of int type null http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75311#75311 Author: DDSJ
Subject: Way to display string when field of int type null
Posted: 23 Aug 2022 at 1:42am

Is there any approach to display 'NA' in place of blank when Field of numeric type is null in database. I do not want to convert the field type to char type using user formula as the requirement is to use the numeric type in other formulas. However I want to display 'NA' if the filed value is null or blank in database. Is there any way to achieve it ?

Please help

Thanks

Edited by DDSJ - 23 Aug 2022 at 1:43am]]> Tue, 23 Aug 2022 01:42:17 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23016&PID=75311#75311 Tips and Tricks : crystal report suppress Duplicate data http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22813&PID=74670#74670 Author: kevlray
Subject: crystal report suppress Duplicate data
Posted: 22 Aug 2019 at 4:40am

One, you could filter by Con-ID = 13.  The second possibility is to group by values and only show the values in the group footer (hide group header and detail).

I think (not sure how you want to look) is to filter by IDFix, Reference and Con-ID and show your value in the Con-ID group footer.
]]> Thu, 22 Aug 2019 04:40:11 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22813&PID=74670#74670 Tips and Tricks : crystal report suppress Duplicate data http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22813&PID=74667#74667 Author: Veeru28
Subject: crystal report suppress Duplicate data
Posted: 21 Aug 2019 at 9:33pm

I have data with multiple columns and need to suppress whole row if `Reference` is repeated and `Condition ID` is latest number (this might repeat, but I need all repeated columns).

Following is my data. I want only the lines which say `Con-ID` is 13. Can anyone help with code?


    Status     IDFix     Reference      T/S     IDX     TEXT                Con-ID
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      1.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      2.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      3.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      4.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      5.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      6.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      7.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      8.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      9.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         9.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      10.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         10.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      11.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         11.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      12.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         12.00
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         13.00
    Granted     VP01     19751228     Y     3.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     4.00     PCT 2 - lights         13.00

I want the result as following: CON ID might change in next phase to 14, so i want only results that are latest CON ID. made it into groups based on reference and CON _D (Decreasing value) But unable to suppress repeated groups (Con ID) please help !!!!

    Status     IDFix     Reference      T/S     IDX     TEXT                Con-ID
    Granted     VP01     19751228     Y     1.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     2.00     PCT 2 - lights         13.00
    Granted     VP01     19751228     Y     3.00     PCT 1 - No Sign      13.00
    Granted     VP01     19751228     Y     4.00     PCT 2 - lights         13.00

Edited by Veeru28 - 21 Aug 2019 at 9:59pm]]> Wed, 21 Aug 2019 21:33:38 +0000 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22813&PID=74667#74667