[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Crystal Reports Query

Posted on 2009-04-10
4
Medium Priority
?
245 Views
Last Modified: 2012-05-06
I have a report I have made with crystal reports. I have hooked it up to MSSQL server. I did that by right clicking in field explorer "Database Fields" and then on "Database Expert" problem is that does not allow me to change the query to what I need. Right now its select all records in the database I need to throw a WHERE clause in there. How can this be done?

This is being loaded by a vb.net program.
0
Comment
Question by:scprogs
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:RPCIT
ID: 24117923
I think what your looking for would be found in Reports / Edit Selection Formula / Record.

Might be different depending on your version.  You use this section to filter your results.
0
 

Author Comment

by:scprogs
ID: 24118115
Only thing im finding is this
Crystal Reports -> Report -> Selection Formula -> Record

WHen I go in there I copy the query into a box in there and says thers a error when its the query that it uses currently to get data.

Does this sound like im in the right spot?
0
 
LVL 6

Accepted Solution

by:
RPCIT earned 2000 total points
ID: 24118322
Sounds like the right place..   What your looking to put in here is not really a full query, but rather the a type of WHERE Clause.  

use the builder to put in something like

{AR.NamedInsured} = 'Named Insured'
0
 

Author Closing Comment

by:scprogs
ID: 31568999
Thank you
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question