Search results for query: *

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...

Thank you very much. I will speak to the DBA and get them to create a view from this logic. Thanks again for all your help!

MCuthill, thanks, CR was acting up. I reloaded the app and the @dates is working perfectly! I verified a couple dozen records, and the logic is working perfectly. Thank you very much! But there is one last thing. I thought it would be an easy matter to do, but im having difficulty. Will i be...

Sorry man, my last post contained the actual field/tables names from my report (which i changed to make it easier to read for the forum. sorry!) You are correct in your assumption that: Date1 = {rpt_hearing_schedule_queue.sched_date} Date2 = {rpt_hearing_schedule_queue.med_date} Date3 =...

Thanks again, OK - here is the @dates formula. There is no summary involved: IF Not(IsNull({rpt_hearing_schedule_queue.sched_date})) AND Not(IsNull({rpt_hearing_schedule_queue.med_date})) THEN ( IF {rpt_hearing_schedule_queue.sched_date}>{rpt_hearing_schedule_queue.med_date} THEN...

MCuthill, Here is an example of the issue where the Oldest date is being used: http://i1226.photobucket.com/albums/ee402/rbh123456789/dates_v2.jpg I also forgot to mention another criteria...sorry. If there are multiple date1 or multiple date2, the most recent one should be displayed (just...