Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Setting report Sort order and direction at runtime Post Reply Post New Topic
<< Prev Page  of 2
Author Message
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 30 Dec 2009 at 9:22am

In your command SQL you can do something like this (MS SQL Server syntax)

Select right((Replicate('0', 31) + Convert(varchar, TAMT, 2)), 31) as TAMTString, *
from...

This way you get the amount converted to string AND all of the fields from the view.
 
-Dell
IP IP Logged
eulylay
Newbie
Newbie


Joined: 23 Feb 2012
Location: Philippines
Online Status: Offline
Posts: 1
Quote eulylay Replybullet Posted: 23 Feb 2012 at 7:01am
Hello ,,I'm new to crystal report and I got some problems in sorting fileds in my report,please send  me the complete instructions for sorting fields in crystal report.. Thanks.
I know you can help me..
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.