topic Possible Issue Macro To Create Reports in QlikView

Possible Issue Macro To Create Reports

marcel_olmo — Mon, 18 Apr 2011 14:41:02 GMT

Hey guys, I've been developing an useful tool to autogenerate reports using macros.

I've my own function based in the api guide to create reports, called myReport , and another one to get the ids of the current reports, called reportCount, as you can see:

I've created a hand made report, called "handMadeReport", with the chart and a little text box.

If I execute the macro that calls myReport function, I've listed two Reports, my hand made report ,"handmadeReport", and the autogenerated report, called "myReport0".

But, If I click on "Edit Reports", it only shows me my handMadeReport, and when I close the "Edit Reports" tab, my new report dissapears.

As you can see :

It could be some kind of bug?? Anybody knows how can I solve this issue ????

I''ve attached my test document to help us to find the problem.

Many thanks in advance!!!

Possible Issue Macro To Create Reports

Mon, 18 Apr 2011 15:38:28 GMT

Hi Marcel,

i don't know what is the problem but i test you file and works fine (no reports disappearing) Tested it with v9 SR3 and v10 SR1. Which version did you use?

Stefan

Possible Issue Macro To Create Reports

marcel_olmo — Mon, 18 Apr 2011 16:01:42 GMT

Hi Stefan, I've executed my uploaded file in another folder, and you're right. The first time you execute the macro. It stores the executed report fine.

But if you delete the generated report, it doesn't work anymore. Maybe the document is loosing the pointer of the id, or anythin else. I don't know.

If you delete your generated report, and you try again, you can see I'm right.

Many thanks for your interest Stefan!!

Possible Issue Macro To Create Reports

Mon, 18 Apr 2011 18:39:54 GMT

Marcel,

you were right that after deleting the report the problem appears and definitely there is something wrong but i noticed something that "helps" to report to appear. Create MyNewReport0 report -> delete it -> create again -> open Report Lists -> press Esc (don't click on OK button) -> open report lists and the report is there :-)) if you press the OK button the report is missing 😄

Very wired behavior.

Stefan

Possible Issue Macro To Create Reports

marcel_olmo — Mon, 18 Apr 2011 23:06:53 GMT

Thanks again Stefan for your time.

In fact, this is what I'm actually doin to avoid the "strange behaviour".

What I'm asking is to know if there's some kind of trick to avoid this behaviour (because I can't tell to a costumer your option), or otherwise, I have to wait until QV 10 SR2 to get this "possible bug" repaired.

Many thanks anyway!!!!

Possible Issue Macro To Create Reports

Tue, 19 Apr 2011 16:30:47 GMT

Marcel,

i tried few things but no luck. You may consider contact QT support for more help/info (or as you wrote to wait v10 SR2 to see if this scenario works normal)

Stefan

Possible Issue Macro To Create Reports

marcel_olmo — Tue, 19 Apr 2011 17:01:56 GMT

Thanks Stefan, What I'm trying now is to open the edit report tab and click cancel via Macro, but I found no way to do it. 😞

Possible Issue Macro To Create Reports

Miguel_Angel_Baeyens — Tue, 19 Apr 2011 17:52:43 GMT

Hi,

I think it's worth an email to the Support team. What I see so far is related to the precedence of "Document\" or "User\" in the name of the report ID what makes QlikView to first add the report but at the end "lose" it. But unfortunately I didn't get the trick yet.

Regards.