several filters in different columns

Question

Post reply

several filters in different columns

shyaagi

SSC Veteran

Points: 233
More actions
October 21, 2010 at 7:54 am

#242016

i am new to SSRS and i have to generate sales report in which we have to apply different
conditions in different columns
i have three columns that has three conditions
in profit column condition is accountID=13 and TypeID=23
in units column condition is accountID=8 and TypeID=14
in Disbursement column condition is accountID=78 and TypeID=23
how to apply filters on three columns or is any other way to do this
Please Help me

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

veeren4urs SSCrazy Points: 2763 More actions · Answer 1

Hi ,

Add all these conditions in calculated feild in SSRS dataset.

Thanks,

Veeren.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

Brian K. McDonald Say Hey Kid Points: 710 More actions · Answer 2

If you are trying to filter the results, you'll need to do that at the dataset or tablix level in their property windows. No, I don't think this is what you are trying to do, but if you can provide just a little bit more details, I may be able to help you further.

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant
Jacksonville, Florida

shyaagi SSC Veteran Points: 233 More actions · Answer 3

thank you for your reply

my data table contain lot of columns i am mentioning few which are necessory

ClientID ,DraftBillID, AccountID, TypeID,amount,Units

one clientID has different DraftbillIDs

for each DraftBillID there is a accountID and TypeID is there

for the first column(profit) in the report we have to pull out all amounts which satify accountID=13 and TypeID=23 condition

for the second column(Units) in the report we have to pull out all units which satify accountID=8 and TypeID=14 condition

for the third column(disbursement) in the report we have to pull out all amounts which satify accountID=78 and TypeID=23 condition

report is look like this

units is numeric and it represent hours

ClientID DraftBillID Profit Units Disbursement

AAA A1 2500$ 5HRS 6000$

AAA A1 2000$ 6HRS 5000$

AAA B1 1500$ 4HRS 3000$

AAA C1 2000$ 3HRS 3500$

AAA D1 1000$ 5HRS 6000$

Brian K. McDonald Say Hey Kid Points: 710 More actions · Answer 4

This is how I would proceed if it were my project.

1. Create a stored procedure that uses a table variable to dump each of the corresponding values into.

2. Return the table variable to the report

3. Set the report data set to execute the stored procedure.

Does this make sense?

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant
Jacksonville, Florida