Printable View
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?
VB Code:
How abpout putting a space between by and {
:(
same
Why are using {} instead of [] ??:confused: . Try to replace it with [ ] after ORDER BY .
still the same err msg...
remaining text does not appear to be part of the formula
What's the error msg ? and btw , are you sure you should use {} instead of [] ?
Is this SQL String ??
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
not really a sql string...just adding parameters when the reports are ran...is there another way I can order by then?
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 ...
:( :confused:
same
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.