I'm confused over the general approach to this issue. I have a report that expects a project-id. If I bind the report to the projects module it appears in the left hand menu....but how do I get the project.id to be passed into it?
the SQL of the report defines:
projects.'id' AS project_id
I've created a parameter in the report called
CURRENT_PROJECT_ID
I've created a parameter in ZuckerReports called
CURRENT_PROJECT_ID
which I have bound to the report...and then the report to the module
But this doesn't work. How is the project.id supposed to be linked through to the report parameter? Do I need to define some SQL for CURRENT_PROJECT_ID to achieve this? I suspect not....but documentation on this FRANTASTIC feature appears thin on the ground.
Any help would be much appreciated.
Thanks.
ANDREW
Sugar Community Edition 5.1


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks