Possible Issue Macro To Create Reports

[marcel_olmo]

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!!!

[#2]

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

[marcel_olmo]

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!!

[#4]

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

[marcel_olmo]

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!!!!

[#6]

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

[marcel_olmo]

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. 😞

[Miguel_Angel_Baeyens]

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.