I am facing a problem desgin the below report,

 

Data Source is BI , and the output is below

	Group 1				Group 2
	C1		C2		C3
	A	B	A	B	A	B
Value 1	2		4		1
Value 2
Value 3	45		2		11
Value 4
Value 5	24		2		1

 

i want to show this output in CR

i tried using Cross tab but it is not working with me cause they need some special and custom modification

i designed the whole report manually and puted the value field through formula in the detail section and got the result as below

 

but the problem is when i run the CR i get the desgin below

	Group 1				Group 2
	C1		C2		C3
	A	B	A	B	A	B
Value 1	2		4		1
Value 3	45		2		11
Value 5	24		2		1

 

Value 2 and Value 4 are missing cause there is no data for them

 

Please let me know if there is any solution for this , what i can think of right now is to create all the Value manually but then i have to write manually all the formula for Value 1-->C1-->a , Value 1-->C1-->B,

Value 1-->C2-->A , ......

 

Thank you in advance.

 

Regards,

 

I tired this option and it did not worked the only best way to do it is manually