Hello,
I would like a bit of advice regarding Crystal Reports/CE/CR Server.
I have developed a PHP web application that allows users to upload information to a MySQL database. From here I have developed a number of PHP pages that act as reports of the data that has been uploaded.
However, I...
Hello,
I am developing a website based on:
DreamweaverMX/MySQL/PHP
I have a section on the website where customers can check our ‘availability’ (i.e when we are free to visit them). However, at the minute it is basically a simple form that allows them to send me a message to the MySQL...
Using Crystal 9 and Oracle 9i.
In a table called MEETING there is a field called DATE (meeting.date) which is populated as follows:
01/01/2004
03/01/2004
05/01/2004
07/01/2004
09/01/2004
11/01/2004
13/01/2004
15/01/2004
And another table called APPOINTMENT links to the MEETING table. This...
Thanks for the reply...
Unfortunately this didn't work. I input the formula u you suggested and it came back with no errors, as expected. However, when we went back into the select expert formula it had returned to its original state with the line:
{GOV_LINK.END_DATE} in {?End Date} to {?To...
I am using Crystal 8.5 to run reports from the educational database, EMS.
We have a report that uses the formula below in the Select Expert:
{GOV_LINK.END_DATE} in {?End Date} to {?To end date} and
if {?Select a Governor Type:} = "All" then {GOV_LINK.GOV_TYPE} in ["STF", "SPO", "REP", "PAR"...
Thank you all for the help. Its good to have help on hand!!
From the advice by using alias we have found a solution to our problem.
Keep an eye out - I will no doubt post other queries in the future.
Tom
The tables we are using are as follows:
Contact Log
Clog_entity_link
People_Lookup
Contact Log links to Clog_entity_link which in turn links to People_Lookup.
We would like to know the crystal syntax for the "where" clause or perhaps somebody knows a better way of structuring the formula. We...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.