Options

RDLC Data Problem

Jatin_PatelJatin_Patel Member Posts: 200
edited 2011-06-30 in NAV Three Tier
HI,

I convert one classic report to RTC.
But i can't get values in RDLC dataset same as Classic Report?
For Example in Classic Report 100 rows showing but in RDLC only 60 rows is showing.
Jatin Patel
Microsoft Dynamics NAV Consultant
Jatin's Blog

Answers

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    I hope you have just done Create Layout suggestion?
    if yes, create layout suggestion creates only 20-30 % RDLC report. remaining % you have to create manually by checking classic.
  • Options
    Jatin_PatelJatin_Patel Member Posts: 200
    Yes i Completed the layout.
    It's run Properly.
    When i see About This Report Property than data is not same as Classic Report.
    Less rows than Classic Report.
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    It is very difficult to guess without knowing the design of the classic and RDLC reports
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    i also have a problem when creating RTC reports
    there are blank spot in my preview report
    please take a look
  • Options
    Jatin_PatelJatin_Patel Member Posts: 200
    Which Grouping use on Table Group Expression?

    If possible than give image of your RDLC Dataset from "About This Report" Property.

    Or else u can filter your data with Fields!Sales_Invoice_Line_Description.value Expression.
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    Which Grouping use on Table Group Expression?
    i'm not using grouping
    If possible than give image of your RDLC Dataset from "About This Report" Property.
    i attach about this report
    Or else u can filter your data with Fields!Sales_Invoice_Line_Description.value Expression.
    i already filter description <> ''
  • Options
    Jatin_PatelJatin_Patel Member Posts: 200
    Apply Group on Sales Invoice No Field.

    And in Table Details row gives color to check from where this blank line printed.

    Then check what happen.
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    Apply Group on Sales Invoice No Field.

    And in Table Details row gives color to check from where this blank line printed.

    Then check what happen.

    do you mean i must add group?
    because i only have detail
    and footer for totaling
  • Options
    Jatin_PatelJatin_Patel Member Posts: 200
    Please send me full classic layout view image.
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    i think this is because of the header
    take a look at my picture
    maroon --> header
    grey --> body
  • Options
    Jatin_PatelJatin_Patel Member Posts: 200
    Yes Put Description and amount label on Table Header Row in Body.

    And hidden fields for ReportItems on Page Header put on table column.

    Then Check it again.
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
  • Options
    julkifli33julkifli33 Member Posts: 1,073
    Yes Put Description and amount label on Table Header Row in Body.

    And hidden fields for ReportItems on Page Header put on table column.

    Then Check it again.

    i had experience put the description or other fields in Table header
    it can showed using reportitems
    but only showed on the first page, so I put it in the body
    even though it has more than 1 page, still showed
  • Options
    Jatin_PatelJatin_Patel Member Posts: 200
    If u put ReportItems fields on Table header than set RepeatOnNewPage property to TRUE.

    or else put it on Table details row column. so it willbe print on all pages.
    Jatin Patel
    Microsoft Dynamics NAV Consultant
    Jatin's Blog
Sign In or Register to comment.