Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: ???Sort Multiple Field in CR 10 ??? 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: 3702
Quote hilfy Replybullet Posted: 19 Apr 2007 at 11:27am
ToText(Datefield, 'MMM dd, yyyy')
 
You'll have a second, similar set of formulas to display the data on the report vs. sorting the data.  The format for sorting the date need to be 'yyyyMMdd' and the format for displaying it needs to be 'MMM dd, yyyy'.
 
-Dell
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Posted: 19 Apr 2007 at 11:41am
Thank you a lot for your time and help.
I will try the keep the display of the columns not changed on the report.
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Posted: 19 Apr 2007 at 3:38pm
Hi! Thank you a lot for your help. It works great now.
Well, the issue is on the Server (CE 10).
 
My report has a drop-down list box prompt/parameter that allows user to select multiple values (facility Id) by pressing the Add button to add one value at a time and the cursor positions correctly to add next next value on the list.
 
It works correctly if I run the report on my machine (Window XP Pro). But it does not work the same on the server after I published it onto the server.
The drop-down list box list all the entries, but after pressing the Add button to add an entry the cursor does not move to the next entry on the list; it sits at the same entry so if user presses the Add botton again I would add in the same entry.
 
With your expertise, do you know what happens ? Is there any setting on the server (CE 10) needed to be done to resolve it ?
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Apr 2007 at 7:24am
I'm not very familiar with CE 10, so I'm afraid I'm not going to be much help here.  It may just be the way CE 10 works and it becomes a user training issue.
 
-Dell
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Posted: 20 Apr 2007 at 8:41am
Thank you, Hilfy.
Are you expert on with .NET. I'm looking for some samples:
1) A sample Web .NET (VB or C#) to run Crystal Reports plus all the Schedule/History features that the CE provides.
2) a sample Web .NET (VB or C#) to maintain some DB2 tables.
 
I've looked around on the internet but have not found any good samples.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Apr 2007 at 10:08am
I do C#, but not yet ASP.NET.  I'm VERY familiar with the SDK for BO XI, which is similar but not exactly the same as what's available in CE (does CE even have a .NET SDK??)
 
-Dell
IP IP Logged
peter
Groupie
Groupie


Joined: 08 Apr 2007
Location: United States
Online Status: Offline
Posts: 51
Quote peter Replybullet Posted: 20 Apr 2007 at 11:07am
Yes. We are moving to XI soon.
Any way that is for the future. Now I just want to do one more new thing and it seems CR Designer 10 does not support it.
I want to have a Formular that spin a 2nd lookup table about 20 record selecting the value of a field, appending them all into one string to display on the report. And this should spin only once.
 
Can we do some thing like this?  (on the table, not the parameter ?company})
 
dim i as number       
dim concate as string 
i = 1                
concate = ""           
do while i <= ubound({?company})
  concate = concate + {?company}(i) + ", "
    i = i + 1
loop
formula = concate
 
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.016 seconds.