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.
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.