Search results for query: *

I should probably add that the union query is in the SQL Server database as a view. Thanks.

I am using Crystal 8.5 with a SQL 2000 database. I have two Crystal reports that use a union query. I have a new report that needs two new fields added to that union query. If I add two new fields and rename the union query, how will that affect the existing reports? Does Crystal...

You’re right, it is slower, but IT WORKS. THANK YOU, LB!

I tried modeling my report after the Business Objects sample report using arrays and ran into the 1000 limitation problem. Is there any other solution? Thanks in advance.

Thank you for your quick response. My apologies for not posting DateInterviewed as a formula in my first post. The exact content of the two formulas are below. I am working with a SQL view named “Interviews”. {@DateInterviewed} If isnull({Interviews.HistoryTimestamp}) then ({@FInterview})...

Thank you, lb, for your response. DateInterviewed is actually a formula field that has another formula embedded in it – If isnull({Table.HistoryTimestamp}) then ({@FInterview}) else {Table.HistoryTimestamp} Is it possible to use a formula like this with your SQL expression example...

I am using CR8.5 with a SQL database. I have a report grouped by recruiter name and detail of interview information as follows: Group1: Recruiter Jim Smith: Detail: Name DateInterviewed InterviewedBy Req# Jane Doe 3/1/2005 Betty Banns 578...

Thank you, lbass!! That one simple change fixed my report. I now have zeroes in every field that doesn't meet the conditions. Also, strangely, both conditions are now working as they should. Such a simple solution---you are a lifesaver!!!

Looking at the report again, I see I am getting the SECOND condition only. I need both conditions to be met and I need a zero for every record that doesn't meet the conditions. I hope this is possible. Thanks!

I have Crystal 8.5 so can't use chleseatech's option. The three formula technique works (sort of) with one condition (as noted above, it doesn't force the zero). When I add a second condition, it ignores it. If I reverse the conditions, it works with the first and ignores the second. Here is...

I have the same problem as Andy (blanks where there is no data for a field that doesn’t match the criteria) and tried the trio of little functions, but they did not work for me. The @Display formula that Brian gave is the exact same as the @Accumulate formula. Is that right? How did you get...

I FOUND THE ANSWER!!!! It's from lbass in thread767-891598 titled "Crystal official formula bug? Or just me?" lbass recommended a couple of changes to the Business Objects formula and along with Bobsuruncle's first suggestion, I have the report I need. THANK YOU!

It needs to be 0 hours when the Contact Date (End Date) is before the App Date (Start Date). Your suggestion (thank you) worked for that. It’s the following that’s puzzling: App Date Contact Date Hours 1. Mon 1/10/2005 8:14:44 PM Tue 1/11/2005...

Here is the entire formula from Business Objects. When I added your code (to the section below titled "Finish formula if FirstDateTime or LastDateTime is null"), I get 0 hours for everything!! //CALCULATE THE NUMBER OF BUSINESS HOURS //BETWEEN FirstDateTime AND LastDateTime //INCLUDING...

Can you be more specific? Would I use something like If Time(LastDateTime) = ????? then ????

Yes, thank you, BobSuruncle. I placed this in the Business Objects formula like this: IF FirstDateTime <=Date(0,0,0) or LastDateTime <=Date(0,0,0) or LastDateTime < FirstDateTime then hours:= 0 It works for contact dates and times that are before the app dates and times but I’m still getting...

I am using Crystal 8.5 and need to calculate business hours, no weekends, including holidays. I found the sample report called BusinessDays_Hours (How To Calculate Business Hours or Business Days) in the zip file cr_business_dh_samples in the Business Objects knowledge base. The code for the...

I am new to Crystal(using Crystal 8.5 with a SQL database). I need to show average days to fill for positions. Positions can be placed on and off hold multiple times. There are two tables as follows: Table--Positions: PositionID DateOpen (date/time) DateFilled (date/time)...