May 21, 2010 at 4:21 am
Hi All,
In my last post i had asked can we use SP in report builder...
i could not find anything related to it...
so i am using query itself...
now i am getting the report, but it is not as desired.
i want to take count for each status....
it is displaying all the status....
ex i want something like:
User position status1 status2
AAAA 2--------- 3--------4-----
but i am getting:
AAAA 2 status1
AAAA 2 status1
AAAA 2 status1
total 3
can anyone suggest how can i do this?
m prob is i am not getting where i can write code for this 🙁
Second ques is i am not able to apply condition on the filter....
I want to know if i can relate parameters/filters....
Can anyone please help??????
May 21, 2010 at 9:05 am
Hi,
Are you using report builder version 2.0 or version 1.0. There is a difference between both the versions, 1.0 came with sql 2005, 2.0 came with sql 2008. Version 2.0 is a lot better to work with, it has row and column groupings available.
Thank you
May 21, 2010 at 11:54 pm
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 help me sorting out this issue?
May 24, 2010 at 7:32 am
Hi,
Since you are using report builder 1.0, you need to first create a report model, this is usually done based on a data source view. The data source view is created based on a set of tables or a view defined in the database.
Also check this out
May 24, 2010 at 9:45 pm
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 all rows?
I have placed two parameters : Location and User.
User A has more than 1000 rows.. but i am getting only one record for A.
could you please tell me how can i solve this? does this have any property feature to be changed just as in static reports?
May 24, 2010 at 10:07 pm
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 all the status....
i want something like:
User position status1 status2
AAAA 2--------- 3--------4-----
but i am getting:
AAAA 2 status1
AAAA 2 status1
AAAA 2 status1
total 3
can anyone suggest how can i do this?
m prob is i am not getting where i can write code for this 🙁
May 25, 2010 at 7:16 am
Would it be better just to use regular reporting services instead of report builder. With SSRS you could do better groupings/write stored procs which could offer more flexibility.
May 25, 2010 at 7:23 am
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 in this regard.
May 25, 2010 at 7:27 am
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 simply totalling everything in the table and i am getting values in thousands.
how to apply total for each status separately?
i will give the sample of the output . this may help you understand better.
Status1 Status2 Status3
username 2349 3400 1234
the format seems to be ok, but the data is incorrect.....
please suggest me something.
May 25, 2010 at 7:36 am
malavika.ramanathan (5/25/2010)
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 simply totalling everything in the table and i am getting values in thousands.
how to apply total for each status separately?
i will give the sample of the output . this may help you understand better.
Status1 Status2 Status3
username 2349 3400 1234
the format seems to be ok, but the data is incorrect.....
please suggest me something.
Is there a column group on status? if there is, when you right click on the column there should be an option called Add total. This will add totals for the different column groups. Matrix usually have a row group and a column group, In this you could have a column group on status.
May 25, 2010 at 7:40 am
hi,
thanks for the reply.
i checked in my report. i didnt get that add total option.
should i explicitly define that status as a group? when we drag the fields it will automatically take it as a group rite?
May 25, 2010 at 7:44 am
You might have to explicity define it, dragging columns does not create groups automatically.
May 25, 2010 at 7:46 am
could you please elaborate?
i am not seeing any property window or anything else that wud help me do this as in static reports...
May 25, 2010 at 7:54 am
are you using ssrs 2008?
May 25, 2010 at 7:58 am
no 2005.....
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply