Solved

crystal report 9 filtering records with visual basic 6

Posted on 2004-08-08
5
352 Views
Last Modified: 2010-08-05
I have made a report in crystal report 9 and then I added that report in my visual basic application using the add crystal report from the project menu. My report also contains a sub report. Both the report and sub report return all the records from the tables or view they are connected. I want to filter both the report and sub report to give me the limited result e.g all record from a particular month. How will I do this please help. I am using visual basic 6 with service pack 6, crystal report 9 and sql server 2000
0
Comment
Question by:ShakeelAhmed
[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
5 Comments
 
LVL 2

Accepted Solution

by:
Parsi earned 168 total points
ID: 11749879
You shall set 'SQLQuery'.
For example:
cr1.SQLQuert = "Select * from Q Where Condition"
In which cr1 is your CrystalReport Object, and Q is the name of the query which your report is using, and ofcourse Condition is your Criteria.

Good Luck.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 166 total points
ID: 11757058
0
 
LVL 1

Assisted Solution

by:keijerjh
keijerjh earned 166 total points
ID: 11788009
Hi,

I've had the same problem.
You should create a parameterized query in your subreport.

Query:
SELECT * FROM ITEM WHERE ITEM_ID='{?ITEM_ID}'
Parameter:
ITEM_ID

Link the parameter ITEM_ID to a field in your main report.
This should do it.

Good luck.
Yelle...
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

726 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