Printing Dynamic reports using "Print Report" Function
Posted: Tue Jun 03, 2014 1:27 pm
Hi Guys,
I'm trying to print an active form using the "Print Report" function of "Perspective" based on a certain dimension of the cube.
The report printing works fine. However, I want to suppress the zero columns.
I tried to attach a dynamic subset to the active form(I first created the form with a static named subset on the column then tried to change it to dynamic subset) to achieve the same so that when the reports are printed they are printed with zero suppressed columns, but for some reason the subset doesn't get saved to the view. I guess it's a bug in 10.1.1.
Anyway,
So I moved to use a macro to suppress zeros. Which worked fine. However, I later found that the Print Report wouldn't work with macro enabled excel.
So I searched a bit on the forum & found that somebody else had tried to print active forms using a macro. It worked fine as well, however now I want to insert a macro in each of those sheets. I'm not sure if that'll be a good idea.
Second & easier solution I can think of is to print them as ASCII files, but I do not want to go for it if I can get some hints about how I can print the excel files dynamically.
Please suggest if anyone has ever met this situation in the past & knows of a workaround.
I'm trying to print an active form using the "Print Report" function of "Perspective" based on a certain dimension of the cube.
The report printing works fine. However, I want to suppress the zero columns.
I tried to attach a dynamic subset to the active form(I first created the form with a static named subset on the column then tried to change it to dynamic subset) to achieve the same so that when the reports are printed they are printed with zero suppressed columns, but for some reason the subset doesn't get saved to the view. I guess it's a bug in 10.1.1.
Anyway,
So I moved to use a macro to suppress zeros. Which worked fine. However, I later found that the Print Report wouldn't work with macro enabled excel.
So I searched a bit on the forum & found that somebody else had tried to print active forms using a macro. It worked fine as well, however now I want to insert a macro in each of those sheets. I'm not sure if that'll be a good idea.
Second & easier solution I can think of is to print them as ASCII files, but I do not want to go for it if I can get some hints about how I can print the excel files dynamically.
Please suggest if anyone has ever met this situation in the past & knows of a workaround.