order by

[EyeTalion]

I need to order by vendor name when I call my report from my app...everything works in the formula, except for the "order by"...any help?

rpt.DataDefinition.RecordSelectionFormula = "{pcms_pcard_transaction_header.end_billing_date} =#" & tranPeriodEnd & "# and {pcms_pcard_transaction_header.card_work_unit}='" & userid_wu & "' order by{pcms_pcard.employee_last_name}"

[Cander]

How abpout putting a space between by and {

[EyeTalion]

same

[Pirate]

Why are using {} instead of [] ?? . Try to replace it with [ ] after ORDER BY .

[EyeTalion]

still the same err msg...


remaining text does not appear to be part of the formula

[Pirate]

What's the error msg ? and btw , are you sure you should use {} instead of [] ?

[Pirate]

Is this SQL String ??

[EyeTalion]

the brackets are working fine in the rest of the formual. I only get the err msg when I add the "order by" clause.

The err msg is from Crystal...shows my formula and at the end says:

remaining text does not appear to be part of the formula

[EyeTalion]

not really a sql string...just adding parameters when the reports are ran...is there another way I can order by then?

[Pirate]

Try this :

rpt.DataDefinition.RecordSelectionFormula = "{pcms_pcard_transaction_header.end_billing_date} =#" & tranPeriodEnd & "# and {pcms_pcard_transaction_header.card_work_unit}='" & userid_wu & "=" & "' order by{pcms_pcard.employee_last_name}"

Changed ...

[EyeTalion]

same

[RichardAtherton]

Your problem is that you are using the record selection formula to use an 'order by clause'. Remember this is not an sql styring, it is a record selection formula and only accepts record selection criteria.

If you need to order the records, other than their normal order then either create a view in server explorer and use that, or in your VB code, fill a dataset with your record selection and ordering and then set your datasource on the report obect to use that dataset.