Recent content by rbh123456789

Thanks Mike, I found that adding a SQL Expression with the following code did the trick: ( select count(distinct caseid) cd from VIEW where status = 4 ) This gave me the proper calculation. Thanks again!

Perhaps adding the trim function could help. (If {? Status} = trim('ALL') Then not isnull({PO_STATUS}) Else ({?Status}) = {PO_STATUS} )

CR 11.5 I need a method in Crystal (perhaps a formula) what will produce the same number of records that my below SQL statement does: ----- select caseid from schema.view where status = 4 group by caseid ----- Basically, i want a total count of 'caseids' with a 'status' equal to 4. The records...

Hey guys - just wanted to update this thread. After posting i decided to create a new blank report (for testing purposes) with the same SQL view; the issue did not present again, and i could see all the data; yet when i went back to the original report with the same View, the problem persisted...

CR 11.5 This is really strange. I have a view that i am working with in CR. This report is very very simple. I essentially started with a new report, and brought in my view. The issue i am facing is that a certain field (string) is being cut off at the last few characters. I have already...

Rtag - thank you very much. I don't think the crosstab is going to work for me anymore, unfortunately. This was a simple sounding report (at first), but its getting complicated now.. I think i will end up having to use subreports in order to get this type of style report...

thanks, i can try that. if i use the Mode function to evaluate the field, i believe it will show the eventtype; but i might have a problem if there is more than one event per day..

its to show who does NOT have any events booked for that specific day.

thanks RTag. Its a Sql Server 2005 database

CR11.5 I have a View that looks like this: User | eventtype | date user1 | sickday | Dec 1 2011 user1 | meeting | Dec 1 2011 user2 | vacation | Dec 3 2011 user3 | | user4 | sickday | Dec 1 2011 this report is supposed to: -list each user -display the event -display...

Nevermind. I was going about this issue the wrong way. I added the SP as i normally would any view or table. Thanks.

CR 11.5 and SQL Server 2005 I have a Stored Procedure located on our database. I created a new report, and through the Database Expert, added a 'Command' as: EXEC [DBO].[GetAvailabity] @Start_Date = N'2012-09-06', @End_Date = N'2012-09-07', @Period = N'AM', @Name = N'ALL' The report will...

Thanks all for the help, i have been away from the office. MCuthill - at this point, the report is totally blank, no groups or anything. just the tables are present lbass - since my last post i have actually unioned the 2 tables (outofoffice and vacation), which are now being displayed with 1...

Thanks MCuthill, i forgot to mention that. yes, the only parameter when generating the report is a date range. the range (lets say 5 days) would isolate those days and check the tables to see whos away. i guess i am just having a difficult time envisioning how to show the staff who do not have...

CR 11.5 I have 2 tables: 1) out_of_office_table 2) vacations_table 3) staff_table The out_of_office_table has a list of out of town events that are booked. the tables contains a unique ID for each entry, start date, end date, and the person who is away (1 person). The vacations_table has a...