This forum is now out of date, for our new forum Click Here
Changing Views
Question Asked
Hi,

I've imported a set of reports and managed to import the view twice under two different names.

Is it possible to somehow change the views the reports are based on to the correct name? Both views are identical and both have different reports. I just need to point the reports from one to the other and remove the duplicated view.

Thanks

Brendon

null

Wed Jul 11, 2012 1:22 PM

Answer
Hi Brendon,

The easiest way would be to re-import these reports as new reports under the correct view, and then delete the other reports & view.

You could think about doing this in the database, though making such changes is not supported as there are many table relationships that would also be affected.

We suggest the export/import method as the safest and easiest option.

Please let me know how you go.

Regards,
David

David

Fri Jul 13, 2012 11:12 AM

Comment
Thanks David,

That's what I thought.

Cheers
Brendon

null

Fri Jul 13, 2012 11:27 AM

Comment
So, in order to change the view a report is based on, the only way is to export and re-import the report? If this is true, can you post these steps?
Thanks,
Rebecca

guest

Thu Jan 10, 2013 6:11 AM

Comment
Hi Rebecca,

That is correct, as you can imagine Views are critical to creating reports, if a view is broken, the reports are essentially broken.

When reports are built it's assumed that the view itself will not be removed, you can modify the view, though you cannot remove items that are in use by existing reports.

It's just a way to make sure reports are not destroyed by view modifications.

Information on importing/exporting can be found in the following wiki: Export & Import Report Repository

Regards,
David


David

Thu Jan 10, 2013 4:35 PM

Comment
Hey I have a similar situation but the reports point to a csv file. Now when I go to import the report it wants me select a database view and the csv files are not in the drop down list. How can I point change the report to point from one csv to a different one?

Derek

Fri Feb 5, 2016 7:22 AM

Comment
Hi Derek,

Whilst I don't have the details of your report and view, I would take a guess that you imported your CSV through the ReportBuilder. Could you please try importing CSV data via the View Builder, the difference is that the View you created from the CSV Data will be visible and thus can be selected during import. Here is the link to our Wiki page on importing CSV data in the View Builder.

http://wiki.yellowfin.com.au/display/USER71/View+Builder+CSV+Import

regards,
David

David

Fri Mar 4, 2016 4:37 PM