1. 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? 

Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 16 January 2020 22:48 PM UTC
  2. InfoMaker
  3. # 1

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.
Michael Kramer Accepted Answer Pending Moderation
  1. Thursday, 16 January 2020 22:51 PM UTC
  2. InfoMaker
  3. # 2

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
  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.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 January 2020 15:36 PM UTC
  2. InfoMaker
  3. # 3

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.
Neil Prichard Accepted Answer Pending Moderation
  1. Thursday, 23 April 2020 16:31 PM UTC
  2. InfoMaker
  3. # 4

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
  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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.