Thanks for the prompt reply, I just thought there might have been an option with in the viewer (the active X etc)
to sort (be something for them to add)
I have a ASP.net page and which people can view crystal reports, i want to beable to let them sort on a selection of columns either by Asc or desc .. can this be done ??
In our system dates are stores as mnth year eg. mnth='06' year='2005'
My problem is that I need to report back 6 months ago, which is easy enough to do except when the year changes.
what I am curretly doing is
select * from Test where mnth=to_char(sysdate,'MM')-6 and...
Can anyone help, I want to create a multi column report based on one field, I dont want it expanding more that a page. e.g. As you see below when recond count hits say 40 then it wraps to next column... can it be done??
NAME
joe james jill
bob sally
fred Ned
(page end)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.