robreports
Technical User
LBass, that sample code in your reply would be created under "SQL Expression Field" or "Formula Field" in Crystal?
All I have ever done is create formulas and then drag them into report where I wanted them. If I create one long,complex SQL query string and then give it a name and save it.....how do I format my report?Just drag the SQL expression formula anywhere into report and let go of mouse?I will need to experiment with this but I do understand the SQL statement logic.Sounds like it should work but I have formatting concerns. Can I add a second,duplicate "SELECT" SQL statement using "and" for the second table parameter?(this report will compare two tables).Thanks again Lbass.
All I have ever done is create formulas and then drag them into report where I wanted them. If I create one long,complex SQL query string and then give it a name and save it.....how do I format my report?Just drag the SQL expression formula anywhere into report and let go of mouse?I will need to experiment with this but I do understand the SQL statement logic.Sounds like it should work but I have formatting concerns. Can I add a second,duplicate "SELECT" SQL statement using "and" for the second table parameter?(this report will compare two tables).Thanks again Lbass.