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

Resolved Crosstab Datasource access

  1. How-to
0
Votes
Undo
  1. Neil Prichard
    Neil Prichard
  2. InfoMaker
  3. Thursday, 16 January 2020 19:06 PM UTC

I am having an issue where I cannot seem to access the datasource of my crosstab after i initially create the crosstab. This appears to be a new issue unless i am missing some combination of settings as i was able to re-enter the data source after saving previously. 

Has any one else had this issue? 

Cross-tab Repeat Row Value onto additional Horizon...
Forgot password
Responses (4)
Neil Prichard
Neil Prichard Accepted Answer Pending Moderation
  1. Thursday, 23 April 2020 16:31 PM UTC
  2. InfoMaker
  3. # 1

I basically had to keep creating cross tabs until i found some combination that would allow me to edit the data-source in infomaker. Crosstabs are definately finicky !

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 4 May 2020 19:56 PM UTC
Thanks for sharing the solution!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 January 2020 15:36 PM UTC
  2. InfoMaker
  3. # 2

Hi Neil;

  I have been working with InfoMaker since v1.0 and never had this issue with a CrossTab report. Have you tried resetting your IM layout?

BTW: What version of IM are you using?

Regards ... Chris

Comment
There are no comments made yet.
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Thursday, 16 January 2020 22:51 PM UTC
  2. InfoMaker
  3. # 3

Do you mean you cannot get to the built-in SQL Painter to edit the SELECT for your Crosstab DW?

That is certainly a surprise! What DBMS are you using? I could try to repro on my laptop if I have same DBMS. (my databases are MS SQL 2019, SQLAny 16 + 17, and PostgreSQL 12)

/Michael

Comment
Olan Knight
  1. Olan Knight
  2. Monday, 4 May 2020 19:47 PM UTC
Yes, Micahel, that 'si exactly what I mean. I can open up the database painter for my CT DW, but I cannot change anything from there. I >>> MUST <<< use the Edit Source option in order to make changes.

PBv12.1, b7055.

  1. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 16 January 2020 22:48 PM UTC
  2. InfoMaker
  3. # 4

Crosstab datawindows are finicky. There have been times when the only way I could access a crosstab dw is to use EDIT SOURCE.

Using EDIT SOURCE is the only way to modify the structure ot the SQL of a crosstab dwo after it has been saved, as far as I am aware (up through PBv12.x).

That's not very helpful, I know. Sorry.

 

Olan

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.