Search results for query: *

Has anyone tried doing a bill of materials report in Crystal? I have 2 tables. See the picture below to get a rough idea. BOMVERSION is the grouping by BOMVERSION.BOMID, and then a table with the lines in on is (BOM). Our lines have 2 item types. Phantom and Item. If its a phantom it has a...

Hello, Ive got a string (its actually all numbers but its a string) Sometimes its formatted 0004, sometimes 002 and sometimes 0000006... basically i need to remove all leading zero's from the string. ive been trying to use this: numberVar loglength := Length...

Hello, Im not sure crystals up to this one... ive tried to use the file system data query but cant. I would like to compare 2 directories. One contains my files that are CGM file types, the other directory contains the PDF's for these files. I want to make sure that all the files in the CGM...

An easy one I know but im tired and the end of the day. Using Crystal 10. I dont need any connectivity to any db either! I just want to use crystal to make a document. Ive got to print out a list of numbers in 4 colums over several pages. Number list starts at 25,001 and goes up to 40,000. 4...

Hello, Im running crystal reports XI and SQL 2000. I have a weekly XML file I recieve. I need to compare it to my database to find if any item numbers that are in the file are not in the database. Unfortunatly the XML file has the item number text parsed as " 12345678" where in my SQL...

I’m trying to get my head around a problem and ive finally drawn a blank. I’m trying to create a history report, which compares our sales orders over the last 4 weeks to see what changes have happened. On Mondays I plan to run a job to capture the current sales order numbers, items, qty and...

Hello, I have a report which currently uses a subreport to summarise all the entries in the main report. I supress the details section, and use group 1 and group 2 for the main bit of data. We have 4 customer groups. DOM, EXP, I/CO, KSS. They each have a summary of the data in Group Footer 1...

Hello folks, my first post so please be gentle! Ive seen the wealth of info you have to give, unforutnatly I couldnt seem to find anything I could relate to my problem. I am trying to generate a summary report on an our order book, grouping figures into date ranges. While this would be great it...

Hello, 1st posting here and im hoping i can have some light shed on my problem. My company works in shifts, and data can be entered up to 4 am in the morning. Unfortunatly our new erp system only works by 12am to 12am even though we class up to 4am as the same day. I need to be able to...