Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Adjust Crosstab's Stored Procedure

  1. How-to
0
Votes
Undo
  1. Cliff Bailey
    Cliff Bailey
  2. InfoMaker
  3. Monday, 24 October 2022 15:25 PM UTC

I'm trying to update an old Crosstab report. Specifically I'm trying to alter the stored procedure that the Crosstab uses. I need to add an argument to it but can't find any way to edit the source. Am I missing something or is it impossible? 

Thanks!

Crosstab datawindow not wrapping onto second horiz...
Barcode Issue on Form
Responses (2)
Cliff Bailey
Cliff Bailey Accepted Answer Pending Moderation
  1. Tuesday, 25 October 2022 14:24 PM UTC
  2. InfoMaker
  3. # 1

In our case I believe the DW is built into a 3rd party application and I won't have access to adjusting the code. Looks like I'll need to replicate the crosstab.

Thanks for your help, John. 

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Monday, 24 October 2022 16:27 PM UTC
  2. InfoMaker
  3. # 2

Hi, Cliff -

The normal way to access a stored procedure data source in a DataWindow is not available in a Crosstab. If you do not want to recreate the Crosstab, you can attempt to (carefully) edit the DW source and add the new argument's definition in the "arguments=(...)" clause (it should be just before the text, column, compute, etc. DWObject definitions). This limitation is due to the unique processing performed in a Crosstab-style DW.

If you edit the DW source manually, I strongly suggest you make a copy of the DW and experiment on the copy.

Good luck and best regards, John

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.