Sorted by page and calculated text

[Russian_Laszy]

Hey guys I have a report layout that sorts my records by company and a search layout with global fields for users to enter a date range for the report.

 

I was wondering if anyone had any ideas about how I could make a pop-up menu with each company and depending on which company the user selects, only that company is shown in the report (I also want it to be possible for the user to shift click multiple companies).

 

Also I want each company in the report to start on a new page and to have the company's name and date range in the header so it would read something like:

 

Sasazat Contracting [1/10/07 to 30/10/07]

 

for example.

 

Thanks.

[HBMarlowe]

how I could make a pop-up menu with each company and depending on which company the user selects, only that company is shown in the report (I also want it to be possible for the user to shift click multiple companies).

 

Add a global field, called gCompany to your search layout. Display it as a pop-up. Assign it to a value list with the CompanyName field as the source. In Find mode, in addition to setting the date range, do something like this:

 

Loop

Exit Loop If gCompany is empty

Set Field CompanyName to RightValues ( gCompany ; 1 )

Set Field gCompany to LeftValues ( gCompany ; ValueCount ( gCompany) -1)

New Record/Request

End Loop

Perform Find

 

I hope that helps. It's much easier to show you in a demo file, but since you're not yet a member you would not be able to download the demo.

[Russian_Laszy]

Hey thanks I'll try it now. Don't go anywhere because sometimes I try and it doesn't work and the thread has been forgotten. Anyway sorry for talking, if I don't say anything after this it means it worked.

[Russian_Laszy]

Hey when I'm in ScriptMaker and I select CompanySearch (or gCompany as you call it) from the fields on the left of the calculation window, I get a funny message saying "The specified field cannot be found".

 

Also instead of putting it in as simply CompanySearch Filemaker puts it in as Reedy Creek::CompanySearch.

 

Why would it do this? I believe I am in the right table and it happens when I use the other table as well.

 

Please help!

[HBMarlowe]

instead of putting it in as simply CompanySearch Filemaker puts it in as Reedy Creek::CompanySearch.

 

Why would it do this? I believe I am in the right table and it happens when I use the other table as well.

 

That's normal and correct. To the left of "::" is the table occurrence, to the right is the field name.

[Russian_Laszy]

Yes... thanks I guess. I think I should explain the problem that I am having now because I didn't explain it properly last time.

 

Reedy Creek::Company Search is empty

 

is what I have entered into the Calculation Field for the Exit Loop If statement. The error I get when I try and click Ok is:

 

The specified field cannot be found.

 

Why would it say this? Can you help?

 

Thanks

[Russian_Laszy]

I've tried changing the code to

 

Exit Loop If [isEmpty(Reedy Creek::Company Search)]

 

It allows me to actually put it in but it still doesn't work though. Cheers.

[Russian_Laszy]

Ok I fixed the problem no worries thanks.