Sort problem

[jollt]

Hi,

I see it's possible to sort dynamicaly the columns (an do a lot of drag and drop cool stuff) by clicking on the header of the column
It's working while I work in DAI, but it does not work when I call the report from my application
My version is the 6.4.31

Do I have to activate something to make this work by the users?

Thanks,

best regards,

Jérôme

[Bob Cergol]

Hi Jerome,

Do your users have design privileges? Specifically on this report?
Does the report specify that ownership is required to change groupings? etc. ("Column actions" is also a specific design privilege.)

These design permissions might be the issue.

Regards,
Bob

[jollt]

Hello,

I try several options, and nothing is working.

here is my report General Option Tab :


here is my user option tab :


Thanks

[Bob Cergol]

Jerome,

I call reports from Visual Dataflex applications -- but in my case I restrict design access -- for some I hide the filters, for some I completely hide the navigation pane -- no "go" button, etc.

I think what you are trying to do should work -- but I will test and see if it works for me.

Regards,
Bob

[Bob Cergol]

Hi Jerome,

I did a quick test calling a report directly from a URL, like,
"http://localhost/ai6/ai.asp?UID=VPApplication&PW=**********&DAI_R=3894"

The report ran, I drilled down to details, and was able to click on columns and sort. The drag-and-drop gesture for doing the sort did not work for me, but the direct column-click action worked fine for sorting. I tried some other drag-and-drop gestures, such as lower left to group by column and that worked fine.

I still think its a rights issue. If directly in Dyanamic AI, you "run as" the username that you specify when calling the report from you application, can you perform any of the on-screen sort and design functions? If not, then its a rights issue.

Regards,
Bob

[Bob Cergol]

Correction! The drag-and-drop gesture to sort did work for me -- once I used the correct one!
(Just a little distracted this morning....)
-Bob