topic Re: Simple Printing Issue in QlikView

Simple Printing Issue

Anonymous — Fri, 26 Apr 2013 13:42:02 GMT

Hi All,

I am using the following Macro to Print the Report . Every thing is working fine if I am printing the report.

The issue is, After the Print Dialog window is opened if we click on the Cancel button of the Print Dialog window its redirecting to the Edit Module page.

sub print

setvar1 = ActiveDocument.Variables("vPrintChartID").getContent.string

set ss= ActiveDocument.GetSheetObject(setvar1)

Set val=ActiveDocument.Fields("SSR_SUBMISSION_YR").GetPossibleValues(20000)

set f = ActiveDocument.GetField("SSR_SUBMISSION_YR")

f.SelectPossible

Set fv=f.GetSelectedValues(10000)

for i = 0 to fv.Count-1

ActiveDocument.Fields("SSR_SUBMISSION_YR").Select fv.Item(i).Text

Set DD = ActiveDocument.GetSheetObject(setvar1).DialogPrint

ss.print

end sub

If I click on the Cancel of the above Print Window its opening the Edit module page which is incorrect. I am not sure what is wrong with this Macro.

Request your help to overcome this issue.

Thanks in Advance...

Regards,

MSChakravarthy.

Re: Simple Printing Issue

Anonymous — Fri, 26 Apr 2013 18:12:42 GMT

I assume that it workes fine if click Print button. What is the expectaition fron the Cancel button? If there are no any special expectation, you can just add a line in your macro, anywhere before "print":

on error resume next

In this case, nothing will happen at all.

Regards,

Michael

Re: Simple Printing Issue

Anonymous — Fri, 26 Apr 2013 23:59:32 GMT

Hi Michael,

Thanks for your reply.

The result is same after adding the code "on error resume next"

The expectation is, if I click on the Cancel button it should remain on the Sheet from where I have initiated the Print.

But now its redirecting to the Edit Module Page.

Regards,

MSchakravarthy.

Re: Simple Printing Issue

Anonymous — Sat, 27 Apr 2013 09:22:09 GMT

Hi ,

Can any one suggest how to resolve this.

Regards,

MSChakravarthy.

Re: Simple Printing Issue

Anonymous — Mon, 29 Apr 2013 19:41:34 GMT

Could you please upload an example of your application?

Re: Simple Printing Issue

marcus_sommer — Tue, 30 Apr 2013 08:40:47 GMT

I think if you press cancel it will return cancel on your variable DD - this is not an error. You must it to retrieve before ss.print and it is cancel exit sub.

- Marcus