Search results for query: *

Hi Table A is linked to Table B via a left outrer join. Table B therefore only returns records in cases where a record in both tables extist. I need to do a formula that cuts across the whole dataset (I.e. where records are returned - where there was a match; and where no records where returned...

Thanks, I will try this soon. Related to this is a day of week question: I want to generate data based on the day of the week. If it is a Monday, then the rest of the statement will do one thing, if it is not a friday, then the statement should so something else: You will see in the example...

Hi, yes sorry I should have included this! The report will basically work with the following fields. SessionName (denotes what the session is about, for example lunch, session 1, tea time, etc) Date StartTime, and EndTime Data would look something like: Date SessionName StartTime...

Hi All Currently working on CR8 professional, and are in the process of testing CR9 Advanced, as we are looking to upgrade all our reports. Although most reports upgrade fine (with minor alterations), some however loose substantial sections of the report. E.g. one specific report loose the...

Hi The date looks more-or-less like: Name Date/ Time Page viewed time elapsed ABC 14/08/03 11:01:00 Home page 0 secs ABC 14/08/03 11:21:00 Dir page 1200 secs ABC 14/08/03 11:30:00 Page 3 540 secs ABC 14/08/03 12:50:00 Page 4 4800 secs We have a policy that...

Hi I am trying to create reports from Excels spreadsheets. I have created an ODBC for Excel 97-2000, but when I go to choose the batabase, the Excel bit comes up with 'No Items Found' without the option to browse to a spreadsheet. Any suggestions? EO

Just one more twist in the tale. I now know how to include only one parameter, or all (represented by (e.g.) '*'. We run the reports on ActiveX viewer, and that is quite limiting when it comes to parameters. How would it be possible to enter a parameter 'strarting with' 'xyz''*' where '*' =...

When a report is run (over a Crystal report viewer) (Crystal v8.0), is it possible to automatically create a Excel version (automated export to Excel)? Etienne

That solved the problem - thank you very much! Etienne

Hi Crystal v8.0 I have set up a parameter (Country of Residence). The customer access the report via a web viewer. So the solutions open to me, e.g. Discrete and range values. So the customer must be able to choose a country, or ALL of them. I recall something about a "8" representing...

Just a last question Using a unique key to represent the long 'class name' not a problem - but the 4 formulas does not take into consideration multiple daily start times, but only seem to determine area sizes according to "Start time" and "End time" of the classes. This is...

Mike The page I am using is a normal A4 size. I am still batteling to get my head around the 4 formulas. I am working with realy long {@Session Name} fields, even up to 254 characters. And there might be multiple "Classes" per day (Classes = @Session Name). Does these limitations mean...

As with most things the problem does not end here!!! I am refining the report (discussed above), and as soon as I add another table, and place any of the table fields on the report - it get the following error, "A string can be at most 254 characters long", and the error seems to...

That was indeed what caused the error!!! Thanks for all the help - now I can progress this matter. I owe you 1000 beers! Etienne

Mike I emailed the report to you (I use Crystal 8.0). I have tried your suggestions but with no success. I hope the report I have emailed will help. It was emailed to mbarron@arkwright.com Etienne

Mike This is a copy of what the basic report look like... SES_Prog_ID SES_Module_ID SES_Date SES_Start_Time SES_Session_No SES_End_Time SES_Room_ID Session Name 07/04/2003 ALP1503 1 07/04/2003 08:30:00 1 13:00:00 38 AAA ALP1503 1 07/04/2003 14:00:00 1 19:00:00 38 BBB ALP1503 1...

{@sched accum} in this case is called {@Sched accum} and {@sched display} in this case is called {@Sched display} Now I created the forst formula, {@Data size}... stringvar out; numbervar spaces:=(({Sessions.SES_End_Time}-{Sessions.SES_Start_Time})*24)*10 ; out:="["+{@Session...

Hi Mike Still have the same error. This is an example of the headings and one line of report data: Prog_ID Start_Date Start_Time Session_Time End_Time Session_Name ALP1503 10/04/2003 15:30:00 3.50 19:00:00 Mary Kennedy_10/04/2003_15:30:00 Note the formats are dd/mm/yyyy hh:mm:ss So I have...

Hi Mike Thank you for your advise yesterday re time schedules in Crystal, I have followd your instructions carefully - but the error I get is "NUMBER OF COPIES OF THE STRING IS TOO LARGE OR NOT AN INTEGER". Am I correct in the following... The first formula {@to - from} goes to...

Hi there all Re: The required report must create a 'time table' for an academic institution: Let me try and explain. Time values will make up columns. Date variables will make up the rows. Database fields will populate the rows, but their size and position with reference to the 'time' columns...