Crosstab Help (1 Viewer)

[Acropolis]

Hi All,

I have created a cross tab to show the various stages of a project, and if they have been completed or not.

The stages can vary from project to project, so can't use anything fixed.

I have the cross tab showing the stages in the correct order, no problem. But what i am struggling with is getting to to show only the stages for the project that is been viewed at the time.

When the project form is opened, the ProjectID is set in a tmepvar (tmpProjectID), but it appear I can't use this to filter the cross tab results.

The cross tab is running form a query, and it doesn't work when i put the tempura in there either.

Any idea's, as without been able to filter the results, it is completely useless to me.

Help

Thanks

 

[pbaldy]

You haven't said what the error or problem is, but be aware that for crosstab queries the parameters have to be declared:

http://allenbrowne.com/ser-67.html

 

[Acropolis]

When I have the temp var listed anywhere, i get an error saying it isn't recognised.

 

[pbaldy]

Sounds like the error you'll get if the parameter isn't declared. I haven't used TempVars, but have used forms to filter crosstabs many times.

 

[Acropolis]

Sorted it, added [TempVars]![tmpProjectID] as a parameter and it now works fine.

 

[pbaldy]

Glad you sorted it.

 

[Acropolis]

Fixed that, but found another problem now of how to display the results in a form.