Saud
Posts: 15
|
| Posted: 02/10/2006, 10:30 AM |
|
Hi All,
Is it possible to sort the Report Categories in a custom order instead of the available (asc or desc)?
For example; I have a report that uses Category as the heading for each section which lists items under each category. The current possible method to sort those categories is by setting the CATEGORY section to a (ASC or DESC) order. I want to be able to sort the categories based on a second column called (CATEGORYORDER)!
Any thoughts?
Saud
|
 |
 |
Walter Kempees
|
| Posted: 02/10/2006, 10:35 AM |
|
It's all in the SQL my friend.
Find the Datasource in the Properties click on the [...] and you can do
whatever you need
"Saud" <Saud@forum.codecharge> schreef in bericht
news:643ecdbe03a2a0@news.codecharge.com...
> Hi All,
>
> Is it possible to sort the Report Categories in a custom order instead of
> the
> available (asc or desc)?
>
> For example; I have a report that uses Category as the heading for each
> section
> which lists items under each category. The current possible method to sort
> those
> categories is by setting the CATEGORY section to a (ASC or DESC) order. I
> want
> to be able to sort the categories based on a second column called
> (CATEGORYORDER)!
>
> Any thoughts?
>
> Saud
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Saud
Posts: 15
|
| Posted: 02/10/2006, 11:08 AM |
|
Quote :It's all in the SQL my friend.
Find the Datasource in the Properties click on the [...] and you can do
whatever you need
Unfortunately, it does not help! Datasource Properties help in sorting the ITEMS not the CATEGORIES!
Thanks anyway.
Saud
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/10/2006, 12:31 PM |
|
I think that this cannot be done in a straightforward way due to some logical reasons, however, you could contact the support and see if they'd recommend a solution or workaround.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 02/14/2006, 1:01 AM |
|
Oops, I found now that what you may want is possible, although probably differently than you and I expected.
Basically the group order cannot be custom because a group is defined by its order and they are almost one and the same. Thus if you want to sort groups by CATEGORYORDER then you should use CATEGORYORDER as your grouping field. However, you don't need to display such value on your report and instead you can display another field's value, like CATEGORY that you need.
If creating a new report you should select CATEGORYORDER as your group and later change the corresponding label to display CATEGORY.
If modifynig an existing report you can open the "Groups [...]" property dialog and select CATEGORYORDER as your group field/column.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
