I'm trying to launch a Report from a Project via a Custom Action in the project. I'm using the GetReportURL function to generate a report URL and then using the Success Open URL option to launch a new window with the report.
This does bring up the correct report page, but it shows the following error:
The Report Details cannot be displayed because the report parameters were changed and several Filters have no value.
To fix this problem, please define Report Filters.
I suspect that I'm not passing in the correct parameters into the report filters. The documentation is a bit sparse and trial and error has got me no where.
The report has two filters:
- The first is a picklist value (but is not normally seen by the user). I used this format 'Project KPI' in the function.
- The second is a project object. I passed in the project ID, e.g. P-5501
The report page that opens has the following URL:
https://eu1.clarizen.com/Clarizen/Report/74292357?rvl=true&p1=Project+KPI&p2=P-5501
Can anyone help me to work out what I'm doing wrong
Please sign in to leave a comment.
Andrew,
Sorry this one is beyond me I'm afraid. I would suggest registering for one of the Office Hours / Live Q&A sessions and ask for help that way. You can get free access to the Customer Success Team and I have only ever found upto 2 or 3 others on a full one hour session, so plenty of time to get help.
The last time I tried that I was told that the question was too complex for those sessions, but I will try again
However, I've had more joy in these forums so if anyone else has got this function to work, please help me!
Thanks
This may be too late, but I worked with this function and discovered a few "rules" to get it working.
The related discussion is here: https://success.clarizen.com/hc/en-us/community/posts/115005475093-Use-of-GetReportURL-function-with-filters-defined-as-Is-One-Of-?page=1#community_comment_115001217813
In your specific case, I think the problem is that you used directly a string to pass the pick-up value. You should define a variable first with the correct Pick-up value type, and use that variable with GetRuntimeParameter.
The problem may be the same with the project, and you would need to define a variable as well to pass the parameter (to be tested).
Armand, using the GetRuntimeParameter function worked. Thanks.
Only had to wait a year, but got there in the end...
Never lose hope :D
Hi
I get the exact same errors. I do have a bunch of filters on my report, and all except the Customer filter are fixed. Its only the customer that needs to be selected at runtime. Can you share a sample of how you achieved this?
A screeshot of your configuration would be great.
thanks in advance!
Below is a screenshot of the relevant section of the Custom Action which runs the report
The report (RU-127) has one filter parameter, the Project. As the Custom Action is running on the Project, I just pass in the current object.
Hope this helps
Thanks, Andrew!
The report i am trying to run is based on Timesheets and has the following parameters:
I am running this report from the Customer object, so I am able to get Timesheet.WorkItem.Project.Customers as current object, but am not sure how to pass the other parameters. These are fixed, and users cannot change this value at runtime.
thanks in advance!
With my report I had one fixed parameter, as well as the user selectable one. I only had to pass the user selectable parameter, and not the fixed one.
I've only done this once, so that's as far as I can help you.
Good luck!
