I have a problem client and have the following question.

Can I use a command button and list box to to populate the retrive specs on a report.

This would save me making multiple reports to deal with his different needs.

Application is trucking company, with multiple divisons, and multiple terminals.

Example of required spec for say a list of drivers would be,

Pick Drivers list report, choose division, choose terminal.

Any help would be greatly appreciated.

I've also seen people take a route where they put a button on their form. When the user clicks, a list of reports is offered. When a report is selected, a list of retrieves is offered.  When a Retreive is selected, the records are retreived and the report is run.

Look into the following commands:
@SelectTreeItem
@LoadRetreiveSpec

Derek,

If you have that many combinations, you don't want to do it with a pile of saved retrieve specs. You can use the On Retrieve Spec Open event to fill out the Retrieve Spec with whatever the user picks. I'll ask Ray to post an example for you.

Hello Derek,

Below is code that will get attached to a command button. When clicked on the retrieve spec it will display two lists, one for Divisions and one for Terminals. After both choices are made, the records are retrieved and the report is run.

Var vDivision as String
Var vTerminal as String
Var vSuccess as Int

If @Mode() = 2 Then
{
	//Code will only work in Search Mode

	//Bring up two menus for the user to choose the division and terminal
	vDivision = @PopupMenu("Division A;Division B;Division C;Division D", "Please Choose a Division")
	vTerminal = @PopupMenu("Terminal 1;Terminal 2;Terminal 3;Terminal 4;Terminal 5", "Please Choose as Terminal")

	If ((vDivision <> "") And (vTerminal <> "")) Then
	{
		//If a choice was made from both menus. You can change this.

		DivisionElement = vDivision
		TerminalElement = vTerminal

		//Retrieve the results
		vSuccess = @SelectTreeItem("Search Menu!Search Commands!Retrieve New Results (F10)")
		If Not @Mode() = 2
		{
			//If records were found that matched the retrieve spec

			//Run Drivers List Report
			vSuccess = @SelectTreeItem("Search Update Menu!Results Commands!Reports!Database Name!Drivers List (Preview)")
		}
	}
} 

Say Hello to Peter for me.

-Ray

Ray,

Sorry but having one issue.

If I include the statement   Terminated = "=" to  meaning Terminated is not blank to exlude the terminated drivers from my retrieve specs in the programing, it translates that statement  into 0000/00/00

Terminated field is a date field.

In a sample database, if I include the terminated = "=" on the attched retrieve on the report it works, but in this client's database it dosn't.

Pulling what little hair I have left out!

Thanks again, you sample code worked wonders but this addition by me is frustrating.

Derek

thank you thank you