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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.