Search results for query: *

yeah, that was the other way I was investigating, looks interesting so im going to have a play with it.

Thank you all for your replies. Its given me several different idea's on what to do. mocgp, sounds like you have a good grasp on what im trying to do. I have the unfortunatly circumestances that we have 30,000 released items, and 20,855 have BOMS! And we have quite a complicated structure and...

Forgot to mention im running Crystal XI to a SQL 2000 DB.

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

Thanks for your help guys. Works well! Andrew

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

Forgot to add, my crstal version is XI.

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

Thanks lb, once again your knowledge is superb. Slightly tweeked your idea and made an excel file with the records in and used that as my datasource. Spot on! Andrew

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

Managed to solve it. I had to set up my connection as ODBC to be able to do a "Command", then I created my sql view which was: select ltrim(part_no) as part_no from xml The left trim now trims fine and can be linked to my other odbc connection to my sql database. thanks for your assistance.

That would be a great idea to use, but how can i implement it? I dont know how i can edit the SQL statement. I can view it thats about it as far as im aware.

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

Hi LB, thanks for the reply. From the similar forum post i mentioned above: You said to remove the capture date from my manual crosstab, which i have. My main field now is the SalesID which I have grouped them on. As i dont have 4 weeks data I have captured every day and im using 4 days of...

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

Thanks Lbass i will give that a go.

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

Hi madawc, i wasnt suggesting that! Ive got the finished report already by hard coding dates. What i want to do is make it dynamic, so that when i run it next month i dont have to change 10 formula's dates..! I would like them to be picked up from a list of dates.. does anyone know how i can...

Hi, ive drawn up a spreadsheet to show what im trying to produce. Im trying to group the items by financial period. I would like to get the financial periods put somewhere (as i said they are in table in my db already) or hardcode them into one forumula.. Still struggling :(

Hi madawc, thanks for the reply. I know how to group select them like that, I just wanted to enter them into somewhere so I didnt have to hard code the dates every time. I want it to work out which is the first financial period. So for example the current date is the 19/01/2006, it would work...