sub report and non-fixed column cross tab quesry

[iccsi]

I got you can't use a pass through query or a non-fixed-column query
as a record source for a subform or subreport message.

Actually, I had a subreport using non-fixed-column crosstab query was
working.
I got above message when I have the second one on the main report.

Does subreport support non-fixed column crosstab report?
If not, are there any work around?

Your information is great appreciated,

 

[Duane Hookom]

Either fix the column names or use a solution like the Crosstab download
sample at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[iccsi]

Either fix the column names or use a solution like the Crosstab download
sample athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

Thanks for the message,

I assign the crosstab query SQL and columns at report open event.
I have 2 crosstab subreport on the main report. The first one works,
but I got message on second one.

Should it consider non-fixed-columns subreport when I assign SQL and
columns on report open event?

Your information is great appreciated,

 

[Duane Hookom]

I'm not sure what method you are using. I have suggested a solution that
works best for me. If you are assigning control sources based on the fields
in a recordset, then I can't help since I hate that code. It's to inflexible
and inefficient.

Do your column headings involve time/date intervals?

 

[iccsi]

I'm not sure what method you are using. I have suggested a solution that
works best for me. If you are assigning control sources based on the fields
in a recordset, then I can't help since I hate that code. It's to inflexible
and inefficient.

Do your column headings involve time/date intervals?

--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

yes, it is date format.
I found a workaround on the MSDN that remove master and child link
which get report.
I need to run the crosstab query and pass paramter to get subreport.
Your example is for Access 97. Does it work for Access 2003?


Thanks millions again,

 

[Duane Hookom]

If you have date intervals, then I would use the solution found at
http://www.tek-tips.com/faqs.cfm?fid=5466.

 

[iccsi]

If you have date intervals, then I would use the solution found athttp://www.tek-tips.com/faqs.cfm?fid=5466.

--
Duane Hookom
Microsoft Access MVP







- Show quoted text -

It was working when I took out the child master link per MSDN
suggested and hard code the parameters.

I got same message when I tried to pass parameter to my cross tab
subreport from data entry form..
The subreport works by it self.

any idea about paramter passing to a subreport non-fixed column issue?

Your help is great appreciated,

 

[Duane Hookom]

Have you set the parameter data types in Query->Parameters? Most crosstabs
require you to enter the exact parameters (Forms!frmDates!txtStart,...) and
their data types.

 

[iccsi]

Have you set the parameter data types in Query->Parameters? Most crosstabs
require you to enter the exact parameters (Forms!frmDates!txtStart,...) and
their data types.

--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

yes, I set parameter in the crosstab query.

Interesting is only one subreport fails. I have other 2 subreports
work fine with parameters. I even am able to link child and master
link for those 2 subreports.
It seems somthing wrong with this subreport.
I think the worst case is to delete and rebuild this subreport to see
what happens.

Thanks again for helping,

 

[Duane Hookom]

Consider posting the SQL view of the record source that doesn't work.

 

[iccsi]

Consider posting the SQL view of the record source that doesn't work.
--
Duane Hookom
Microsoft Access MVP








- Show quoted text -

Thanks for helping.
I found the problem.
This is the only subreport does not work.
It is base on another crosstab query and a select query.
I need pass the parameters to the first crosstab query then it works
now.

Thanks millions for helping,