sub report and non-fixed column cross tab quesry

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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 -
Click to expand...

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,
 
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?
 
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 -
Click to expand...

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,
 
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 -
Click to expand...

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,
 
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.
 
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 -
Click to expand...

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,
 
Consider posting the SQL view of the record source that doesn't work.
--
Duane Hookom
Microsoft Access MVP








- Show quoted text -
Click to expand...

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,
 
Back
Top