Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Applying conditions to filters and grouping columns in report builder


Applying conditions to filters and grouping columns in report builder

Author
Message
malavika.ramanathan
malavika.ramanathan
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 748
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 Sad

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??????
ramdas.narayanan
ramdas.narayanan
Old Hand
Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)

Group: General Forum Members
Points: 368 Visits: 188
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
malavika.ramanathan
malavika.ramanathan
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 748
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?
ramdas.narayanan
ramdas.narayanan
Old Hand
Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)

Group: General Forum Members
Points: 368 Visits: 188
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
http://msdn.microsoft.com/en-us/library/aa337398.aspx
malavika.ramanathan
malavika.ramanathan
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 748
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?
malavika.ramanathan
malavika.ramanathan
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 748
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 Sad
ramdas.narayanan
ramdas.narayanan
Old Hand
Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)

Group: General Forum Members
Points: 368 Visits: 188
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.
malavika.ramanathan
malavika.ramanathan
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 748
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.
malavika.ramanathan
malavika.ramanathan
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 748
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.
ramdas.narayanan
ramdas.narayanan
Old Hand
Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)Old Hand (368 reputation)

Group: General Forum Members
Points: 368 Visits: 188
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search