[AccessD] Crosstab Report

Barb,

    You can try the following:

    1 - Place adequate number of extra unbound text boxes so as to cover maximum likely columns over and above 14. These text boxes should normally be in a hidden state and can all be overlapping, located at left edge of the report.

    2 - Depending upon the actual number of extra columns (beyond 14) in the record source, unhide the required number of text boxes, assign appropriate control source and move these to suitable positions at right of report, by manipulating the Left & Top properties. Starting reference would be Left value for last text box (representing 14th column) + Width of this text box + suitable margin (in twips).

    With above measures, the report will generate extra pages as required on account of additional columns.

Best wishes,
A.D.Tejpal
------------

  ----- Original Message ----- 
  From: Barbara Ryan 
  To: Access List 
  Sent: Wednesday, November 07, 2007 23:20
  Subject: [AccessD] Crosstab Report


  I have created a crosstab report which contains 14 columns of data.  If the underlying crosstab query yields more than 14 columns, I want to add a new page to display the remaining columns.  The data on the report is populated via code using a recordset based on the crosstab query. 

  I am currently reading through the recordset and populating 14 columns of data, then doing a page break, an "rs.Movefirst", then reading thru the recordset extracting data beginning in the 15th column.   However, the Detail Format and Print events do not fire.

  What am I missing?

  Thanks,
  Barb Ryan