Dynamic Crosstab Qry & Unbound Report fields 1

[roccorocks]

I have created a dynamic crosstab qry that works great and does exactly what I expect of it. However, I am finding it impossible to set fields in the report at runtime. Has anyone done this? I was setting the record source at runtime as well, is this incorrect? Should I set the recordsource for the report and setup the parameters as usual? Any help would be appreciated.

 

[SoCalAccessPro]

Yeah, I've done it, it's been a while though.

Do you have Letwin & Getz Programming Access ? There's an example in there how to do it that's pretty slick.

To get the field names, use the DAO qdef and loop thru the field names. The first "X" fields will be static as these are your Row Headings.

I'll pull out my old programming access 2000 book when I get home and look it up for you.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[dhookom]

I don't like the querydef method since it is generally slow and inflexible. There is a more flexible solution in the Crosstab download at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
Hook'D on Access
MS Access MVP

 

[Remou]

As was mentioned in thread703-1487642, Duane's solution is simple and elegant.

 

[roccorocks]

Thanks for the help guys, I found another solution that I was using. I will check out yours Duane. Thanks also Tyrone, I found some help using the qryDefs too (did not go that route though).

Tim