End User Explorer - How to select reports on folder click rather than load all on startup

rbuser

Hi,


I am using Report Builder 7.0.3 with the End-user explorer. I have clients
with about 500 reports and are complaining about the memory usage of Report
Builder and the time it takes to load. I have attributed this to the Dataset
that gets the reports from rb_items table when the explorer starts up.


Is there any way of preventing it from loading up ALL reports on start-up
and only select those reports from the SQL database to show in the explorer
list view when the user clicks on a particular folder in the left hand panel
tree view? At the moment it appears to select all reports at start up and
uses the locate functions to get the reports when needed.


Any help would be appreciated.

thanks



justin

nardmoseley

You must working with Jarrod Yates who has twice sent this same question to
support@digital-metaphors.com and I have answered twice. Please coordinate
with your co-workers. Post a single question to either the newsgroups or to
support@digital-metaphors.com.

Here is my response to the question...

This is a limitation of the current implementation. The ReportExplorer
simply opens the rbFolders and rbItems datasets and builds the treeview and
listview. When a report is chosen, it locates the specific record in the
dataset and reads the blob.

You might try using a query for the rbItems dataset, so that it does not
select all records.

This something we would like to improve for a future release.

Other alternatives would be to modify the existing report explorer code to
better suit your needs or create an alternative interface. Use of the report
explorer is optional.







--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

nardmoseley

Justin has brought to my attention that perhaps my response was a bit blunt.
The intent of my response was to be professional and polite. I sincerely
apologize if it missed the mark.

(Evidently Jarrod never received our response to the email he sent to
support@digital-metaphors.com. )


--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com