Results 1 to 4 of 4
  1. #1
    Join Date
    May 2014
    Posts
    98

    Unanswered: Generating Reports

    The input form of the database have one common table containing data for all parameters for row source. As all data was in one table had one ID. My problem is I am trying to run reports from a form after selecting dates and parameters.For selecting parameters I created dynamic combo box. For dynamic combo box I needed ID and description of the parameters. So I created separate tables for each parameter with ID and Description column. Which ran me into the problem that when I run report based on main input form which has different row source table and my report form has different row source tables and reports doesn't run when I base my queries on the report form.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the approach I use for a reporting suite is:-
    create a form that acts as a report switchboard
    place all the controls of the parameters you need on that form
    call the repoprt fromt hje swtichboard and set appropriate filter on the openreport macro

    have s econd form called from the switchboard that pulls the current parameters. build in your logic in this form
    when the user has finished with settign parameters push the new valeus back tot he switchboard form.

    why do it this way?
    well the switchboard form always opens with known good values (eg dates and so on)
    the switchboard can get meesy if you have to build in logic checking, but the real reason is that once users have set the parameters they want, they can run as many reports as they like, but there is no inadvertent chance they can change parameters... they would have to open the sub form, accept not cancel any changes)... it means the developer and the user can be absolutely confident that these parameters are consistent across all reports and forms

    but I also make certain that these parameters are also picked up int he form and displayed there. I don't want a user trying to shift the blame if parameters change, and in the veent they do change between report runs they can immediately see what parameters are there. no assumptions are made, it all explicit
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2014
    Posts
    98
    I am not able to understand your solution my problem is

    to run reports from a form where the form has the criteria...

    user picks items in a combo or text box so the report query has

    select * from table where [state] = '" & forms!frmMyForm!cboState & "'"

    However my combo boxes were required to be dynamic combo boxes. For these comboxes I created new tables instead of using old common data table. Thus my row source for main input form is different than report form. I hope I am making something clear

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well thats OK, if my approach doesn't cut it, I'm out of here...
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •