How can i create qvd files?

[jagannalla]

Hi,

I want to create qvd files from front end. I'll explain briefly what i required.

- I know how to create qvd files from the edit script.

- In my report i have taken a table box or straight table i can generate the data into excel.

- Now, I'll take one button in the sheet when i click the button i want to create qvd file for particular table box or straight table data.

Is it possible to do it?

If possible how can i do this?

I need solution whether we can do or not. Plz help me if possible

[montubhardwaj]

WoW.... that was perfect. We can store straight/pivot tables directly into qvds ....!!!

[jagannalla]

Thankq so much to share your knowledge with us...........

[jagannalla]

Thankq sridher it's working perfectly.....

[jagannalla]

How can i generate excel,pdf,text,delimeter files. For each i want to take button......

[jagannalla]

Thank you so much Gopinathan to help me.....

- I need one more thing.

I want to generate same thing to multiple tools like excel,pdf,text files. For each i want to keep different buttons.

[rwunderlich]

Forget the buttons and the macros. Just right click the object, select Export and you can choose the format you want, including qvd.

[montubhardwaj]

wow.....thats so simple.....thanks for sharing..... amazing....!!!!

[jagannalla]

This so simple but if it works in access point level.......

[#10]

u can add the codes within the same macro...

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4

the above script will store only straight or pivot tables into .qvd format.

it wont store the table box into .qvd format.

if you use  the below script it will store delimiter format only, if you have doubt store one file and open the table in qlikview then u will see the format of loading, if you select qvd radio button the table will be empty.

set obj = ActiveDocument.GetSheetObject("CH395")

obj.ExportBiff "C:\Test\test.qvd"

if you want export  to like excel,pdf,textfile write down the following things in your macro

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4

change the following numbers are add extra lines like

Set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "C:\test.qvd", 4 for qvd

obj.ExportEx "C:\temp.xls", 6   for excel

4 qvd

3 xml

1 delimited

0 html

5 xml

6 xls

[jagannalla]

Rob,

How can we create qvd at access point using button.

If we right click on object, select Export will work at access point.