Recent content by dtrinite1

OK--many thanks, Ido ~TGIF~ dtrinite

Ido-- The folder permissions will work for my objective, however,I wanted to know (since I cannot find any supporting info) whether there are options within an individual Crystal Report that allows permissions on that report to be set(in versions 8 or 8.5)--(?) many thanks~! Dtrinite

Hi Ido- thanks for the info -- any recommendations as to protecting reports from modification. I am trying to centralize rptg, and keep end users from altering reports, thereby 'breaking' them. Thanks in advance - - ~dtrinite

Thanks, Turkbear -- For some reason I thought the Crystal application itself had levels of access that could be set.

Can anyone tell me if Crystal Rpts Vers 8 and Vers 8.5 have the ability to restrict write/modify permissions on reports? Thanks in advance~! ~dtrinite

Mike -- this comparison works either a formula or a date field in the DB -- thanks a bunch for your feedback and assistance ! Debbie

---Well, unfortunately Crystal doesn't like the amendment you suggested (to use the CurrentDate function in a range) ---it returns this error message: "the result of a formula cannot be a range" so I'm back to the drawing board --

Mike-- thanks for your feedback -- that range makes perfect sense. I'll plug it in on Monday and test it out--- Thanks again and have a great weekend! Debbie

Heloo Mike, The formula is being used in the selection criteria, not the report canvas. I have tweaked it somewhat, and it does appear to be working, however, I cannot figure out how to grab Friday thru Sunday data when the report runs on a Monday. Below is what I am using now in the report...

Thanks, LB -- I had tried using the CurrentDate function a little differently (see below), then took it out of the formula because it still wasn't returning records. IF (DayofWeek ({T_LN_STAT.STAT_AGGR_DT}) in 3 to 6) THEN (CurrenDate-1) else if (DayofWeek ({T_LN_STAT.STAT_AGGR_DT}) = 2) then...

Mike, Thanks for responding -- the report is looking to the previous business day for all loan applications taken on that day --when this formula is used, it returns -0- records, and I know from querying the database that there ARE records -- And, yes your evaluation is correct... if the...

Hello, Inserted below is a formula that I have built using the DayofWeek function, which is not working in my Daily Apps report. The purpose of this formula is to capture daily loan applications for each business day of a week, avoiding the weekends (when no applications are taken). IF...

I need to show totals in a report for each week in a month Result Example: week ending 12/7/02 142 $213,678 week ending 12/14/02 154 $345,340 etc. etc. Is there a way to use the LastFullWeek function to do this and not go into a previous...