Skip to Content
0
Former Member
Dec 06, 2009 at 06:54 PM

Help in designing a querie

31 Views

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,