Recent content by TerriO

BO 6.5 SP2 Being a CR guru I cant for the life of me figure out how to Hide a group that has no data in it on a tab. I have a tab that encompasses ALL data, then I have sliced and diced in groups. The groups show the header in a tab with no data and I want to suppress these. In CR there...

Wow, Thanks! I really appreciate your response, Sounds like it would be easier to just republish and document them from that point since I don't have direct access to query the database. Terri

BO 6.5 , fairly new to BO and may need to do an audit to verify what reports have been published to System Admin, user etc. 1. Can I look at the individual report and see what authorities it has been assigned to when it was published to Corp. Docs? I do not have direct access to the...

unfortunately Unions and views are not an option Terri

The data laid out in the example as a record LotID Pending Contract Contract Appvd XYZ 1/14/2005 2/5/2005 I need to get a total summary for all that occurred in each month , if I had 5 pendings and 2 approved for January, etc. Terri

CR 8.5 I have multiple fields that I need to total for each month (about 10 additional date fields). Pending Contracts Contracts Approvd 1/2/2005 1/12/2005 1/14/2005 2/5/2005 2/2/2005 3/1/2005 Totals for month (need totals for...

Crystal V8 Table Name Activity Date/Time Ben update 2/7/2005 5:48pm Ben Change Name 2/7/2005 5:55pm Ben update 2/7/2005 6:02 pm Ben update 2/8/2005 12:04 pm Ben pct status 2/8/2005 12:10 pm I need to...

I am a little "green" and using a very vanilla reporting tool through a web application so I do not have direct access to the database but can query it. I have a column based on a subquery that returns a value, I need to create another column in the result set that counts only if that subquery...

Thanks for your reply, but what do I need to query? Terri

I am very very rusty at Access and have created a table based on an excel spreadsheet. The spreadsheet will be updated periodically and I want to have the database automatically update with limited or no user interaction. Years ago I recall creating a macro to do this but not sure how. My...

I understand the distinct count by the hour but I need a distinct count for the client for the day and 1 client a day regardless of how many appointments that client has and it needs to be counted in 1 appt time only for the whole day. Terri

I have a facility as a group Then I show all the hours for the day I need to count the appointments for each hour for the day, but I only want to count a client once for the day that may have multiple appointments that day Example: I have 2 clients for the time range below Client A has an...

formula for duration is returning zero for all.. ({@TimeOUTT} - {@TimeINN})/60 Delay isnt working at all Terri

The data is a string(4) 0500 = 5:00 AM for Time In and Out I tried the suggestion above and was able to use the following formula (from tek tips) Time(iif(length({SCHEDULE.TIMEIN})=4, Val(Left({SCHEDULE.TIMEIN},2)), Val(Left({SCHEDULE.TIMEIN},1)))...

I am getting a Bad Format String Error when I run the report on the first formula Terri