Filterrelated crosstab

[Anna]

I'm in desperate need for help!

I have a form where a user can make several different choices before opening up a report. I want to use the chosen criterias as a filter when opening up the report. When the report is based on a regular query the filter function works perfectly, however when I try to use the filter function with a report based on a crosstab query it doesn't work. I get errormessage 3070, "Can't identify <name> as valid fieldname or expression i Microsoft Jet".

Thanks in advance!
/Anna

 

[Richie]

Have you defined the criteria parameters?

 

[Anna]

I'm having a hard time explaining this, but here goes....

I've tried to set the reports filter both to "AktNr = 12345" and "tblFakturaRad.AktNr = 12345" but it doesn't work. I've also tried to define "AktNr" and "tblFakturaRad.AktNr" as parameters, but then I got dialogboxes asking for their values, even though they where stated as Filter.

To put it another way, how do you get the filter to work with a crosstab query?

The SQL-statement for the crosstab query:
TRANSFORM Sum(tblFakturaRad.KrPerSt) AS [Summa KrPerSt]
SELECT tblFakturaRad.Avdnr, tblFakturaRad.Omradesnr, Sum(tblFakturaRad.KrPerSt) AS [Summa Totalt]
FROM tblAvdelning INNER JOIN (tblOmrade INNER JOIN tblFakturaRad ON tblOmrade.Omradesnr = tblFakturaRad.Omradesnr) ON tblAvdelning.Avdnr = tblFakturaRad.Avdnr
WHERE (((tblFakturaRad.Aktnr) Is Not Null) AND ((tblFakturaRad.FastKostnad) Is Not Null))
GROUP BY tblFakturaRad.Avdnr, tblFakturaRad.Omradesnr
ORDER BY tblFakturaRad.Avdnr, tblFakturaRad.Omradesnr, Right$([Manadsnr],2)
PIVOT Right$([Manadsnr],2) In ("01","02","03","04","05","06","07","08","09","10","11","12","13");

Thanks for all help!
/Anna