Solved

Passing Generic Inquiry Parameters to Pivot Table

  • 22 November 2021
  • 8 replies
  • 535 views

Userlevel 1

Hello,

I built a simple GI that has two parameters - a date from and date to. These parameters are required and used as part of the Condition to load data.

Everything works as expected for the GI. I supply the parameters and the appropriate data records are returned. However, this becomes a problem when I try to create a Pivot table from it. Specifically, no data loads and there seems to be no way to supply the parameters specified as required in the GI. I cannot use Pivot Table Filters either, since, presumably this requires some data to actually filter on.

To get the Pivot Table to function, I realize I could remove the condition from my GI and then rely on Pivot Filters. However,  this is not ideal for my use case since I would like to keep the GI parameters and conditions as is.

How might I accomplish this?

Thanks.

icon

Best answer by KellyMarchewa 25 January 2022, 00:00

View original

8 replies

Userlevel 7
Badge +9

Hi @KellyMarchewa Please post additional information like Screenshots of the Generic Inquiry Tabs, and the output. Also, if possible export the Generic Inquiry and attach it here, so that it will be easy to understand and provide solutions.

Thanks

Userlevel 1

@ChandrasekharM . Unfortunately, can’t really export and upload full output, but please see screenshots below.

Thanks.

Userlevel 7
Badge +11

Hi @KellyMarchewa 

Please try using filter on GI result window and create a Pivot from filtered result content of the GI. 

  • Create filter on GI output
  • A new tab with filtered output reflects on GI result
  • Create a Pivot from that filtered content tab

 

Let me know if this helps,

Regards,

 

Userlevel 1

@vkumar  Thanks much for the advice. It is certainly helpful. :slight_smile:

However, still not quite what I was looking for. Is there any way to use the GI filters to dynamically filter the Pivot? To give a more concrete example:

I adjusted the Conditions on my GI slightly to provide defaults if the parameters are not provided:

 

Based on your advice, I created a Pivot Table as a filter:

 

The data loads fine if I do not supply the Trans Date From/To parameters (presumably since the the default dates are passed to the Condition):

 

 

However, if I fill in the Trans Date From/To parameters, I get nothing in the Pivot Table:

 

But the data loads just fine in the main GI tab:

 

My question is, is there anyway to use the parameters and conditions specified in the GI in the Pivot Table?

Using the example above, would it be possible to (a) require both the Trans Date To/From parameters (modifying the GI condition to load no data if they are not present), and (b) load filtered data in both the GI and Pivot Table when (and only when) these parameters are supplied?  I can get the GI to work just fine; it is the Pivot table that is problematic.

Thanks again.

 

 

 

Userlevel 7
Badge

Hi @KellyMarchewa were you ever able to figure this out? Thanks!

Userlevel 1

@Chris Hackett  no I was never able to figure this out with the GI + Pivot Table. I ended up settling for a different approach (a report created via the Report Designer).  Thanks!

Userlevel 7
Badge +7

Hi @KellyMarchewa  @Chris Hackett ,

I came across this post and wanted to share a solution that I found to pass parameters from a GI to a pivot table.  

First create a new dashboard and configure the parameters.  Then add the pivot table as a widget on the dashboard.  The dashboard parameters can be passed through on the widget filter settings, and will flow through to the pivot table when it is displayed on the dashboard.

Hope this helps you or others!

Laura

Userlevel 7
Badge

Thank you for sharing this with the community @lauraj46!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved