topic Print All Reports Macro in QlikView

Print All Reports Macro

Mon, 01 Nov 2010 15:07:26 GMT

Hello All,

I am attempting to create a Macro that will print all Reports within a .QVW. I can easily create a macro that looks like this:

Sub Print_Reports

ActiveDocument.PrintReport "RP01"

ActiveDocument.PrintReport "RP02"

ActiveDocument.PrintReport "RP03"

End Sub

But, what if I add another Report? I would have to remember to add it to the macro.

What I would like to do is loop thru an array of the Reports and print each. Something like this:

Sub Print_Reports

Set reps = ActiveDocument.GetDocReports

For i = 0 to reps.Count - 1

Set rep = reps.Item(i)

ActiveDocument.PrintReport rep

End Sub

However, this doesn't work. It doesn't like the syntax of "ActiveDocument.PrintReport rep". How do I call each report in proper syntax?

Thanx

boorgura — Mon, 01 Nov 2010 15:48:18 GMT

Try this:

Set rep = reps.Item(i).text

ActiveDocument.PrintReport rep

Let me know if it works.

Mon, 01 Nov 2010 16:03:47 GMT

Sorry..no joy. It doesn't like the syntax "Set rep = reps.Item(i).text"

boorgura — Mon, 01 Nov 2010 16:07:54 GMT

Try this:

For i = 0 to reps.Count - 1

ActiveDocument.PrintReport reps.Item(i).text

Mon, 01 Nov 2010 16:23:08 GMT

Got it to work. Here's the syntax:

"ActiveDocument.PrintReport rep.id"

Thanx for your help.