I have created a Power Prompts web application that will dynamically create user generated reports. They can choose any field available in the catalog they want. Using Power Prompts scripts, I add the fields using
GetReport().AddDataItem(colName,"[" + fldPath + "]"
The problem is I need additional data, that I can only derive from lengthy SQL. I can link the reports in Impromptu, but ( I hope! ) there has to be a way to do it dynamically in power prompts.
Can anyone help?
GetReport().AddDataItem(colName,"[" + fldPath + "]"
The problem is I need additional data, that I can only derive from lengthy SQL. I can link the reports in Impromptu, but ( I hope! ) there has to be a way to do it dynamically in power prompts.
Can anyone help?