Toad World® Forums

pivot grids in reports

Hello,
Newbie here using TOAD reports for the first time. Could someone tell me if it is possible to show in a chart the variation of the data instead of the data itself? This is, having a total quantity sorted by dates, I want to show in the chart the variation between the quantity of this month and the previous. I have see there is the option of “absoluteVariation” under “SummaryDisplayType” but It doesnt work as I expected. Does anyone know of a good manual for TOAD reports?
Thank you

I have three suggestions:

  1. In the pivot grid you can go to the Set Up Grid window and use any of the summary functions on a column value. See screenshot

  2. You may need to manipulate the data in your SQL statement. Open up a SQL Editor and use the View | Code Snippets. Each connection type has a set of code snippets that cover the available database functions. If you are using an Oracle connciton there is a section for Analytic funcitons. Select the one you are interested in and at the bottom of the snippet manager is a hyperlink to the inline help file. See screenshot.

  3. In TDA 3.0 we have added a Data Transformation window. This window helps you add columns using common Analytic functions such as standard deviation, variance, etc. You can down load the Beta at http://tda.inside.quest.com/beta.jspa

Debbie

I have three suggestions:

  1. In the pivot grid you can go to the Set Up Grid window and use any of the summary functions on a column value. See screenshot

  2. You may need to manipulate the data in your SQL statement. Open up a SQL Editor and use the View | Code Snippets. Each connection type has a set of code snippets that cover the available database functions. If you are using an Oracle connciton there is a section for Analytic funcitons. Select the one you are interested in and at the bottom of the snippet manager is a hyperlink to the inline help file. See screenshot.

  3. In TDA 3.0 we have added a Data Transformation window. This window helps you add columns using common Analytic functions such as standard deviation, variance, etc. You can down load the Beta at http://tda.inside.quest.com/beta.jspa

Debbie

Hey Debbie!
I’m working on the same stuff: I need to finde the changes or variations from one entry to the next (basically substract the entry of one column to the one above (or below) since each entrie corresponds to a different date). I am using an Access DB so the code snippets don’t help. The summary functions of the Grid are not what I’m looking for: It is not standerd deviation nor variance. When doing charts in the report, I found exactly the opposite from what I’m trying: instead of substracting one entrie in a column to the next, it adds them up in a cumulative way. But not the changes from the first entrie exactly. I can’t even think how to create a query that would do this in a generic way (not putting the date explicitely).

Thank you for your help