Search results for query: *

This is complete now thanks for the help.

I am still trying to learn this SQL stuff, this is the SQL statements from these to reports that are just alike: SELECT "SO_HDR"."CUST_REF3", "SO_HDR"."DOC_NO", "SO_HDR"."DOC_TYPE", "SO_LINE"."PARTNUMBER", "SO_LINE"."QORDER", "PO_LINE"."DOC_NO", "SO_LINE"."STATUS", "SO_LINE"."UNITP"...

Here is my SQL Query: SELECT "PO_HDR"."DOC_NO", "PO_LINE"."PARTNUMBER", "PO_LINE"."ADDED_DTE", "PO_LINE"."UNITP", "PO_LINE"."QORDER", "PO_LINE"."SUBTOTAL", "PO_LINE"."STATUS", "PO_HDR"."CUST_REF3", "PO_HDR"."CUST_REF4", "PO_HDR"."DOC_TYPE", "STOCK"."STK_TYPE", "STOCK"."CATEGORY"...

I am feeling real Crystal DUMB right not, I can't get this one. Everytime I try to type it in it says failed to retrieve data. Maybe this will help. All my data comes from these three tables: PO_HDR PO_LINE STOCK Fields 131A006-11-23 DP 50 SOFTWARE (VDD-09BR) 1 BREAKDOWN Example...

Sorry for the delay but I have been trying for 2 days to figure out what you are telling me to do but I have never used the Command or parameter part of CR XI. I have created a formula of the count that gives me the number of occurences in the group footer.That is better than a summary field...

Successful thank you for your help.

Part Number Description qty 114HS122-1 VALVE, LINEAR DIRECT 1 occurences 1 114R3119-3 SPACER 1 114R3119-3 SPACER 1 114R3119-3 SPACER 1 114R3119-3 SPACER 1 occurences 4 114S4909-50 PLATE 1 occurences 1 114SS660-1 MOTOR, HYD. 1 occurences 1 115785-01 CONNECTOR, PLUG ELEC 1...

Hello all , I am running Crystal Reports 11, I have a report that is focusing on counting all of our Purchase Orders. I had to count and see which parts are ordered the most.I was successful in doing a count on the PO.Partnumber field , which gave me a count of how many times each part number...

Thanks I'll give it a try.

Can I repeat this same command over again for each different number like Max= 2 OPT=1 and so on or will it fail. I want to find the easiest way to knock this out in one shot if possible.

Here are a few colums: SELECT *,MAXQTYLEVEL AS Expr1 FROM STOCK WHERE (MAXQTYLEVEL =6) PART NUMBER DESCRIPTION MAXQTYLEVEL OPTQTYLEVEL 000-36689 TELEPHONE 6 0 01-P24481F001 POWER CONTROL...

I have a table that I need to update one field based on another field . This is my Stock table for all the parts we stock. I need to go update the table reorder points. So a scenario would be where we have stock.Field 6 I need to change the reorder point.field to 4. Where we stock 100 I need to...

Here is an example: Part Number Qty Price Date Customer Type 490445-98 63 87 12/6/2005 Tool Room Company 145E3569-1 1 45 8/7/2006 Bill Johnson Customer 114S5589-7 5 98 9/6/2007 Emily Thomas Customer 4500-963 25 875 11/7/2009 Avionics Shop Company Here is an example of how I want it to look...

I am running CR XI, I need to know if there is anyway to show the details of two different tables. They are not tables that should be linked together but they have similar data. Example: Table 1- Customer Orders Customer Orders.Partnumber Customer Orders.Qty Customer Orders.Price Customer...

My apologies for going backwards here, but before I suggest this purchase to my management I want to be sure of one thing. The Crystal Reports Developer XI does not have a built in scheduler that updates at given periods without the file being open, Correct? So, I do need an additional...

Hello it's me again ,I have been testing Crystalviewer and it seems to be pretty good. The only problem is when you select refresh in the viewer it just gives you another snapshot of the report. Is there one that you know of that refresh would actually pull newer data.

Thank you, I figured it out. I was testing Crystal Report Server on my Test Server, but the report was created on the Main Server and pulled into the test server through Objects. I corrected this by changing the datasorce to the test server and now it updates and views perfectly. Thanks.

Yes ,I checked and it says ODBC (RDO)

Thanks for your help The CRD seems to be pretty Good.

Forgive me for being bumbfounde but i see they all say schedule is that perhaps the refresh of data or update that I am looking for. I will be doing all of the developing and managing of the reports I just want to make sure the users can update and print.