prompt problem

Hi,

I am facing a unique problem

In my report i want current month project costing which prompts for
month and year from the user
also in the same report i want current year project costing which only prompts for the year( because its yearly)
now the problem is current month project costing is over writing the year prompt( meaning i m getting both columns with the same value) because when i run the report it only asks for month and year for current month and uses same prompt for the year too, when i onlu run current year column prompt works fine.

plz help…


amdel61 :us: (BOB member since 2004-07-14)

amdel61,

Can you be little more clear. Like are u creating the prompts in universe or in thick client or webi.

Make a note that when u are creating prompt in universe and pulling both prompt in same dataprovider then, prompt with more restrictions becomes effective, which is what might be happening in your case.


Faas :us: (BOB member since 2004-02-24)

This sounds like your two ‘year’ prompts are combining, which happens when the ‘prompt text’ is the same.

If this is the case, try changing your promtps to something like:

  1. Current Month costing - Enter Month
  2. Current Month costing - Enter Year
  3. Current Year costing - Enter Year

This should ensure they are 3 distinct prompts/variables when you get them in your report.

Hope this helps…


philmorris :uk: (BOB member since 2002-11-12)