Recent content by ajdesigns

Hi I have an access db that contains projects to be completed by a certain time .I have a form that the user uses to enter the project details ie: project no, project leader, due date, completed y/n completed date. also anothet table that contains all project leader names and email address's. Is...

I have a form where I enter projects to be completed by a specific date all data from this form gets entered into a table with fields project_no, date_initiated, project_ leader, project_description, completion_due_date, Completed_Y/N.etc. I also have another table that contains all the project...

Hi Is there anywhere I can go to find out how long (Date/Time)a user has been logged onto thier pc in the current session. We have a problem with users not shutting down thier Pc's at night, sometimes for days and I want to educate them to log off and shut down every night.If I could show them I...

Thanks LB You have saved the day once again. Again THANKS

Hi I am running CR 8.5 and I have created a report that outputs a packing list for palletisation(Packing pallets) I have a number of formula's boxes sum({whbypk.BPK_pickqty},{whbypk.BPK_product})/{@to number} \\to number changes a text string to a number to enable division\\ roundupboxes...

Hi I am working in CR 10 and I need to edit the SQL for my report, I just need to put the DISTINCT clause in, I am getting duplicates. I can view the SQL but can't edit it . Also the option select distinct records option in the database menu is greyed out , so I cannot do it that way. any advice...

Ok I have 2 groups product and lot info where a product is sold grp 1 and the lot information for that product in group 2. Each product has a weight, commodity code, I need to put all the commodity codes in the report footer along with the total weight of each comm code + grand total for the...

Hi I am using CR10 pulling data from an access table via odbc connection, also data from a Sage D/B with an OLE DB (ADO) connection. all is workig fine until I try to enter data into the report footer. Some data shows ok yet some data does not.Some data that is showing in a group header for...

Hi I have order numbers that come in as different formats ie: 123456789~DIAGNOST, 1234567891~IMMUNO, 12345678912~HAZARD 123456789, 123456789123456789, If, as the top 3 orders the number includes a tilde and then some characters. How can I just print the number to the left of the tilde, but if...

Hi I have been asked to extract data from a Sage line 500 D/B sitting on a Ms SQl server 2000. This is no problem, but then I need to present it in xml format in order it can be uploaded into a D/b on a web server to to provide reports on a web site. I have no idea about XML. what should I...

Hi can I retrieve nested tables including CLOB's from an Oracle D/B in Crystal X1. I will be upgrading from CR 8.5 To CR X1 soon and wanted to know if X1 had this capability (I know 8.5 does not). I am currently writing my reports from the oracle D/B in Oracle reports but I would prefere to use...

Where could I find information /help on sql*plus including wildcards I am new to oracle reports and I know that the data is returned from an SQL*Plus query. For instance I need to return a field where to data in the fiels starts with * normally I would use something like in the where clause...

Sorry for the delay in responding(holidays).The problem was caused by the control panel regional settings for numbers overriding Crystal, this was set to 2 decimal places changed this to 6 decimal places everything ok now thanks

converted field to text, got same result

Hi in Excel the prices are correct,when returned from an MS query. in crystal if the fields were rounded then why are'nt both fields rounded ie std cst and mat cst