Search results for query: *

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...

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...

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 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...

Hi I am using CR 8.5 to write reports from a MS sql server 2000 running a Sage line 500 D/B .The problem is that when I query the D/B for the standard cost / material cost for an specific item I get std cst 0.0300 mat cost 0.0265 If I look at the costings in the d/b itself they are std cst...

Hi I have an access D/B that shows project data. This D/B contains a form where the data is edited ie, is the project open ,completed, comments on ongoing project activity, project sponsor,project manager,project description. my question is ,is there a way I could restrict the editing/updating...

Hi I have a report with 2 tables. order table & customer table (these are linked on the customer no, left outer with order table being the primary),I need to select an order no from the order table,and display the customer address from the order table and the invoice address from the cust table...

Hi I have a vlookup: =IF(ISERROR(VLOOKUP(H$6&$H$4&$A7&$A$20&"0",TERRITORY,2,FALSE))=TRUE,0,VLOOKUP(H$6&$H$4&$A7&$A$20&"0",TERRITORY,2,FALSE)) where H6 =month, H4=Year, A7 = prod group A20 = Territory. This returns the sales per month for each territory by prod code. But now I need rest of the...

Hi is there any way I can speed up a data refresh in MS Excel.I have a large ammount of data being returned from a MSQuery Query and it is taking forever to refresh & calculate cells I wondered if there was any way I could speed this up.

I have a report with a sureport linked, Is there any way I can take the subtotals from the sub/report and display a grand total of these on the main report.The subtotals on the sub report are generated by a formula .I need to keep the sub report as it is with the subtotals intact as it shows...

I have a report where I have to show the total no of an item being shipped by lot no used,then specify how many boxes make up the total . If I ship 240 of an item and the the item ships in packs or 24 then = 10 boxes, but if I ship 245 this will equate to 11 boxes ( 10 +1 part box). These are...

HI I need my customers to be able to run a query in an access D/B. Is there any way I can drop this D/B on the notes server and allow them to query it. At the moment the Access D/B contains static data from a table imported from a SQL server 2000 D/B,is there any way I could link these up so the...

I have 2 tables sales and orders. The sales table has weekly sales amounts ie week commencing 01/01/2005 to week ending 06/01/2005 this then shows a total sales for that week. However the orders table shows orders as the occur ie daily. how can Idisplay the orders that fall into the w/c to w/e...

Hi I have a workbook where 3 sheets contain sales data different products (sheet 1, product 1, in weekly buckets ie w/ending 4/12/04,w/e 12/12/04 and so on), the fourth sheet contains the orders data for all three products, but these are random dates not in the same date buckets.I need to know...

Is ther any way I can set a text box and its label to display conditionaly. I have a form that has a combo box with the options Project, submitted, accepted, rejected, parked. when one of these options are chosen the user needs to enter the date in a text box.I only want this text box to be...