Where are the rest of the available fields when creating a chart on a report

**MFS** · 10-10-2013, 12:55 PM

Hello,
My issue . . .
I am creating a report with a line graph. When the chart wizard opens and I choose the query for the chart only one item in the available fields is available to choose from????? There are 5 items total in the query, and I only need two for the graph. I thought it had something to do with my SQL database and 4 out of the 5 fields were string files. So I rewrote the SQL table and made the second field needed as an integer, the same as the other that does show up in available fields however it still is not there.

Yep, I'm confused!!! Hopefully you can help.

**MFS** · 10-10-2013, 12:58 PM

Sorry all, Just figured it out.
I recreated the "Linked Table" from my ODBC database.

Where are the rest of the available fields when creating a chart on a report

Thread Tools

Where are the rest of the available fields when creating a chart on a report

Similar Threads

Creating a report using the same fields

Creating a Report and the rpt fields are based on key relationships.

Creating Dummy Fields in a Report

Creating Report using Text boxes & db fields

Creating a chart

Posting Permissions