1. Arthur Ireland
  2. InfoMaker
  3. Monday, 10 June 2019 20:06 PM UTC

I have created a basic report that will return data.  In the select statement I have listed the columns as Aliases.

When I go to the design the columns do not auto populate as they do in the video.  Is this a setting issue or a know issue?

Thanks for any info you can provide.

 

Michael Kramer Accepted Answer Pending Moderation
  1. Tuesday, 11 June 2019 19:44 PM UTC
  2. InfoMaker
  3. # 1

Hi Arthur,

Do you see your columns show up in the control list (the lower right-hand panel in #2 reply fro Chris?

If so, they are actually created - but - they are located way out to the right in design mode. Every now and then some DB driver will tell PB's DB interface that an expression or a column is way wider than expected. When THAT happens you get a layout that appears almost without content - but scrolling to the right - or click on each control in the control list - will display each column, even the computed.

Sometimes, the issue is that column has width = 0 (hiding in plain sight). Again, the actual control to display the column will be part of the control list.

HTH /Michael

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 10 June 2019 20:49 PM UTC
  2. InfoMaker
  3. # 2

Hi Arthur;

   FWIW:  No issues for me on this quick IM2017R3 test ....

SQL:

Design:

HTH

Regards ... Chris

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 10 June 2019 20:38 PM UTC
  2. InfoMaker
  3. # 3

Hi Arthur;

  Can you tell us ...

1) What DBMS & version are you using?

2) How is IM connecting to the DBMS?

3) What version & build of IM are you using?

4) What MS-Windows O/S version are you using with IM?

5) Is this SQL being used in the development of a FORM or a REPORT?

Regards ... Chris

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.