Hello forum,
I have been asked to design a Infomed, that I have no idea how to start developing it, because in my years with this, I have asked for anything similar, I like that I'd have a hand or to give me some idea.
Member seeps into the querie by a date or date range, you can also filter by year \ week.
The querie has 2 ratios:
- The balance ratio is a ratio restricted by the date of payment, to be assigned a user-exit variable
the value will be the 1st day of the month and year of the first date range filter selection, this ratio will be a static (fixed), always filtered through the date that you commented.
My problem comes with the other ratio, amount, I have to generate as many columns with the ratio depending on the date entered by the user filter.
For example, if the user filtered the report by date: 02.01.2009-02.02 2009
This example would generate columns from on 02.01.2009 to 02.02 2009 ... .. is a table with a static column and other dynamics.
If the designer querie put the date in columns, just above the ratios, I also work as it creates columns for the ratio N balance, and this is not what I want ...
Nose, is there any way to mount BW queries such or with variable-exit or PivotTable.
Thanks,