Re: Unbound Report

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Luis (anonymous_at_discussions.microsoft.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 14:08:17 -0800

Duane:

I did what you have told me and this is what I get:
"You can't use a pass through query or a non-fixed-colum
crosstab query as a record source for a subform or
subreport.

Before you bind the suform or subreport to a crosstab
query, set the query's ColumnHeadings property."

I subreport comes from a query, but it is not
crosstab...I do not understand what it means about
setting ColumHeadings property. Can you please assit me
on this issue...

>-----Original Message-----
>I think all you have to do is set the Link Master/Child
properties of the
>subreport to your linking field (Contract?).
>
>--
>Duane Hookom
>MS Access MVP
>--
>
>"Luis" <anonymous@discussions.microsoft.com> wrote in
message
>news:209501c4e864$8efdae20$a401280a@phx.gbl...
>> Hi:
>>
>> I have the followinf problem with my report:
>>
>> Problem:
>> I have created a report in which I added a subreport.
>> Well, I created the subreport using the Wixard and
>> selected "not to bound it"...The problem I have is that
>> now that I add new data into my subreport it adds it
for
>> every contract that I have instead of adding only the
we
>> are suppose to bill each contract...
>> Example
>> I get:
>> Contract LMOBG1022
>> Code Bill
>> H305 2
>> H306 1
>> H305 5
>> H306 2
>> Contract RAMBG0608
>> Code Bill
>> H305 2
>> H306 1
>> H305 5
>> H306 2
>> and I want to obtain:
>> Contract LMOBG1022
>> Code Bill
>> H305 2
>> H306 1
>> Contract RAMBG0608
>> Code Bill
>> H305 5
>> H305 2
>>
>> How do I go back to tell it that Bill Units vary per
>> contract...I used the wizard to create my subreport and
>> selected unbound, but now I do not want to recreate the
>> entire report....
>>
>> I hope it makes sense what I am asking...
>>
>> Thank you...
>
>
>.
>

Quantcast