Liveware Publishing Support Forum

I have been tasked at my job with learning to understand report writer better as right now nobody has a clue.____I work at a casino and our goal is to have a report that can be run for any date that will show certain transaction codes and the grant total of each code for all hotel guests.____For example - if there are 2 $400 charges under room and paid $200 via cash and $600 via mastercard I would like to be able to show something like this____Guest Name Room Charges Cash Paid Check Paid MasterCard__Joe Smith $800 $200 $0 $600__Mary Jones $100 $0 $100 $0____I can figure out for first 2 fields just fine, where the problem comes in is all of the transaction codes and amounts are kept in a single database so I cannot pull one from the other.____I am sure there has to be an expression that would allow me to pull the value of each individual postings under each individual code. I know if I can just figure out how to pull one code I should be able to replicate that across a number of other codes. I have been working on this for the past week with no success. My director is looking to me to make this happen as I was told it is my #1 priority. If anyone could provide some advice that would be greatly appreciated and thank you!

I forgot to add, we are using SMS Host if that is of any help.____I am looking to pull the posting codes from the IN_TRN database. I can run a report that gives the code, then each additional code after that when run the TCODE and TCREDIT or TDEBIT.____I thought about letting it run all of them, then use Query to force out what I don^t need but I am sure there has to be a better way. If I try to use Query to only run a couple of codes I^m looking for then it doesn^t go anywhere for me like I^m excluding each other.____I don^t need the individual debits and credits, just the sum after they are balanced against one another.

Are you using table In_Trn only or are you using In_res or In_guest too?

>Are you using table In_Trn only or are you using In_res or __>In_guest too? ____I am using all three of the above.

You should be able to do this by creating three conditional totals. Each will sum the amount and reset when the guest changes but will have a different condition based on the posting code.____Kathleen__R&R Support

>You should be able to do this by creating three conditional __>totals. Each will sum the amount and reset when the guest __>changes but will have a different condition based on the __>posting code. __>__>Kathleen __>R&R Support ____Kathleen, thank you, I am confused though about what I need to do to create those conditional totals. ____For example, I am currently able have it query all codes of "91X", "91Y", and "91Z" and each transaction repeats a whole new line including guest information. I would like all the "91X" codes for John Doe to be a single sum number, and right next to that all the "91Y" codes in the same manner.____I would be happy to share this report with someone if they would be able to help. Currently I am at a standstill as I am unable to find anything in my workbook that addresses my specific issue.____Any and all help is greatly appreciated

If you want to send the report to me, my email address is livesupport@livewarepub.com____Kathleen__R&R Support