I am trying to write a report that uses a standard baan session for its selection criteria.

How does this criteria get passed to the sql that I want to use?
Or is there a way to import the settings into a range?

I want to select records based on date criteria.

We do not have developer licenses so I cannot see what the session is doing.

All of the session's form variables are external variables, so they are available to you in the report. However, the session is going to send the report records of data based on the form criteria and the processing within the session's program script. You can use this within your report. However, it kind of sounds like you want to do your own SQL query within the report. In this case, I guess you would have to ignore all the records of data from the report except for the criteria you desire.

This seems like a lot of effort to create report data, but maybe that's the way it is when you don't have the developers license.

Hello,

I've managed to this on a couple of standard reports (receipt log and shipping log) without having a developers license.

Follow the following steps;

1. Add fields to form using the free$ variable. Check out the programmers help for info on free$.

2. Create the report script to read the contents of this variable and then in the report script exclude detail records based on the values read from free$.

You really do need to reasonably confident with report scripts to achieve this but it's definately worth the effort as a some of the standard reports do not have the desired ranges.

If I get time and you're interested I'll try to put some more info together with screen dumps unless somebody else already has some.

Good luck
Neal Matthews
Intier Automotive - IT Support Analyst

Thanks for that i shall give it a go