I made a simple report in CR 10.
I want to display one field independent of the mail query.
So how can i write a sql to render the field.
And one more point where can i write this sql query.
help me guys.
its urgent.
bye
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
If I understand the question correctly you want to actually get the report to run 2 select statements ? The first statement is the report datasource and you want to retrieve an unrelated field using the 2nd SQL statement.
If I am correct the easiest way to accomplish this is to insert a subreport and use this to return the unrelated data.
Gary
Agree woth Gary
Multiple data sources in Crystal
http://support.businessobj
Subreports in Crystal
http://support.businessobj
Sgaring data between a subreport and the main report
http://support.businessobj
mlmcc
You can also write the SQL statement in a SQL Expression, as long as it returns only one value, and avoid the Subreport.
Create a new SQL Expression from the field explorer.
Add your SQL statement in the editor, and enclose the whole statment in parenthesis.
Save and Close.
Add the SQL Expression field ot the report.
Run the report.
This can be a bit faster, and easier than using a subreport since the value will be returned with the original reports recordset.
With a subreport, you will have to deal with shared variables in if you need the value for any calculations.
Business Accounts
Answer for Membership
by: bdreed35Posted on 2005-01-28 at 05:32:20ID: 13162825
Can you write SQL yourself or are you looking for guidance on how to write it?
If you know how to write SQL and you are looking for information on where you can use it in your report then I can tell you about the SQL Command functionality.
Under the Database menu, select the Database Expert.
Establish a connection to your datasource.
Under that connection, the first option should be "Add Command".
Double Click it to add it and open the Command dialog box.
In the Command dialog box, you can paste SQL statements to use as the basis of you report. Once you click OK, Crystal will check that the SQL will be accepted by your db.
If it is valid, you are all set, if not, you will need to correct any problems. The errors aren't very good so I would test the SQL using a database specific SQL tool.
If you need to go back and edit the SQL later, just go back into the Database Expert, and right click the right side where it says Command, and choose Edit Command.