Custom Report -- SQL query vs. Wizard
Is there a way to edit the actual SQL query of a custom report instead of editing it using the Report Wizard? If fields that I would like to use in a report do not show up in the wizard, would I have to make the entire report from scratch as a New Query Report?
I am creating a Purchasing Report that is grouped by POName (that we use as cost center). I would like to have the details (individual items purchased) of the PO vs. the summary of the PO in the report. These items are not available for selection in the Report Wizard. Do I have to create this report from scratch as a New Query Report or is there a way to dig out the query created by the New Custom Report Wizard?
PS -- What's with the decimal places in the final sum of the attached report?
I am creating a Purchasing Report that is grouped by POName (that we use as cost center). I would like to have the details (individual items purchased) of the PO vs. the summary of the PO in the report. These items are not available for selection in the Report Wizard. Do I have to create this report from scratch as a New Query Report or is there a way to dig out the query created by the New Custom Report Wizard?
PS -- What's with the decimal places in the final sum of the attached report?