Anyone know how I build a report that will exist in a project-level dashboard that shows all the documents from all projects that exist in the same program as the project I'm running the report from?

Question

It's a bit of a mind-bender.  The scenario is that a program had multiple projects.  One of these projects handles briefing and all the others manage production.  We want to hold the briefs in the briefing project only but we want to make the brief available to all the build projects.  The idea is to have a dashboard on all the build projects that displays the brief documents from the briefing project.  When I run the report say from the reporting list it woks fine but when I run it from within a build project it comes up blank (unless I run it from the briefing project, in which case it works fine).  So I guess I need the report to work even if there are no documents in the project I'm running the report from.  Yikes, head melting :-)

imgrund · Answer

Hi - I had a client once who kind of did the same thing. The difference: once uploaded, they copied the document URL and put it in a custom form on the Program. That way they could easily include it on different project.

valuefield=program:Creative Brief URL

You can also then do something like this:

valueexpression=IF(ISBLANK({DE:Creative Brief URL}),"","Click Here")

link.url=customDataLabelsAsString(Creative Brief URL)

textmode=true

valueformat=HTML

displayname=Creative Brief URL

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded