Adding and deleting columns dynamically, repeating row headers 
Author Message
 Adding and deleting columns dynamically, repeating row headers

I have a two part question:

1)  Is there any way of adding and deleting columns dynamically in a
report?  The report I'm working on may have a any number of columns (based
on a crosstab query).  Adding the maximum number of columns to a page and
hiding any unused ones will not work because the number of columns can vary
so much that they may spill onto the another page and I don't want to make
my report so wide that I'm printing blank pages 95% of the time.

2) If there is a way to do what I have asked above I'd also like to be able
to repeat row headers on any additional horizontal pages.  For example if I
had product names as column headers and sales persons names as row headers,
is there someway of repeating those row headers on page 2 if the number of
products spills onto an additional page?


                                                       page1     |                                                     page2    
                Prod1           ...             Prod10   |              Prod11          ...             Prod20  
Jon Doe         ---             --              --       | Jon Doe      --              --              --
Jane Doe        --              --              --       | Jane Doe     --              --              --

I'm open to any other products that anyone can suggest as long as they have
the functionallity I'm looking for.


Fri, 28 Apr 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Dynamically Added Datagrid Template Column - Checkbox.Checked state in Column Header

2. Crystal Reports: add/delete groups dynamically and starting a new page dynamically

3. Repeat Headers on Columns

4. Data Report Object - Suppressing repeated rows in a report column

5. CheckBox.Checked property in the Header of a Dynamically created DataGrid Column

6. Columns and Header row

7. Help adding Table Rows dynamically Please!

8. to add row dynamically in table

9. Add new row to a table dynamically

10. DataGrid adding an extra Header Row

11. Adding Column Headers

12. How to add column header icon on a MS datagrid


Powered by phpBB® Forum Software