adding columns dynamically to report

[arusanah]

Hi ,

I'm creating a report to display monthly customer sale .

My requirement is to have flexibility to select date range . and based on that range it should add columns to table or Pivot report.

I know we need two input boxes for  from date and to date.but then dont know how to generate runtime columns in report .

e.g Product category , Productn description , <n months customer sales >

pls help

[arusanah]

will  surely try and upload the app!

thanks

[arusanah]

Thatz just an Adhoc report . this is not my exact requirement.

My requirement is i have 2 dimensions PG Category and PG Desc .  i want to see mon-Year sale against them.

I created 2 calander objects From date and To date. based on date range its should display me sales if date range is 12 months it should show me 12 columns , if date range has 36 months , it should add 36 columns like that .

[arusanah]

Product

PG Group Product Desc

Date

8-3-2012 … …. ….. ….. 3/30/2015

Product group	Product Desc	MONTH-YEAR(based on date range selection) Jan-13 Feb13 Jan15
		(Customer sales)

Month year column needs to be added dynamically. E.g if users selects jan 13 – jun 13  only 6 columns should be added to show customer sale jan thru jun.  if user selects jan 14-jan 15 .. 12 columns should be displayed to show monthly sales and like wise.

[Anonymous]

Last attempt to help...

See the attached file.  There is Dim2 filter.  Whatever you select will be on the columns of the pivot table.

In case of months, the difference is only in details.  The fact that the selection is made using "to" and "from" doesn't change anything.

[arusanah]

But where is attachment??

Thank Michael. i'm new to QV development and so facing lots of issues .. I'm Kind off stuck in a dead end

every bodies help is much appreciated.

[arusanah]

U r Life  Saver Ramon. Thank You So veryyyyyyy much

[arusanah]

Michael in the Qvw you sent .. it works fine but the only problem is it is not adding columns . it just changes column . e.g when i select value a  from DIM table ..report displays

dim 1    dim2    column a . . i change my select to b

i see  dim1   dim2   column b

where as my requirement is if i select first date form Dim1 

second date from Dim2  then report should display all columns between that date range 

[Anonymous]

OK, the very last time...

You misunderstood - Dim2 is your only Month field. Dim1 has nothing to do with it.  That is, all selections for month are in one field, in this case Dim2.  You select "months" from a to b - you get them in the table.

As I've mentioned above, the fact that the selection is made using "to" and "from" doesn't change anything.  not in the table at least.

See an updated example. I only renamed Dim2 to Month, and made the values to be from Jan to June 2015.  In addition, created two calendar objects where you can select start and end dates.  Nothing's changed in the table.  the list box Month here is read-only so you can make selections there only by the means of the calendar objects.

(If you select End date < than Start date, you get all months.  Sorry, I didn't bother to address that because it's not what your question about.)

Hope it helps...

[arusanah]

Thank you so very much  Michael!!!! This is  exactly what i was looking for wanted .

some body rightly said -> try try till you succeed  .

Would you mind if I add you to my connections ?

[arusanah]

How can I Mark it as correct answer ?