locked
Details Section Error RRS feed

  • Question

  • User1465448693 posted

    I am using dataset ,containing 2 datatables!..i want to display the complete contents  of each datatable one after other..ie..i have

    First datatable ""Qualification""" with 1 column and 2 rows.... Row values are.. "qual1 ,qual2 ."

    and second datatable ""Degree"" with 1 column and 2 rows  Row values are .." Degree1,Degree2 "..

    i've added the fields to details section.with no links

    but it displays as 

    --------------------------------------------

    qual1

    Degree1

    qual2 

    degree2

    -----------------------------------

    but  i need it to be ...as below..

    ----------------------------------

    qual1

    qual2

    degree1

    degree2

    ---------------------------- 

    can anyone help me out...thanx in advance..

    Tuesday, June 26, 2012 3:05 AM

Answers

  • User-929656654 posted

    When people are asking show your query, show your field explorer, there is reason behind that.

    Anyway,

    In Detail section: Display Qualification table info

    In the report footer: Place a sub-report.

    In the sub report, display your second table. No link between table? Mmm...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 26, 2012 8:52 AM

All replies

  • User1867929564 posted

    Many solution
    i) Show ur query.
    ii) you can use formula field to adjust.
    iii)how are column appearing in field explorer ?

    Tuesday, June 26, 2012 3:56 AM
  • User-661350001 posted

    merge both tables with one more column sorting which will contain say "0" for qualification table rows and "1" for degree table rows

    and bind result table to a grid and sort by Sorting column

    Tuesday, June 26, 2012 5:12 AM
  • User1465448693 posted

    Sorry Frown..i dont have the query,,please can u tell ..how it can be done??

    ..assuming u are having 2 Datatable in a dataset..

    i need to display values from first datatable on the upper part of details section

    and values of second datatable on lower part of details section

    ..(--Just one column is present in both the datatable---/)

    .waitng for ur repli..thanx in advance

    Tuesday, June 26, 2012 5:16 AM
  • User-929656654 posted

    When people are asking show your query, show your field explorer, there is reason behind that.

    Anyway,

    In Detail section: Display Qualification table info

    In the report footer: Place a sub-report.

    In the sub report, display your second table. No link between table? Mmm...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 26, 2012 8:52 AM
  • User1465448693 posted

    Yeah..Thanx all..Cool

    SubReport Solves the Issue!

    Tuesday, June 26, 2012 8:55 AM