mentecky
Posts: 321
|
| Posted: 07/17/2008, 4:48 PM |
|
I just joined the CCS 4.0 club and I'm getting around it pretty well. Got some AJAX stuff going on that is really cool and saves me a bunch of hand coding... so right there the $199 upgrade was worth it if it saved me a couple hours... BUT...
I cannot build a query in the Query Builder using PHP/MySQL to save my life. It builds fine but any fields with an alias won't show in any drop-downs. I have to manually enter the alias names.
This may not seem much of an issue, but when you are building a report with 18 aliased columns and they don't show in the builder... creating 18 columns manually is a bit much.
Anyone else see this behavior?
Rick
_________________
http://www.ccselite.com |
 |
 |
wkempees
Posts: 1679
|
| Posted: 07/18/2008, 2:04 AM |
|
Rick,
To get/set your problem in the right perspective:
You use report builder to create repoort.
Then in Design you open up Datasource and change the query (for instance add a join)
The original SELECT fields could then become ambiguous and need an alias so you add
an alias in the right lower pane (SELECT)
It is those aliasses that do not show up in the dropdowns?
Is your VQB in TABLE or SQL mode?
[tested:]
Using Builder on Internet Example Database.
Report on store_product, straight build (all Next on builder steps).
Opened DataSource, joined store_products to store_categories.
Explicitly selected the category_id from both tables to force alias creation, also added my own alias 'prijs' to 'price' field.
Pressed OK on the VQB.
Back in Report selected report field price-> dropdown shows
'prijs', 'store_categories.category_id', 'store_products.category_id'
Which indicates that CCS4 (mine 4.01.00.06) works ok with aliasses.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Stanj
Posts: 166
|
| Posted: 07/18/2008, 2:54 AM |
|
It is hard to say whether your wife's bashing you over the head too many time, or even if not enough times is at fault but I suspect her hobby has little to do with the alias problem.
This is fresh on my mind because not more than 2 minutes ago I created aliass in VQB and all worked perfectly...unless I can't tell due to my GF having bashed my head one too many times, and I just THINK it works;>). Actually she is very sweet and beautiful and would never do that.[disclaimer in case she reads this forum]
Walter is right, as usual.
_________________
Stan
St Petersburg Russia |
|
|
|
wkempees
Posts: 1679
|
| Posted: 07/18/2008, 2:57 AM |
|
Stan,
I just had my head bashed by his wife, and aliasses still work.
(Scotty beamed me up and back)
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
mentecky
Posts: 321
|
| Posted: 07/18/2008, 10:40 AM |
|
Thanks all. I think it was a case of "operator error".
I just tried to reproduce it and I found that if you use any aggregate functions and mess your GROUP BY up, apparently CCS ignores the alias fields and shows just the selected fields in the table. It works fine if your GROUP BY is correct.
It's hard to say exactly if this is what happened because I fixed it already, but I have a couple of similar reports to complete so I'll keep an eye on it.
BTW: My wife saw the title of this thread and hit me in the head.
Rick
_________________
http://www.ccselite.com |
|
|
|
|
