Crystal Report Help.

TechJunky

Ok, so I am having a problem pulling the correct data within crystal.

It is pulling from the correct field but for some reason it is pulling the very first entry of that column instead of the one thats tied to the ticket number.

Here is what I have.

I have an accounting program. The following data is what we use.



Data and Time
Ticket Number
Station Number


Quantity Sold Item# Description Price Unit of Item Extended Price






Sale Subtotal
Tax
Total
Net Tender


Notes


So here is my problem. The notes field is reporting the very first entry in that column rather than the notes that are entered into the ticket.


The problem that I think I am having is that the Header information does not have a TKT_NOTE column. This is where your Ticket notes cross reference with the header information so it knows which ticket number to place it on, therefore it just pulls the first information in that column rather than tying it to the ticket.

If you want to view the report I would appreciate it.

PS_TKT_NOTE is the table I am pulling from, and NOTE_TXT is the column I am pulling from.

Usually NOTE_TXT needs to be under PS_TKT_HDR so it can report correctly.

http://www.akgaming.com/kendall/crystal.JPG
http://www.akgaming.com/kendall/crystal1.JPG
http://www.akgaming.com/kendall/Invoice3.rpt

TechJunky

How about this... Will this formula work?

{PS_TKT_HDR.TKT_NO} = "TKT_NO"

This would be a variable of NOTE_TXT, that way it would look to the ticket date?

I am grasping at straws....

I have tried {PS_TKT_HDR.TKT_NO} = "41041" and this works fine. But the problem is I want it to select the ticket number as the ticket is being created because this is used for invoicing and not as an after the fact report.

Please any help would be much appreciative!