RDLC Data Problem

Jatin_Patel

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.

mohana_cse06

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.

Jatin_Patel

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.

mohana_cse06

It is very difficult to guess without knowing the design of the classic and RDLC reports

julkifli33

i also have a problem when creating RTC reports
there are blank spot in my preview report
please take a look

Jatin_Patel

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.

julkifli33

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 <> ''

Jatin_Patel

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.

julkifli33

Jatin Patel wrote:

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

Jatin_Patel

Please send me full classic layout view image.

julkifli33

i think this is because of the header
take a look at my picture
maroon --> header
grey --> body

Jatin_Patel

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.

julkifli33

Jatin Patel wrote:

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

Jatin_Patel

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.