Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How To pass SQL query to Crystal report?

Status
Not open for further replies.
makjoshi

makjoshi

Programmer
Joined
May 30, 2001
Messages
27
Location
JP
How to pass SQL query with where and groupby clause ?
I'm trying to pass SQL query to report through
Report1.SQLQuery property.
Report1.SelectionFormula property is not flexible enough
So How can overcome this problem of showing desired records
in the Report.

Also give me the tips of passing two dates and fetching records between that dates.

 
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
428
DjangMan
DjangMan
K
  • Locked
  • Question Question
We're using command in crystal report
Replies
1
Views
779
hilfy
hilfy
Kennymc
  • Locked
  • Question Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
345
Kennymc
Kennymc
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy
D
  • Locked
  • Question Question
Crystal Reports for Visual Studio 2022 Download
Replies
2
Views
9K
Joshua44
J

Part and Inventory Search

Sponsor

Back
Top