Search results for query: *

CR10 From a table containing the following two fields: "URL", "DateTime" I'm looking to calculate the total time spent on internet sites, data is in the following format: <Row 1> www.bbc.co.uk 01/08/2008 12:40 <Row 2 >www.bbc.co.uk 01/08/2008 12:42 <Row 3 >www.bbc.co.uk 01/08/2008 12:43 <Row...

CR10 Can anyone help me to write a forumla on a text field that will pick out the main site from a URL: IE www.newss.bbc.co.uk from http://news.bbc.co.uk/sport1/hi/football/default.stm AND edinburghnews.scotsman.com from...

Quick question, Is it possible to deny print access to files under a certain folder? Thanks for any suggestions.

Outlook 2003 I'm looking to see if there's a way for recurring appointments in Calendar under the 'By Category' view to show as separate individual appointments (ie one appointment every Monday morning as opposed to only one appointment showing) Thanks for any advice!

The Pc time is correct The value under Report->Set Print Date and Time is set to 'Todays Date and Time' but still my date value is incorrect.... (05/Sep when it should be 09/Sep) Any suggestions much appreciated

MS Access 2003 SP1 Ok, apologies for what might be a really simple problem. I'm taking data from a spreadsheet, and exporting it out to txt files using Access Macros. Instead of getting the date in the correct format I require I'm getting it as follows (ie with three digit number in front for...

CE V9.0.0.287 Database: Oracle Viewer: DHTML What is the difference between the 'Preview' and 'History' options within Crystal Enterprise. A couple of my reports I can view ok when using the Preview option but when I try to look at them through the History Option I get the following message...

I get the message: "Unable to retrieve Object. ClassFactory cannot supply requested class " when I schedule a report. I can view this ok through Crystal reports but when I schedule it, it seems to run successfully but when I go to view it I get this error. Any thoughts/suggestions? Thnx for...

Apologies in advance if this is a simple query but I'm very new to Access. I have created a Macro within Access 2003 that has two Actions; TransferSpreadsheet and TransferText. The first Action takes two fields from a spreadsheet (ie FEB 99.32) and creates a table. The values within this are...

Enterprise V9 Apologies if this seems a simple question but this is new to me. Is there an easy way to remove the titles "No reports" & "No Folders" from ePortfolio when browsing through the directory structure? Thnx for your help

Hi, Is there a better, tidier way of displaying report history? I have a report that runs once a month displaying production availability statistics for each month but when my users (snr mngt) look the the history within ePortfolio they get something resembling the following: Instance Time...

V9.0 Ive read through past postings on Chart Legends but couldn't find a resolution to what seems to be a simple problem. When I click on the Legend object the sizing dots appear allowing me to resize my label so that it's in the format: X Availability Y Unavailability and it seems to stay...

I'm trying to write an Access query to remove the leading £ sign from a currency field. Any suggestions on how to do this? Apologies if this is pretty obvious to some people but it's all new to me. Thnx for any suggestions, IanG

Crystal Reports V9. I have changed the 'Date' and 'Date and Time' format fields under File, Options, Fields so that it displays as DayMonthYear but when I'm setting up default dates for a date parameter field it's looking for these in the M/D/Y format. Is there somewhere else I need to set-up...

Crystal Reports V9 Oracle DB I have successfully run my report in Crystal Enterprise. The first page is displayed fine but I get the following error message when I try to view the 2nd page (Containing graphs) through Crystal Report Viewer (or ePortfolio) but when I preview the report through...

Hi all, I'm using Access Macros 2003 to get details from an excel spreadsheet into text files which are then loaded into an Oracle database. I'm using the 'TransferSpreadsheet' action to copy the details to a table then the 'TransferText' action to move it to my Oracle-ready input file...

CR 9 against Oracle Hi all, I have a current bar chart created which charts against values in the region 0 - 12000. I've been asked to add another column in the form of a Trendline for values in the region 140,000 - 200,000. Is there any way to create a different scale on a second y-axis so...

CR9 against an excel spreadsheet on a network drive (L:) Hi all, I'm attempting to run my report through Crystal Enterprise using the 'Run Now' option when I get the following message: "Error Message: Unable to connect: incorrect log on parameters. File C:\Program Files\Crystal...

CR 9, Oracle DB I have two formulas which display two times which I'm trying to create a basic percent bar chart against. The first formula is the average time above SLA and the 2nd is the average time below SLA, e.g. 09:22:23 01:16:19. This is so I can show each component's proportionate part...

Using CR 9 against an Oracle DB Ok, I know that the cr9_charting_print_time_formulas.pdf details the process for doing this but I still can't get this working... :-( I'm still relatively new to Crystal so apologies in advance if this is obvious to others. I'm trying to pass a datetime value...