Can't delete query linked to pivot table (Updated)

Antanella Tirone · April 22

Hello! I am in the process of cleaning up our query tab, and part of that process has been identifying and removing old queries that are no longer being used.

I've come across 2 queries that I cannot remove, due to them being “used as a source for a Pivot Table report and cannot be deleted.” However, under our reports tab, there is no category for Pivot Tables, and when I try to click the report the query is being used in at the bottom of the screen under ‘the selected query is used in the following…’, I get an error message that says “This report requires a valid installation of Microsoft excel(TM) 2000".

I understand that Microsoft integration changed a couple years ago now, but is there any way at all to access these old reports so I can unlink the query and delete them? I have full admin/security access, I'm just not sure where to start.

Thank you!

--

So, I just got off the phone with Blackbaud Support and was told that this is a known issue but not one they are able to correct. Recommended solution is to create a new category for the affected query and keep them there.

Not the answer I was hoping for, but I suppose it's better to know now rather than spend the rest of the week fighting with it.

Jacyn Stewart · May 29

@Antanella Tirone I've had an open support ticket about this since April '22. I find “put them in a new category” pretty unacceptable. At this point I can only hope the problem goes away when they stand down database view in the future.

Antanella Tirone · May 30

@Jacyn Stewart I completely understand the frustration! I would love to see a solution to this offered as they begin restricting access to the database view, but I'm not very confident given the explanation BB Support gave me.

Elizabeth Johnson · May 31

@Jacyn Stewart I know I have a few of these and can't find them at the moment. Have you tried deleting them from the web view (assuming you have access) I'm curious if it works from there. If not I didn't see anything for this in the idea bank… I looked both under RE and RENXT idea banks.

JoAnn Strommen · June 2

@Elizabeth Johnson Have same issue. I just tried deleting in web view. Got the red box. ?

b241709bee039a7610684f6339addd35-huge-im

Elizabeth Johnson · June 2

@JoAnn Strommen Thanks for confirming!

Elizabeth Johnson · June 14

@Antanella Tirone I started an idea in the RE idea bank for this and this idea in the RENXT idea bank for this.

Can't delete query linked to pivot table (Updated)

Comments

Categories