Search results for query: *

Crystal 10 on Oracle The date field I am trying to work with is represented as a number in the database. I am using this formula to convert the number to a date: (DateSerial ((int({F0006.MCD4J}/1000)+1900),1,{F0006.MCD4J} mod 1000)) If the field in the database is 0.00 then the formula...

My alternative solution is a long explanation but... The date the percentage was entered is "service date" in the system. Since I also had to test for fiscal year, what I did was checked to see if the year of the service date was in the prior fiscal year or the current fiscal year. If there...

Still didn't tell me how you knew it was me! Anyway, I understand your logic now but I was playing around in the meantime and I started experimenting with another way. I will post the alternate solution if it works. Later!

hey - how did you know that it was me!? There are 12 buckets, one representing each month. The buckets themselves do not contain a date. They contain a percentage complete on the project. So, how would the calendar quarter function work when the value in these buckets is not a date? Maybe...

Crystal 10 on Oracle I am working on a report that uses a separate field for each month (1 - 12). If todays date is in one of the month buckets, I need to grab the value in that bucket and use it in a "quarter" formula. The value in that bucket is the percent complete on a construction job. For...

Thanks for the replies. jdemmi and IdoMillet - you don't suggest a section for placement of the subreport(s), which is what I was after. IdoMillet and Madawc - if I use two subreports, what section do I put them in, details? I was looking at a report my predesessor wrote and there were at...

Crystal 10 Oracle I would like to get my subreport placed so that it is horizontal (across, not down) to my main report data. I have tried just about every combination of subreport placement, insertion of additional sections and the underlay option. Both the main report and subreport are simple...

That's what I was looking for - thanks!

Oh, I am still curious about why my running total/count formula didn't work...

Looks good. I'm at this client again next week and I'll give it a try. Thanks!

Crystal 9 ODBC My problem is twofold: First, I am trying to count heads of household that are handicapped/disabled and heads of household that are not handicapped/disabled. "Y" represents handicapped/disabled and "H" represents head of household. My running counts evaluate the first statement...

Thanks Madawc - that would be a good thing to try next time.

That's pretty much what I ended up doing. Thanks for the reply.

PLEASE DISREGARD MY POST - I DIDN'T REALIZE I WAS IN SOMEONE'S THREAD. SORRY!

Using Crystal 10 & SQL database: This should be simple. My first group is on employee name. My second group is on transaction date (with the by month option). I have a summary count of the date details (how many transactions) but I also need to count the number of distinct months/year for each...

Using Crystal 10 & SQL database: This should be simple. My first group is on employee name. My second group is on transaction date (with the by month option). I have a summary count of the date details (how many transactions) but I also need to count the number of distinct months/year for each...

thanks - that clarifies it.

CR Version 11 When using Not OnFirstRecord with New Page Before and Not OnLastRecord with New Page After in the Section Expert, how do these two funcions actually get rid of blank pages? What are the conditions the functions are testing? I'm trying to understand the logic behind what I am...

Sorry - wrong forum!

Version 11 When using Not OnFirstRecord with New Page Before and Not OnLastRecord with New Page After in the Section Expert, how do these two funcions actually get rid of blank pages? What are the conditions the functions are testing? I'm trying to understand the logic behind what I am using...