Welcome! Log In Create A New Profile

Advanced

[wd20] combine 2 report

Posted by ccc2 
Forum List Message List New Topic
ccc2
[wd20] combine 2 report
March 13, 2018 11:17AM
I have 2 report which i need to combine , then output as excel.

for example
Report1

Item01 Supplier1 price
Supplier2 price
Supplier3 price
Item02 Supplier1 price
Item03 Supplier2 price
Supplier3 price


Report2
Item01 Customer1 price
Item02
Item03 Customer2 price
Customer3 price
Customer4 Price



Result combine

Item01 Supplier1 price Customer1 Price
Supplier2 price
Supplier3 price
Item02 Supplier1 price
Item03 Supplier2 price Customer2 Price
Supplier3 price Customer3 Price
Customer4 Price

is this possible ? I try to do using excel but no luck
Reply Quote
Markus K.
Re: [wd20] combine 2 report
March 13, 2018 04:02PM
Hi,
why do you need reports? Why do you not write all values in a table and export then the table to excel?
Reply Quote
steve erts
Re: [wd20] combine 2 report
March 13, 2018 07:28PM
Quote
Markus K.
Hi,
why do you need reports? Why do you not write all values in a table and export then the table to excel?

This is how 75% of my reports are written. Works great
Reply Quote
Allard
Re: [wd20] combine 2 report
March 23, 2018 12:26PM
Hi

How do you create your reports now? With the report generator or other wise, if otherwise please explain.

This looks to me just a data collection problem ( As Markus kind of Mentioned and gave a solution for ). Is it a query ? If so change the query

I know a bit of an obviouse answer. You need be more specifict on what you mean by reports and how you make one to get a better answer form me

regards
Allard
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: