Crystal Reports Combine Rows

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Combine Rows
	<< Prev Page of 2

Author	Message
KevV Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 106	Posted: 13 Jul 2011 at 10:09am
	I am not quite sure on the question. The orders are loaded in to trucks in reverse sequence of the way they are delivered. There is a field in the databse called "stop" with values of 5 10 20 30 and so on. Thanks KevV
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 13 Jul 2011 at 10:48am
	IF I understand you correctly, Go to the sort expert (The A - Z connected by arrows button). you should have a group 1 route number already in the sort fields box in the available fields select the "stop" field and move it to the sort and make it desc or asc based on your need. Does that do it? Edited by DBlank - 13 Jul 2011 at 10:50am
	IP Logged

KevV Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 106	Posted: 13 Jul 2011 at 11:09am
	I do have the route as a group and it is sorted by it. If i add the stop field it reruns the report and it goes blank like if a join is incorrect but it is in the same table as most of the other fields are in. Once it runs even if I take the sort out it still comes back as a blank report. Thanks KevV
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 13 Jul 2011 at 11:12am
	unsuppress your details and see if the data is still in the report just getting hidden in an unexpected way
	IP Logged

KevV Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 106	Posted: 13 Jul 2011 at 11:21am
	Nothing there. One thing that is strange is when I put the sort in it has data in the report footers but when I switch to the second page it as if I want to refresh data or use saved data and no matter which one I click it reurns the report and that is when all the data disappears. The only way to get the report to show anything again is to close the report and reopen it. Edited by KevV - 13 Jul 2011 at 11:22am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 13 Jul 2011 at 11:33am
	you have it set to save the data with the report. When you close it is is pulling in the saved data. Close it, open it so it appears fine, make no changes , hit F5 and OK to refresh the report. Does your data disappear? I think it will. Adding the new field does the same thing so my guess is somehow your source is lost.
	IP Logged

KevV Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 106	Posted: 13 Jul 2011 at 11:36am
	I dont have it set to save the data with report. When I open the report it just has the design tab and I have to run it to get the data but it does populate. Once I put the sort in and try to change to the next page it disappeaers.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 13 Jul 2011 at 11:46am
	Really weird....never heard of that one. so if you go back to page 1 it is all gone too, correct?
	IP Logged

KevV Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 106	Posted: 13 Jul 2011 at 11:46am
	yep
	IP Logged

KevV Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 106	Posted: 13 Jul 2011 at 12:04pm
	The thing I find the strangest is that when I put the sort in it drops a few of the routes but most of the data stays when it runs but if I try to go to another page in the report then I lose everything. If I unsuppress the detail section I can put the stop field in it and run the report and it runs fine and shows the stop and if I try to add it to the sort it dosen't do anything. Edited by KevV - 13 Jul 2011 at 12:08pm
	IP Logged

<< Prev Page of 2

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.