Search results for query: *

I'm creating a departmental web page and need to insert some crystal or access reports(whichever is easier) onto the webpage. Any advice?....

O.K. Naith, I see where you are going with this. Now, what do you suggest is the best way to test this as if today were 10/1/2002? If I just change my system date, would that do it?

My problem seems to be with on the first of the month only. If I am in the middle of the month, I can pull MTD information easily, but when I get to day 1 and I need to pull everything from the previous month, I have the problems I initially listed. I tried your coding, but I actually received...

When I ran my reports for September MTD using the following formula: if (({vLOIS1.Dispdate} in Date(Year(CurrentDate),Month(CurrentDate),1) to Dateadd("d",-1,Currentdate)) then 1 else 0 I suddenly lost a number of loans that I had yesterday. Can anyone figure out why?

Naith, That's exactly what I did last night and voila! It worked. It seems you need to go through and get through all the "nulls" and "zeros" first then you can move onto the "ones" or 1. Thank you so much for all your help. I'll make sure and notate your...

O.K. Naith, I think I found out what the problem is. When I am creating @Inprocess and @commit during my query, if the result is true, I will get the appropriate result of 1, respectively. BUT if the @commit field is null(because zeros are not showing on this field), then my total count of...

Sorry, Naith, but it's still not coming out. The numbers get closer, but no cigar. I'll continue working with it for now and see where I get. Thanks for the effort, though.

It's still telling me I'm missing an ) Any idea where?

I use them in conjunction with an if...then statement. If they are true then 1, else 0

@commit = (({vLOIS1.ComKeyDate} in Date(Year(CurrentDate),Month(CurrentDate),1) to Dateadd("d",-1,Currentdate)) @inprocess = {vLOIS1.DispCode}=0 As for results, my running summary (a+b=c) is coming out as 268+99=109 --which is incorrect.

if ((({vLOIS1.ComKeyDate} in Date(Year(CurrentDate),Month(CurrentDate),1) to Dateadd("d",-1,Currentdate))) or ({vLOIS1.DispCode}=0)) then 1 else 0

I have two summary fields(the results of formulas) named @InProcess and @Committed. They are showing up perfectly on my report, side by side, just like I need them to. Now, my mgr wants me to add an additional column that adds both of these fields(I guess he can't count, but that's another...

How can I write a formula that will summarize month to date activity on several different fields on a cross-tab report? Any ideas or examples would be helpful. I am on 8.0.1. Thanks.

@committed=if (DATE(YEAR({vLOIS1.ComKeyDate}), MONTH({vLOIS1.ComKeyDate}),1) = DATE(YEAR(currentdate), MONTH(currentdate),1)) and {vLOIS1.DispCode}=0 then 1 else 0 @15days=if (currentdate - {vLOIS1.AppkeyDate}) > 15 and {vLOIS1.DispCode} = 0 and {@Committed}=0 then 1 else 0

I have written the following formula: if {vLOIS1.DispCode}<>1 and {@15Days}<>1 then 1 else 0; While this works fine, my problem is adding a 3rd parameter to this formula. As soon as I add the following, I stop getting results: if {vLOIS1.DispCode}<>1 and {@15Days}<>1 AND {@COMMIT}<>1 then 1...