Search results for query: *

Uncle. Better to fix it from the data side than try to figure out what MS is up to. Much gras Skip. Brookwood

Ok, thanks Skip. Any who...if another user has seen this annomoly where MS Query returns a proper date format to the worksheet for some users and a string to others where the data type from the relational database is date, then please feel free to comment with your suggestions. I just can't...

Ok, so that explains why I'm getting two different results running the exact same query with the exact same formatting, on the exact same version and SP level of XL and the exact same OS, just on two different pc's? Because MS Query decides when it wants to return data as a date or as a string?

That suggestion did not work. Here is what I'm getting on a worksheet from a user's pc that does render the desired results: Format Cells > Number > Category: Date > Type: 3/14/01 Display value: 9/30/09 Formula Bar value: 09/30/2009 1:18:14 PM Format Cells > Number > Category: General...

Here is the display value before: 2008-04-28-08.56.07.000000 The cell formatting is Number(tab), Category(list): Date, Type(list) 3/14/01. Here is the display value after: 2008-04-28-08.56.07.000000 The cell formatting is Number (tab), Category(list): General.

Yes, the system of record is Siebel 7.5.3 and the field is locked down to D_Type Date. It just blows my mind that it is formatted correctly on over half of the users opening and refreshing the workbook, and for others, it changes the formatting when the workbook refreshes the query.

I've written SQL for an external data query and return the data to the worksheet. The external query pulls data from an IBM DB2 database. I've formatted the worksheet including formatting cells to render acceptable standard MS XL date formating rather than the yyyy-mm-dd 00:00:00.000000...

OK, I'm stumped. How do you export to Excel and have the detail section autofilter without having to turn it on in Excel? Using CR XI and MS Excel 2003 Thanks.

Yes, they do.

Ah yes, not body,...the detail section of the report. Yes, I really only want to see one instance of my proposed results. Thank you, -BW

In the body of the report, I'm trying to see the following: Service Request ID Service Request Type Service Request Start Time (minimum) Service Request Stop Time (maximum) TAT So, because in my record selection formula, I've said to extract data where {V_BAR_ACTIVITY_AUDIT_TRAIL.NEW_VALUE} =...

LB- Thanks for the suggestion. Here's what happened: I got the same value of TAT for each record printed to the report(meaning for example that TAT got calculated as 41 and printed to each record). And still seeing all the permutations of the service request records for each time that the...

I have a situation in my db where I get multiple datetime stamps for parameters that I have identified as the start and stop times. The frontend tool permits the users to mark activities 'done' then reopen and mark 'done' again...and again....and again. Anywho...I need to get the minimum of...

Thanks lbass. I'd be happy to. Last Name Created Month Total BARS PC BARS Accuracy Smith 01/2008 18 2 88.89% Smith 02/2008 20 That is what I'm getting. I'd like to to see PC BARS populated with 0 and Accuracy...

I'm having some trouble with my left outer join percent formula(got too full at lunch I suspect). Anyway, I've created a left outer join to bring back all the results of one table,and the results of the right table where the condition is met. So, here's my problem. I'm trying to show the...

lbass, You are correct to assume that bar_id is the id field of the service request. And, I am trying to calculate percent at the group level. In this case, the group field is V_BAR_SR_ACTIVITY.ACTIVITY_CREATED_DATE. The value of course is a datetime value. So, I'm afraid that I added a...

I'm new to CR XI, and I'm sure this is quite simple....but, here's my problem. I need to get the percent of Service Requests where the request type is a produciton correction. So here's what I've got so far... count({V_BAR_SR.BAR_ID})%count({V_BAR_SR.BAR_TYPE}) I need the solution to WHERE...