Normal Topic [SOLVED] View range in a report. (Read 1060 times)
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
[SOLVED] View range in a report.
Sep 10th, 2007 at 12:23am
Print Post Print Post  
Solution: Attach a Retrieve Spec to Reports to specify a particular group of records.

Hi all I have a LE with dates in it called DATE COMPLETED i want to be able to make a report that will only do sort on that LE i have ben trying for the past 3 weeks help please anyone


"Sorry for the vagueness as I have a hugh head cold"
« Last Edit: Sep 11th, 2007 at 9:05pm by Hammer »  
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: View range in a report.
Reply #1 - Sep 10th, 2007 at 5:34am
Print Post Print Post  
Create and Save the Sort Spec in Preview Mode.
Save Name as "DateCompleted, Desc." or whatever is correct for you.
Now go back to Report Designer and assign that stored Sort Spec to the report.

In the Commands at the top click on "Attach Specs"
In Spec Type, select "Sort Spec"
In Attach Spec, select "Select a Different Spec"
In Select A Spec, select the Sort Spec that you saved earlier, "DateCompleted, Desc."
Click on Attach button, Close Window.
Save Report design.

Note:  Once a Spec is attached to a report, the user cannot change the sort at run time.  If you have sorted the result set by customer for example, and run the report, it will be sorted by DateCompleted not by Customers.
You may want to consider not attaching a spec, but making some type of Sort Picklist to choose from at run time.  That way, one report can serve many functions, vs. having a special report for every sort criteria.

Hmmm, did I just hear a sneeze?  God Bless You!. Roll Eyes
Take care of your headcold.


.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Re: View range in a report.
Reply #2 - Sep 10th, 2007 at 7:00am
Print Post Print Post  
Trying now I am sure that it is right
  
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: View range in a report.
Reply #3 - Sep 10th, 2007 at 2:17pm
Print Post Print Post  
Reminder, when you reconcile, you will probably want the Saved Specs to replace the ones in the normal Database.  If not, you will want to reconcile to get the report design done, then open the normal database and save the Sort Spec under the same name as used in the Preview Mode. 

Only you can determine whether or not to replace the Saved Specs. 
Just wanted to remind you of the issue.

================
Edited.  As noted below by Erika, these steps do not need to happen.  My reminder here was not actually needed.  Sorry about that.
« Last Edit: Sep 10th, 2007 at 6:14pm by Bob_Hansen »  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: View range in a report.
Reply #4 - Sep 10th, 2007 at 2:24pm
Print Post Print Post  
When you attach a spec to a report, the spec is copied to the report. You do not need to keep or reconcile the original spec unless you also need it for something else.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: View range in a report.
Reply #5 - Sep 10th, 2007 at 5:56pm
Print Post Print Post  
AHA!....I never realized that.  Shocked

That will save me many steps, wish I realized that earlier.  Cool

Thanks Erika!
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Re: View range in a report.
Reply #6 - Sep 11th, 2007 at 8:09pm
Print Post Print Post  
Thanks all, after I attached the retrieve specs to the reports it worked.
  
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: [Solved]View range in a report.
Reply #7 - Sep 11th, 2007 at 8:53pm
Print Post Print Post  
Quote:
When you attach a spec to a report, the spec is copied to the report. You do not need to keep or reconcile the original spec unless you also need it for something else.

Hokey smokes, I never knew that.  I have some cleaning up to do.  Smiley
  

**
Captain Infinity
Back to top
IP Logged