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

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 ?

 

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.

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