Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Applying conditions to filters and grouping columns in report builder Expand / Collapse
Author
Message
Posted Friday, May 21, 2010 4:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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

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
Posted Friday, May 21, 2010 9:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Friday, May 21, 2010 11:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, May 24, 2010 7:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Monday, May 24, 2010 9:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, May 24, 2010 10:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Post #927177
Posted Tuesday, May 25, 2010 7:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld 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
Posted Tuesday, May 25, 2010 7:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, May 25, 2010 7:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, May 25, 2010 7:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, February 14, 2011 7:42 AM
Points: 360, 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.
Post #927457
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse