Drilldown Header Syntax

[dnapolitano]

I have a directory structure beginning with a home directory and having three subdirectories with these names:

• Business Development
• Network Ops
• Product

All the reports are sorted into those directories.

If I wished to create a drilldown filter for a report residing in the Business Development section, but pointing to a report in the Network Ops section, how would I modify the snippet (from the BizDev report) below, please, to replace "Report.sql"?

-- FILTER: { -- filter: "drilldown", -- column: "name", -- params: { -- report: "Report.sql", -- macros: { -- "site": { "column": "id" } -- } -- } -- }

My apologies; I am good with SQL and nearly illiterate with PHP. I've messed about with trying to guess how to form the path for a while and hope you don't mind my asking you. Thanks!

[edu-bob]

The path to the drilldown report is relative to where the original report is, so the "report:" value in your filter header would be report: "../Network Ops/Report.sql" I never put blank characters into directory names. That should be okay, but if you have more problems, I would rename all of your directories without blanks in them.