Solved

Crystal Reports Query

Posted on 2009-04-10
4
239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

710 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