Reporting textual answers

[#1]

Hi there,

I have the following problem:

One of our goals is to produce reports with textuals answers in it with QV.

The problem is, sometimes there are more answers in the listbox than there can viewed on one slide.

The result is that not all answers for  a specific questions are not shown on the report slide.

Making the font smaller does not help, the amount of text is still too much.

How could I overcome this?

Is there anyway I could Split up the contect of a listbox on two slides in the report?

And only if the the content of the listbox is too much to be shown in one slide?

I hope I'm making myself clear.

Anyone suggestions or solutions?

Kind regards,Tim Dries

[jvitantonio]

Hi, why don't you filter your answers? Add a number to each answer, then show the first X number of answers in the list box.

[#3]

Hi there,

Thanks for your response,

Could you elaborate more about automatically numbering the questions?

Is this possible without showing the actual number in front of the answer?

How would the script for show first x answers look like?

Thanks a lot!

Kind regards,

TimDries

[jvitantonio]

Check out the solution

[#5]

Could you paste the script?

I can not open the file!

Thank you very much,

Tim Dries

[Anonymous]

Hi

use this in inline

table1:

LOAD * INLINE [

SampleField

A1,

A2,

A3,

A4

A5

];

load SampleField, RowNo() as RowAnswerNum Resident table1;

Create a listbox and enter the this exprssion in your listbox expression edit module

=if(RowAnswerNum<=2,SampleField)

Regards

[jagan]

Hi,

Display values in the list box in multiple columns by using

Chart Properties -> Presentation -> "uncheck Single Column" and select "Fixed number of Columns" and give columns number

Hope this helps you.

Regards,

Jagan.

[jvitantonio]

On your script put this:

table1:

LOAD * INLINE [

Answer

Answer1,

Answer2,

Answer3,

Answer4

Answer5

];

load Answer, RowNo() as Num Resident table1;

---------------

Load the application. Then create a listbox. On your field, select "<Expression>" and put this:

=if(Num<=2,Answer)

This will show you only those ansers with row number <=2.

Now you can apply this to your model.

[#9]

Hello,

Thank you,

Would I need to use the * sign for loading the answers?

Because it is not possible giving in the answer manually..?

Thanks,

Tim

[jvitantonio]

of course

you first do

A:

LOAD AnswerField FROM yourAnswerTable;

B:

load AnswerField, RowNo() as Num Resident  A;

drop table A: