Skip to main content
Participating Frequently
November 29, 2010
Question

CFCHART and CF Report Builder

  • November 29, 2010
  • 1 reply
  • 366 views

This question has 2 parts

First is cfchart

  I need to chart teh answer to questions

  So I will have 3 questions with 3 answers.  One table has the question Text, and another table shows the questionID and selcted value (poor(1), avg(2), good(3))

so in the answer table

ID,     questionID,    questionValue

1            2                    2

2            2                    3

3            1                    1

4            1                    2

and so forth

the question table

ID                       question

1                        The teacher was?

2                        The movie was?

and so forth

how can I chart this from a query???

Then how can I put this into a cf report?  I all ready have a report and want to add this to the top.  So I all ready have a query going to the report.

Thanks for the help,

Darrin

    This topic has been closed for replies.

    1 reply

    sabot1Author
    Participating Frequently
    November 29, 2010

    one more question, I need to loop but show one report.

    So I have a class that has N number of blocks, I need to do the above for each block, but want one file output.  Can I even do that?