Post

4 followers Follow
0
Avatar

Help with GetReportURL

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

Andrew Miller Answered

Please sign in to leave a comment.

9 comments

0
Avatar

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.

https://www.clarizen.com/live-demos/ 

Phil Smith 0 votes
Comment actions Permalink
0
Avatar

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

Andrew Miller 0 votes
Comment actions Permalink
0
Avatar

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 BOLMONT 0 votes
Comment actions Permalink
0
Avatar

Armand, using the GetRuntimeParameter function worked. Thanks.

Only had to wait a year, but got there in the end...

Andrew Miller 0 votes
Comment actions Permalink
0
Avatar

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!

 

Reshma Pendse 0 votes
Comment actions Permalink
0
Avatar

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

Andrew Miller 0 votes
Comment actions Permalink
0
Avatar

Thanks, Andrew!

The report i am trying to run is based on Timesheets and has the following parameters:

  • Timesheet.ReportedDate equals <This Year>
  • Timesheet.State equals <Approved>
  • Timesheet.WorkItem.ResourceUtilizationCategory equals <xyz>
  • Timesheet.InvoiceReference is blank
  • Timesheet.WorkItem.Project.Customers is one of <ABC>

 

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!

Reshma Pendse 0 votes
Comment actions Permalink
0
Avatar

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!

Andrew Miller 0 votes
Comment actions Permalink