btw, i tried the same using matrix report and this seems to be better...

this is giving me the o/p in desired format.

now i need to fix these total issue....

it is...

you are right. i have already made this report in SSRS.

but my mgr wants it in dynamic report itself...

could you please help me? i really need some urgent help...

Hi,

Apart from this, i have one more prob.....

The fields are grouped themselves.... but i want them in a particular fashion.

for ex:

i want to take count for each status....

it is displaying...

Hi,

Thanks for reply .

I have created the report now. But i am getting only the first record from the result set.

What i can do in order to get...

Hey sorry,

i didnt notice that 4001 to 6000 gallons range...

you can repeat the same for that range too..

but are you sure these are the only possible ranges? otherwise you will...

I am not very clear of what you want...

but i understood as you want to make those different ranges as diff columns and then put the corresponding data...

Hi ColdCoffee,

It is working thanks...

but my prob is i am not very clear with this PIVOT.

here u have used max(product)...

now how to decide which aggregate func to use?

and also...

Hi Ramdas,

M very happy i got some reply. thanks a lot for that...

I am using a very basic version. I am using sql 2005 and Report Builder 1.0

Could you please...

Hi all,

I am now getting the report .... i am getting a drill down report also...

but that is not what i made....

for all the fields which have total it...

Sorry everyone here refers to it as dynamic reports itself....

i was not sure of this....(i will change it now)

now after much trial and error methods, i have found how...

Hi

thnks for reply.

dynamic reports are built using the report builder . they dont have any pre-defined layout....

the tables, joins and necessary filter conditions are provided with the query and the...

Hi All,

Sorry for my ignorance.... i could find it....

it was in the browser itself 🙂

Thanks for your time.

hi all,

thanks for your replies....

i got the desired o/p . but i am not very clear about choosing one more column after UserName...

can you pls explain that?

Can i do any of these to handle it ?

I will have my ALL option also selected while SELECT ALL option is chkd.

so i thought of these:

1. Deselect ALL option...

thanks for the reply .

yes i have written a IF statement to check for ALL or specific value condition in my SP.

also, i am using the joins and as...