Hi,
I am trying to create a report that will show me results for a specific week. I have 1 transaction on the 7th of July and I have 2 transactions on the 8th of July. In the July 8th column, there are 2 transactions and that is correct. However, if you look at July 7th, there is 1 transaction, but it is duplicated because there are 2 transactions on the 8th. Does anyone know how to resolve this?
Thanks,
Wilson
Date
Votes
8 comments
-
Jet Reports Historic Posts Hello zwillow,
I would love to help you with this but without seeing the functions you created, I don't know how you are bringing in the information. Could you attached the report in Design Mode? This will allow me to see the Jet functions but not see the actual data returned. -
Jet Reports Historic Posts Sorry about that. I have attached the design file and the result snapshot. I removed the fluff and kept it simple. Thanks
-
Jet Reports Historic Posts Thank you for including the report. The problem you are having is because you have your Rows function in the same column (or region) as your Columns function. This will cause the information to repeat. You should try to avoid this in your reports.
What exactly are you trying to show? Do you have a mockup of what you want this to look like (when there is 1 transaction for 1 day and 2 for another)? Maybe you could list your resources down in rows (in column C), then use and NL(Filter) and NP(Join) to pull in the multiple source numbers for that day. Would that work? -
Jet Reports Historic Posts I thought I should probably make an example to help you see what I am saying. I had to change the tables around so that data would appear but I hope it gives you the idea and structure to use in your report.
In the attached example I listed out Locations (instead of Resources) and created columns of dates. In the cross-section (where the regions of the Rows and Columns functions overlap), I created an NP(Join(NL(Filter)) function that would display the document numbers. In cell N11 you can see multiple document numbers listed. Those are all the docs that have a posting date of 1/29/16 for the Green location.
Is this what you are looking for? -
Jet Reports Historic Posts Thanks for the reply. I have attached a revised snapshot of the original snapshot with the problem. This is how I would like it to look like.
One transaction on 7th of July, and two transactions on the 8th of July. This is how it should be. I will try your suggestion and see if I could make it work. Thanks again. -
Jet Reports Historic Posts Thanks for the sample. I got it working with your sample, but I need to calculate the batches I make for each item. Displaying the items side by side, will cause a problem for me. Is there anyway to display it like the last mockup I sent? Display item by row so I could calculate each item's batch amount? Thanks again for your great help!
-
Jet Reports Historic Posts With your layout, some days may require more lines replicated than other lines and Jet can't independently run the rows replicator for each column without acknowledging and executing the other rows replicators for that same item.
The only way I could think to do what you want is to separate your days onto different sheets, otherwise you have a rows replicator within a columns replicator which TheKloser pointed out.
If you separate them on different days, then you could do a standard grouping report pretty easily. -
Jet Reports Historic Posts Thanks for the help. I will work with the suggestion from the Kloser. This is the only option available. Thanks again to all.
Please sign in to leave a comment.