Exporting Queries

Emily Tompkins

BB made a workaround (for security reasons) for exporting queries in database view. Now we must save the query to the BB local drive before we can export to our own files. This creates additional steps in the process and I would consider this to be complicated for the average computer user. The filepath is quite long and not in the clients local drive

Ferdie Alayon

You can try defining your file location so that it points only to My Documents in your hosted files folder for a shorter file path.

Then, drag the file to your local folder. I prefer Downloads so it's easier to locate.

Kim Szalkus

I am able to export the file to my company's local server drive. Agree it is a pain to create the path, but at least it puts it on my network vs. the BB network. Only complaint is that I need to reformat dates and amounts.

Kevin Brazell

Here is how you save to a local or network drive, can be used for queries but works for technically anything you're saving locally :

Ferdie Alayon

Did you mean reformatting as a result of using the more generic export button?

“Export to Excel” eliminates most formatting issues.

Christina Imbriani

Hi @Emily Tompkins, these are all great suggestions! Another helpful option is to set your file locations in Tools-Option (located on the toolbar) of database view. Once these are set and you attempt to export the file, it will default to the location that you set. I've attached a few pictures to help you get to the settings.

FE - Tools - Options - File Locations

Click the (…) and set the file path for each file type.

Fen Westphal

Thank you for the great suggestion. Unfortunately the Export file type “Excel 2007(XLSX)” disappeared as I tried to export a query from FE Database view.

Does anyone have the same issue? Any suggestion for me how to find that option?

Thank you so much for any advice!

Manny Garcia

Hi,

I would suggest (if it is a query report) to save it as .CSV file and it is faster and easier, so you don't have to deal with excel options…