March 23, 2016 at 10:01 am
I have an SSRS report that runs with out error. However
It has a parametier called "FundId" which is not linking to the
rest of the report it displays it when it is TRUE however if its false it
leaves the rest of the record and removed only the FALSE statement.
I need it to delete the entire row from the report if it doesn't belong to the
fundid.
select top 100
pc.accountnbr 'Account',
qf.description 'Fund Name',
pc.checknbr 'Check Number',
pc.checkprintdate As StartD,
pc.checkprintdate As EndD,
p.fullname 'Pay Provider',
pc.amountpaid 'Paid AMT',
pc.paydiscount 'Intrest',
pc.advanceapplied 'Advance' ,
pc.checkamt 'Check AMT'
from paycheck pc
left join qfund qf on pc.fundid = qf.fundid
left join payment pm on pm.paymentid = pc.paymentid
left join provider p on pm.provid = p.provid
where
pc.checkprintdate Between @StartD And @EndD
March 23, 2016 at 10:41 am
rcooper 78099 (3/23/2016)
I have an SSRS report that runs with out error. HoweverIt has a parametier called "FundId" which is not linking to the
rest of the report it displays it when it is TRUE however if its false it
leaves the rest of the record and removed only the FALSE statement.
I need it to delete the entire row from the report if it doesn't belong to the
fundid.
select top 100pc.accountnbr 'Account',
qf.description 'Fund Name',
pc.checknbr 'Check Number',
pc.checkprintdate As StartD,
pc.checkprintdate As EndD,
p.fullname 'Pay Provider',
pc.amountpaid 'Paid AMT',
pc.paydiscount 'Intrest',
pc.advanceapplied 'Advance' ,
pc.checkamt 'Check AMT'
from paycheck pc
left join qfund qf on pc.fundid = qf.fundid
left join payment pm on pm.paymentid = pc.paymentid
left join provider p on pm.provid = p.provid
where
pc.checkprintdate Between @StartD And @EndD
In this code, there is no reference to a "fundId" variable.
I see that field as part of the qfund and paycheck tables, but that does not look like a true/false value.
I'm GUESSING, because you have not really provided enough details, but this might be the issue:
You have a report. The code above is from a sub-report. When the user picks one of the rows from the parent report, the sub-report displays the details for that row.
Is that what it needs to do?
Seriously, instead of sitting here doing trial and error, with more error, take an hour and read these articles. Invest in yourself. You may not find the answer, but you will at least know what questions to ask.
http://www.sqlservercentral.com/stairway/72382/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply