Changing Report Display Order

[wapowell]

Hiya everyone. Ok, let me see if I can describe this properly. Right now when I see the listing of reports in CE it lists them accoring to their report id (hidden). This is default out of the box. Add a new report to CE, and thus it goes to the end of the list since it would have the highest id (auto increment). I'm wondering if there is a way to have it sort ascending by the report name that I enter when I add the report to CE. That way when I click into a folder, its reports would list alphabetically by title, vice in order by id.
Any thoughts?
Please let me know if I didn't explain this clearly.

By the way, I'm in CE 8.5.

Thanks everyone!

-Bill

 

[BobSuruncle]

Available.csp would be the page to look at.
See if you can find the code that generates the list of reports. If it's not directly in Available.csp, it's in one of the #Include files.
It'll just be changing an ORDER BY



HTH
Bob Suruncle

 

[wapowell]

Thanks for the reply.
I am not using the e-portfolio, I am using the Report Directory Client (under the Developer Sample section). The e-portfolio uses the Available.csp file.

Anyways, I found where to change it in the Directory Client.

Modify the guest.csp file (located ...\Program Files\Seagate Software\Web Content\Enterprise\websamples\en\database\guest.csp).
Look for "'GET ALL REPORTS FROM THE CURRENT FOLDER". In the following select statement add "ORDER BY SI_NAME" be fore the closing quotes.
Save and reload the web page.
Now the reports under the current folder will be in order by report name vice report id number.

Hope this helps someone else. It managed to drive me mad for a couple hours.

Thanks again all,

-Bill

 

[BobSuruncle]

You may also want to change USER.CSP if you're logging on and have disabled the Guest account.


Bob Suruncle