Sub-Report won't always display..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

hello there,

I am trying to dynamically assign a report (and its sub-report) resultset
values from various form filters, ie. toggle buttons, combo boxes, via a
SELECT INTO query being ran then assigned as the report's record source..

I have the sub-report 'link child fields - link master fields' functionality
linked to the parent report correctly as far as i can see.

The issue I am having is that the report rarely displays any sub-report
values, although they should exist.

A point to note is that i had it working fine before i introduced the
filtering into the report.. i think it could be someting to do with this
parent (main report) table that i am dynamically creating??

psuedocode is:

onclick of openrpt button:

sqlstring = select blah from blah into blah

select case toggle value
WhereClauseString = blah
case toggle value
WhereClauseString = blah
case toggle value
WhereClauseString = blah
end case

sqlstring = sqlstring & WhereClauseString

runSQL, using sqlstring (with dynamic tablename assigned at design time..)

open report

Am at the end of my tether with this one -any ideas?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200608/1

.

Relevant Pages

  • Re: Filter a subform by a button/toggle on the main form
    ... Why are you using toggle buttons instead of option buttons? ... once you build the filter for the subform, ... If you really meant to say subreport, then you can save the filter before you run the report. ... DoCmd.OpenReport pReportName, acViewDesign ...
    (microsoft.public.access.forms)
  • RE: Error: Subreport could not be shown
    ... I am trying to create a report with a sub-report. ... Next I created a "static" subreport (just to try walking before ... records in the sub-dataset for each record in the main report/dataset. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: report parameter
    ... I delete the sub-report, I don't get the parameter prompt, when it's in the ... main report, I do). ... there is a drop-down list of control names. ... > Dim ctl As Control ...
    (microsoft.public.access.reports)
  • Re: Page Breaks
    ... the 2nd subreport won't start printing on a page unless it will all ... Open the main report in design view. ... Make sure the section's KeepTogether property is Yes. ... There is another sub-report that prints after it. ...
    (microsoft.public.access.reports)
  • Re: Multi-Column report
    ... sub-report it shows up as a 3 column report, but now when it is a ... the size of the Detail section in the main report) then another record all ... Microsoft Access MVP ... I can get it 3 columns, but the Group header is also three columns. ...
    (microsoft.public.access.reports)