Not sure if this is possible, but figured I'd ask. I have a .qvw with a straight table that has many expressions. Since I'm unable to click on these cells to filter the table down, I export it to Excel and distribute accordingly.
What I'd like to do is use the contents of this straight table (unfiltered) as the data in another .qvw, were I could then setup list boxes, etc., to slice and create visualizations, etc.
You can export the table data to excel (or a qvd or text file) and load the excel file in another qvw document. You can't do it directly. Right click the table, choose Export... and enter a filename and choose a data format.
You can export the table data to excel (or a qvd or text file) and load the excel file in another qvw document. You can't do it directly. Right click the table, choose Export... and enter a filename and choose a data format.
Thank you Gysbert, I exported this to a .qvd and it works well. I created a 2nd .qvw to import from the .qvd.
When I need to get updated data, I would first reload the .qvw with the straight table, then reload the .qvd? I would like to automate this so I can simply open the 2nd .qvw (which will pull from the .qvd) and reload to see updated report data.
Finally understand how the .qvd files work. It was my first time using them, so sorry for the novice questions. Anyway, I now have a button on my main .qvw that will refresh the .qvd file. From there, I can simply open my 2nd .qvw and reload the data.
