i have my crystal report lining to a view within an sql database, i have field that change a normal data field into just showing the month and year, so i cna use this field to group within the report.
Each month is seperated on a different page, which works fine. But the sort order is not going by the month, but alphabetically.
would any one have any ideas how i would acheive this within crystal
I did think initially that i would create the extra field that i wanted (month/year) within crystal, but i did not know how to do this, so found it easier to do this within the sql database.
Any assistance would be appreciated, and thanks for any help in advance.
Each month is seperated on a different page, which works fine. But the sort order is not going by the month, but alphabetically.
would any one have any ideas how i would acheive this within crystal
I did think initially that i would create the extra field that i wanted (month/year) within crystal, but i did not know how to do this, so found it easier to do this within the sql database.
Any assistance would be appreciated, and thanks for any help in advance.