I want to show master data when there is no data in Cube, I have created constant variable with 1 value in Bex and I am using that in the crystal report but it's still not showing master data. Can anybody help me on this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is it a variable or an actual formula ? You will have to make sure with the formula the values are showing in the query already.
Thanks for your quick reply, I have created formula with constant value 1. Do I need to put that formula in rows or columns or as Free Char?
Basically I have just hard corded this formula with value "1", Am I missing anything?
that should do it