How end-users can sort a NON-SQL dataset ?
Hi,
I?m working to integrate your report builder editor in my
application.
I would users can create new reports:
1) from the tables of database (by SQL query)
2) from a dataset that exists in my application and so manage grid
?s filter etc etc
In the FIRST CASE end-users can create reports and choose what fields
sorting for and it works fine; but it's very complicated (for a
"normal user") create a sql query with lookup, calc field etc etc
So I would, sometimes, permit that end-users can create report from a
"pre-elaborated" dataset (with some lookup anc calc field ready to
use).
In this case ( SECOND CASE ) I have connected the datapipeline to my
dataset and all works fine but users cannot view this datapipeline in
the page ?DATA? (like SQL data) and so he can?t choose what fields
sort for!
And I can?t verify that the index in use is right for the report (in
particular when group is used).
In addiction it?s not easy change the index because sometimes my
dataset has ranged !
After a long time I have thinked to ?copy? my dataset (filtered etc
etc) to another table on the disk (because the original can be a
MEMORY table) but in this condition I must open it in exclusive mode
(to empty or delete table before start to print) and so users cannot
print simultaneously!
Have you got a solution ? How can users choose own sort fields working
with a dataset filtered (for example) by a grid in the application??
Another question ;-) is it possible to access to variables and/or
functions of my application from the CALC page of the editor??
Thank you
Dario
I?m working to integrate your report builder editor in my
application.
I would users can create new reports:
1) from the tables of database (by SQL query)
2) from a dataset that exists in my application and so manage grid
?s filter etc etc
In the FIRST CASE end-users can create reports and choose what fields
sorting for and it works fine; but it's very complicated (for a
"normal user") create a sql query with lookup, calc field etc etc
So I would, sometimes, permit that end-users can create report from a
"pre-elaborated" dataset (with some lookup anc calc field ready to
use).
In this case ( SECOND CASE ) I have connected the datapipeline to my
dataset and all works fine but users cannot view this datapipeline in
the page ?DATA? (like SQL data) and so he can?t choose what fields
sort for!
And I can?t verify that the index in use is right for the report (in
particular when group is used).
In addiction it?s not easy change the index because sometimes my
dataset has ranged !
After a long time I have thinked to ?copy? my dataset (filtered etc
etc) to another table on the disk (because the original can be a
MEMORY table) but in this condition I must open it in exclusive mode
(to empty or delete table before start to print) and so users cannot
print simultaneously!
Have you got a solution ? How can users choose own sort fields working
with a dataset filtered (for example) by a grid in the application??
Another question ;-) is it possible to access to variables and/or
functions of my application from the CALC page of the editor??
Thank you
Dario
This discussion has been closed.
Comments
Rather than connecting your report to a pre-defined dataset/datapipeline on
the form, you can simply create this dataset in DADE and save the report
template. This way you can easily load the template with the pre-defined
dataset(s) already created when you want to give your users an easier
approach.
It is also possible to create DADE dataviews completely in code if you would
like to keep from saving and loading templates using the TdaSQLBuilder
class.
http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder
Yes, however you will need to use Report Parameters to do so. See the RB
help for more information.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com