Applying conditions to filters and grouping columns in report builder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » Applying conditions to filters and grouping...

25 posts, Page 1 of 3

1 2 3 »»»

Applying conditions to filters and grouping columns in report builder

Rate Topic

Display Mode

Topic Options

Author

Message

malavika.ramanathan

Posted Friday, May 21, 2010 4:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, 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??????

Post #925802

ramdas.narayanan

Posted Friday, May 21, 2010 9:05 AM

Old Hand

Group: General Forum Members
Last Login: Monday, February 14, 2011 7:42 AM
Points: 360, 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

Post #926042

malavika.ramanathan

Posted Friday, May 21, 2010 11:54 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, 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?

Post #926377

ramdas.narayanan

Posted Monday, May 24, 2010 7:32 AM

Old Hand

Group: General Forum Members
Last Login: Monday, February 14, 2011 7:42 AM
Points: 360, 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

Post #926826

malavika.ramanathan

Posted Monday, May 24, 2010 9:45 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, 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?

Post #927176

malavika.ramanathan

Posted Monday, May 24, 2010 10:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, 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

Post #927177

ramdas.narayanan

Posted Tuesday, May 25, 2010 7:16 AM

Old Hand

Group: General Forum Members
Last Login: Monday, February 14, 2011 7:42 AM
Points: 360, 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.

Post #927432

malavika.ramanathan

Posted Tuesday, May 25, 2010 7:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, 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.

Post #927440

malavika.ramanathan

Posted Tuesday, May 25, 2010 7:27 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 15, 2011 12:09 AM
Points: 140, 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.

Post #927445

ramdas.narayanan

Posted Tuesday, May 25, 2010 7:36 AM

Old Hand

Group: General Forum Members
Last Login: Monday, February 14, 2011 7:42 AM
Points: 360, Visits: 188

malavika.ramanathan (5/25/2010)

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.

Post #927457

« Prev Topic | Next Topic »

25 posts, Page 1 of 3

1 2 3 »»»

Permissions