none
Microsoft report RRS feed

  • Question

  • Hello Frnds Plz Help Me....

    i have 3 column and arround 90 rows in a dataset and these are inserted into microsoft report table.

    these 90 rows are divided into three tables. as

    s.no.     name     weight     s.no.     name     weight     s.no.     name     weight

    1           aaa         45          31        bba           61         61        cca         49 

    2           aab         45          32        bbb           58          62       ccb         81  

    3           aac         50          33         bbc           56          63       ccc         69 

    4           aad         57          34         bbd           42          64       ccd         57

    .                                         .                                          .

    .                                         .                                          .

    .                                         .                                          .

    30                                       60                                      90

    Thursday, March 17, 2011 1:41 PM

All replies

  • You would manually create 3 tables, using the same dataset. Each table would have a different filter applied to the s.no. column data:

    table1: filter to 1-30

    table2: filter to 31-60

    table3: filter to 61-90


    Cephas Lin This posting is provided "AS IS" with no warranties.
    Thursday, March 17, 2011 3:22 PM
    Moderator
  • when i use this i got error:

    A FilterExpression for the tablix ‘Tablix3’ includes an aggregate function.  Aggregate functions cannot be used in dataset filters or data region filters.

    Friday, March 18, 2011 6:18 PM