Search results for query: *

Here is the SQL: SELECT INVENTORY_MSTR."PART", INVENTORY_MSTR."PRODUCT_LINE", INVENTORY_MSTR."QTY_ORDER", INVENTORY_MSTR."QTY_SAFETY", INVENTORY_MSTR."QTY_ONHAND", INVENTORY_MST2."QTY_MAXIMUM", INVENTORY_MST2."NAME_VENDOR", JOB_HEADER."QTY_ORDER", '20' + {fn...

I have made a couple of reports in Crystal Reports 8.5 Professional that use either 2 or 3 unions depending on the report. Our software vendor just upgraded the crystal viewer for all of our users to Crystal X. All of our regular reports work just fine, however when I go to run a report that...

Hi Ido, Thanks so far for all your input but I still don't understand how to get the list of raw material. If a user enters a part number, how can I traverse the BOM to find every piece of raw material used in that part? Thats the part that has been holding me up. Are you saying I need to...

Hi Ido, Thanks for the quick response. I really appreciate the help. I'm not quite sure I follow you here, could you elaborate alittle more? In the end, i want raw materials grouped together. If I am using the same raw material more than once I only want to show it one time in the report...

Hi Ido I actually tried that but I forgot to mention it. The results weren't quite what I wanted. Let me elobrate on what happened: To show how I linked the tables here is the SQL: SELECT V_BOM_ASSM."PARENT", V_BOM_PART."PARENT", V_BOM_PART."PART" FROM "GlobalCMC"."V_BOM_MSTR"...

In your record seletion try this: {TABLE.DISCIPLINE_GROUP} Like {?Discipline_Group} + "*" If they leave the parameter blank then it should select all matching records. Be careful though, if you have 2 similar groups such as: GroupA and GroupA1. If the user selects GroupA then both groups will...

Crystal Reports 8.5 Hi everyone, I could really use some help on this. What I am trying to accomplish is generate a list that shows each piece of raw material for an assembly. It would like like follows: Assembly 1 Raw Material 1 Component 1 Component 2 Raw Material 2...

Hi all, I'm using Crystal 8.5 I am making a report that is grouped by Customer, then by Part. Each part shows a crosstab and a chart of the average price, cost, and % margin for the month. I have checked these values and everything is fine here. The problem exists when I try to show a summary...

Could you please give a description or example of what you would like to accomplish? That would help alot.

Are you supressing a detail section based on a condition? If so then you can create a that uses the same condition to output a 1 or a 0. Then you can summarize that with Sum which will give the the number of records suppressed. Formula {@Suppress 1_0}: If <Condition> = true Then 1 Else 0 This...

I just tried it and it seems to work. Try to type in a 6 into the font size field. Even though its not listed you can still enter in your own font size preference.

You should check out Ido Millets Datalink Viewer at www.milletsoftware.com

Thanks for your sympathy. Our MRP system "upgraded" to use pervasive recently and I am alittle less than impressed with its SQL capabilities. That sounds like a lot like a UNION ALL. And I've done that before to compare Open Orders with Order history. Pervasive allows me to run Union queries...

Thanks for the response demoman. However normalization isn't exactly the problem. The database is running on Pervasive.SQL 8.5 and is maintained by our MRP software vendor I do however have the ability to create views and store procedures. None of the tables are a direct many to many...

You want the ASCII value for a horizontal tab which is 9 So Chr(9) should give you what you want. for more ASCII values, check out www.asciitable.com

Well I don't know much about arrays in crystal, but is there any chance you could create a time dimension using an Access Database and adding that to your report?

Does your database have some sort of Time Dimension in it (a table that is a list of possible dates)? Most data warehouses have them, but not all. If so then you can use a left outer join to relate that to the date in your job table. Then you could use a formula to show zeros if your records...

What do you mean by "items in a list"? Please elaborate. If you want to display a check mark based on the condition of a particular field in your report you can create a new formula that displays capitol letter 'P' in the Wingdings 2 font. for example @Checkmark if {Table1.Field1} > 50 then...

I'm running Pervasive 8.5 and I want to use a subquery as an item in the SELECT clause. I have a view that relates Inventory to Jobs in Process so I can get the total WIP for a part and compare that to whats onhand. However I also need to compare this to a summary of Open order quantity, and...

Whoops, my mistake. didn't see that there. Anyway, you could try adding a WhilePrintingRecords to your formula with the variable which would look like the following: WhilePrintingRecords; stringVar RIGHT_SIDE:= RIGHT ({LABOR_TICKET.EMPLOYEE_ID}, 4); ToNumber (Left (RIGHT_SIDE,2)); However...