New to R&R RW - Break Out

[Mike_Hann_(Guest)]

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!

[Mike_Hann_(Guest)]

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.

[jtenbrook]

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

[kfleming]

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

[mhanna]

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

[BrentonZoks]

>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

[kfleming]

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