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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal report Data sorting Error

Status
Not open for further replies.

melbenmartin

IS-IT--Management
Dec 16, 2009
13
IN
I am generating report Dynamically windows application .
When i generate Dataset the order of the Record in asc Datefield ...

but when i see in the report order is being changed. i dont know how to set the field correctly ..to sort the datafield in the report ...


 
Go to report->sort records. However, note that if you have inserted groups, groups have precedence over record sorts.

-LB
 
I have created a Report in Financial Application where in i have to create a report like

"LedgerName" as a Group under which i have to display Billdate , Credit(Money) and debit(Money) ...

While displaying the records,I have to display a total under credit and debit for each month ...

-:personalAccount:-
-----------------------------------------------
Billdate Credit Debit
-----------------------------------------------
01-03-2010 1000.00 0.00
02-03-2010 0.00 100.00
04-03-2010 2000.00 0.00
05-03-2010 0.00 1500.00
-----------------------------------------------
Monthly Total 3000.00 1600.00
-----------------------------------------------
01-04-2010 200.00 0.00
02-04-2010 300.00 200.00
-----------------------------------------------
monthly Total 500.00 200.00

I am able to create the recordset from the database ..without monthly total .. how can i create monthly total in Crystal Report ??. plz help me .. its very urgent .. thanks ..

Regards,
Martin Robert.
 
Insert a group #2 on your date field->print on change of Month. Then you can simply right click on your detail fields and insert totals at the month level.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top