Viewing 15 posts - 106 through 120 (of 144 total)
Ok, I am trying now to figure out this final error actually:
I am still getting this remaining error when that field renders in the report:
"The Value expression for the textbox...
February 1, 2006 at 10:51 am
I need to do somethign like this but my syntax is not correct:
=IIf(IIf(
Not(Isnothing(Fields!New_Old_CC.Value) AND Fields!New_Old_CC.Value = 1), Fields!PDC.Value,0)
February 1, 2006 at 9:51 am
sometimes New_Old_CC may be null so I need to ch eck for null somehow in the expression functions...wonder if I should do an IIf inside my IIf to check for...
February 1, 2006 at 9:46 am
I'm trying to keep away from having to create a web interface for th is....I may have no choice in the matter but was hoping SSRS 2005 would have an...
January 25, 2006 at 6:57 am
thank you!
January 16, 2006 at 4:33 pm
yep, I thought I gave enough info, next time I'll prepare the thread better. Thanks
January 12, 2006 at 5:16 pm
found it, it wasn't my code, it was the business logic the person gave me
should have been:
CASE WHEN rmstrancde IN
January 12, 2006 at 4:03 pm
>>>>If code = 51 and amount is >= zero, you want negative ABS() amount. You have 7 records like this. that makes 7 * -50 = -350
no, there's 7 50s...
January 12, 2006 at 3:55 pm
THANKS SO MUCH. I didn't know I could do it that way...much more simple.
January 12, 2006 at 1:53 pm
SELECT rm.rmsacctnum,
SUM(rf.rmstranamt) AS [Sum rmstranamt],
SUM(rf10.rmstranamt10) AS [Sum rmstranamt 10],
CASE WHEN SUM(rf.rmstranamt) > SUM(rf10.rmstranamt10) Then
CASE WHEN SUM(rf.rmstranamt) < 0 AND SUM(rf10.rmstranamt10)...
January 11, 2006 at 11:36 am
more sample data:
74973997364913 98.68 6005.62 5906.94 6189.30
0001089080 801.11 3054.49 2253.38 3855.60
UDJ63500028 89.00 1.00 88.00 90.00
5458000420010635 200.00 18695.68 18495.68 18095.68
4264293997809656 120.00 17888.46 17768.46 18498.29
4313027999739839 2285.00 3163.84 878.84 578.84
5490990997747967 256.62 28805.74 28549.12 30247.36
74993997319337 508.21 3969.35 3461.14 5747.94
5401639000464379 -5800.00 11980.66 6180.66 6180.66
74981995937812 800.00 6279.45 5479.45 5979.45
4313088999875932 60.00 9244.98 9184.98 13889.06
4264293999946639 390.93 9901.95 9511.02 15554.51
5329041999981688 -2000.00 9220.23 7220.23 3120.23
74973999825507 4848.18 4010.91 837.27 1920.91
4264296999951798 -209.70 18873.97 18664.27 17400.77
5490993999677935 12.50 1498.04 1485.54 1486.34
5490995999656942 -170.00 16983.26 16813.26 25768.38
4313024999953478 1520.22 6375.03 4854.81 8130.25
AZN82000233 81.00 1.00 80.00 82.00
000380373-01 0.00 1541.30 1541.30 3031.01
4403859158845135 1000.00 5288.14 4288.14 5288.14
4403859158845135 -1000.00 5288.14 4288.14 5288.14
5490995999307579 4182.50 7153.58 2971.08 2988.58
YME39600006 129.97 1.00 128.97 130.97
4313032999778035 -70.00 4969.20 4899.20 7781.85
5490995999588277 210.00 15953.12 15743.12 21203.13
RNF13900049 234.00 1.00 233.00 235.00
4264294999321724 ...
January 11, 2006 at 11:34 am
SUM(DISTINCT rmstranamt) AS rmstranamt10
FROM RFINANL
WHERE RMSTRANCDE = '10'
GROUP BY RMSFILENUM
) AS rf10 ON rf10.RMSFILENUM = rm.RMSFILENUM
doesn't work, it's still summing up like values:
OUTPUT IS:
4313030999894992 ...
January 11, 2006 at 11:30 am
Ignore my last post, that was a wrong post.....PROBLEM HAS BEEN SOLVED. I was missing some SUM in my CASE statements then I took out rmstranamt in my Group by...
January 11, 2006 at 11:25 am
SELECT RMSFILENUM,
SUM(DISTINCT rmstranamt) AS rmstranamt10
FROM RFINANL
WHERE RMSTRANCDE = '10'
GROUP BY RMSFILENUM
) AS rf10 ON rf10.RMSFILENUM = rm.RMSFILENUM
doesn't work, it's still summing up like values:
OUTPUT IS:
4313030999894992 263.31...
January 11, 2006 at 11:24 am
yes, that's what I want...let me try DISTINCT one more time...
January 11, 2006 at 10:21 am
Viewing 15 posts - 106 through 120 (of 144 total)