Search results for query: *

Hi Ian, It works! Thank-you! However, now the report runs quite slowly and speed will be a factor. So I will have to see what I can do about that. Thanks again!

Hi I am running Crystal XI with the upgrade. I recently upgraded my ODBC connection from SQL Server to the SQL Native Client 10. I received a series of errors where it seemed that the databased was busy with another command and therefor would not answer my queries. Is that a typical/usual...

Hi Madawc - I tried that within the Command box and it didn't work. Crystal didn't allow the & "000000" in the command box. The reason I am trying to do it within the command is so that I can link it to a table and then have data from the command and the table pull into the report based on a...

Hi! System info: Crystal XI, Microsoft SQL server, JDE database I am trying to create an consignment inventory report pulling in the customer account name based on where the inventory currently resides. I am trying to create a command and within the command convert a numeric field to text...

James- thanks for walking me through this. I apologize, I thought I had a good understanding of how the files worked from my experience in Access. Just goes to show me that there is always more to learn. Thanks for the new link - I will bookmark that too! Turkbear - I e-mailed my IT and they...

Ok - I relinked - shows "F0911.GLAN8 --> F0116.ALAN8". I selected the "left outer join" option. Under "enforce join" I used "not enforced" - it returned 2282 records, I used "enforced from" it returned 2282 records, I used "enforced to" it returned 2282 records I tried "enforce both" and it...

Yes- JDE data. When I run the F0116 (address book info) file on its own there is only 1 address field per line. Yes the GL field can have multiple order lines with to the same address. I am trying to pull in the province field. The province field is only stored in the F0116. I am trying to...

I am a new user to Crystal. I am using version Crystal XI. I am trying to recreate an Access Report into Crystal. Below is the code from both reports. My Access report correctly pulls in the province (ALADDS) based on the address number (AN8), in Crystal it seems like my join isn't working...