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!

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

Crystal Reports 9 Grouping through code.

Status
Not open for further replies.

dstrange

Programmer
Nov 15, 2006
87
CA
I have been able to come to the point where I can print directly via code, the Report Header, Page Header , details, but cannot do the grouping. Does anyone have any code samples or ideas? Can we do sort within code right here, without having to resort to Data environment,
or other means. Thanks...
 
I hane never used crytal reports. I hope help you.
What kind of sort you want? If you mean sort data of a table, you can do this with a sql query.
for example
dim rs as adodb.recordset
dim sql as string
sql="select * from table order by field asc/desc"
rs.cursorlocation=aduseclient
set rs = new adodb.recordset
rs.open sql,adopenstatic,adlockoptimistic
print the report via code
Personally, in my application i used data reports without using data enviroment. I used ado shape statement. i don't know if this helps you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top