FrankInBerlin
IS-IT--Management
Hi Everybody,
here is the problem:
Two tables
Table 1:
Code Description
1001 aaaa
1002 bbbb
1003 cccc
....
Table 2:
customer Code
1 1001
1 1002
1 1001
2 1003
3 1004
....
Now I want to create a crosstab analysing the the Data for one customer but should show all descriptions no matter if they have been used for this customer or not.
What I want is:
Description Count for Customer 1
aaaa 2
bbbb 1
cccc 0
.... ....
In a regular crosstab I only get the descriptions for counts > 0. But this works in minutes.
I created a workaround using a regular report and a subreport but in that report a subreport is generated for every description. Since my worst case scenario is 20000 descriptions and an average time for generating the subreport is 2 min this can mean 27 Days to run this report.
Can anybody help???
With my best,
Frank
here is the problem:
Two tables
Table 1:
Code Description
1001 aaaa
1002 bbbb
1003 cccc
....
Table 2:
customer Code
1 1001
1 1002
1 1001
2 1003
3 1004
....
Now I want to create a crosstab analysing the the Data for one customer but should show all descriptions no matter if they have been used for this customer or not.
What I want is:
Description Count for Customer 1
aaaa 2
bbbb 1
cccc 0
.... ....
In a regular crosstab I only get the descriptions for counts > 0. But this works in minutes.
I created a workaround using a regular report and a subreport but in that report a subreport is generated for every description. Since my worst case scenario is 20000 descriptions and an average time for generating the subreport is 2 min this can mean 27 Days to run this report.
Can anybody help???
With my best,
Frank