Odd function behaviour in Visual Query Builder

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

Odd function behaviour in Visual Query Builder

Author

Message

kpa

Posts: 31

Posted: 10/16/2010, 9:39 PM

Not sure if this is a CCS bug or something I may or may not be doing so appreciate some advice please.

Selected a table in VQB (from a MSSQL database) and selected the fileds I want and then joined a related table and selected a field in that table. I've then right clicked on that field and added a COUNT function using "Add function to select". This all looks good. What I'm trying to do is have each row in a grid of Clinics show the number of Practitioners in that Clinic in that row.

When I return to the grid and select a field in that grid (in CCS) the Control Source now shows all fields in all tables I've selected, not just the fields I've selected. And my COUNT field is not in the lookup.

Any clues please!
_________________
++++++
kpa
++++++

CodeChargeMVP

Posts: 473

Posted: 10/21/2010, 2:25 PM

i don´t know really if i´ve understand what you want to do,

I think count is not the right solution,

i think you should use group by the field

than you want to group, then

you´ll get the expected result.

Quote kpa:
Not sure if this is a CCS bug or something I may or may not be doing so appreciate some advice please.

Selected a table in VQB (from a MSSQL database) and selected the fileds I want and then joined a related table and selected a field in that table. I've then right clicked on that field and added a COUNT function using "Add function to select". This all looks good. What I'm trying to do is have each row in a grid of Clinics show the number of Practitioners in that Clinic in that row.

When I return to the grid and select a field in that grid (in CCS) the Control Source now shows all fields in all tables I've selected, not just the fields I've selected. And my COUNT field is not in the lookup.

Any clues please!

_________________
Best Regards
Entrepeneur | NT Consultant

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home | Search | Members | Register | Login