This topic is locked

Charts Problem

7/30/2009 6:57:47 AM
ASPRunnerPro General questions
P
power0n author

Hello,
I started using ASPRunner some weeks ago, and everything went smoothly and very intuitive, all the doubts that i had were dispelled just by searching this forum and google.
Im going to try to explain where i just stucked, i tried to look everywhere and no answers, im not an expert in this subject, so prolly it would be solved very easily.
Basically im stuck on charts, we only can put, obviously, in data series the ID's or the primary and foreign keys, and just 1 for the label thing.

The problem is that i want instead of appearing the ID number of certain object, i want that it appears with the name and not the idcod.
For Example:



Where it appears 1 and 2 (idcods for the hotels) and would like that it appeared as the name (Hilton and Ipanema)
BTW im building a simple hotel system.
Tnks in Advanced <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=12431&image=3&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />

J
Jane 7/30/2009

Hi,
you can edit SQL query and join your tables on the Edit SQL query tab. Then use joined field with hotel name as label field on the Chart parameters tab.

P
power0n author 8/4/2009

Tnks, it helped