Search results for query: *

I have this query (below here) in Crystal Query, that runs fine. What tables should I put in my crystal report into the Visual Link to see this in a Crystal Report. This is because I want to call a subreport with some fields from this query. Thanks Carlos SELECT sum(TTDPUR041101."T$AMTA")...

Thanks for your help, it is appreciated. Carlos

I only want to check if the a vendor exists in VENDOR_RATE_OVERALL table. I know that the syntax isn't perfect now... but again, my question is this, [COLOR=red]IS IT POSSIBLE TO WRITE A SUBQUERY IN THE SQL EXPRESSION EDITOR YES OR NO? [/color red] Thanks again. Carlos

Hi again... The questions is if I can add a subquery in a SQL Expression Editor, to obtain a %mysqlexpression. Where %mysqlexpression is SELECT * FROM VENDOR_RATE_OVERALL WHERE VENDOR = '79148'. I want my SQL query show me something like this: SELECT AM_RECORD."AUDIT_STATUS"...

I have Crystal 8.5. I am trying to add a subquery in a SQL Expression, can I? This is what I've typed in my SQL Expression Editor. SELECT * FROM VENDOR_RATE_OVERALL VENDOR_RATE_OVERALL WHERE VENDOR = '79148' But I get syntax error right after the "FROM". Carlos

Hello everyone, I want to print the parameters fields values of my report selection criteria, at the top of my report. my parameter field (?item) is a string with range of values, not allow multiple values. This field does not print on my header even if I put it there. Is there a reason why...

Hello everyone, I am using CE 8.5 with viewer DHTML and tried the activeX and all others that come with CE 8.5. Is there an easy way to modify the User Interface to customize just the layout for the enter paramenters in the viewer? In the DHTML, the user has to scroll down several times to...

I am using CE 8.5 with viewer DHTML and tried the activeX and all others that come with CE 8.5. Is there an easy way to modify the User Interface to customize just the layout for the enter paramenters in the viewer? In the DHTML, the user has to scroll down several times to enter all parameters...