mibuso.com
Home› NAV Three Tier

Complex RTC Report problem

ILMEILME Member Posts: 23
edited 2011-12-01 in NAV Three Tier
Hi all, I have an issue in one RTC report I've created.
I have in my report 2 data items with same indentation, each having the same table as data item indented beneath it, eg.

Item
--CustomTable A
> (1)
Manufacturer
--CustomTable A
> (2)

In the Classic Client the report prints fine!
I need to print on my RTC report only data from CustomTable A, not from Item or Manufacturer table.
First from CustomTable A (1) and then from CustomTable A (2)
I've put checkboxes in the request page to show or not Item CustomTable A records
or Manufacturer CustomTable A records.
So far, so good. The detail rows print smoothly showing A (1) or A (2) records according to what check boxes I've checked.

My big problem is that I can't seem to control how to correctly show the
ReportItems!COMPANYNAME.Value and ReportItems!MyReportCaption.Value
on the Page Header.
I cannot show these two report items, although I've put the hidden textbox info for them
to the right of each detail row ( CustomTableA(1) row & CustomTableA(2) row )
I suspect that I haven't put the hidden info text boxes for these report items in the correct place. Do I have to put them elsewhere??
Below, I'm attaching a screenshot of the report design to show you what I mean

Any help would be welcome.
Thanx
* IF NOT done THEN REPEAT UNTIL done *

Answers

  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Can you show your classic report view and rdlc view?

    you can create a new table as a first table in body of the report and place those hidden fields in that..

    and also please check the dataset result in about this report?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • ILMEILME Member Posts: 23
    Hi Mohana & thanx for the answer.

    The funny thing is that the PAGENO textbox on the right prints very well each time, but maybe it's got to do with the fact that this is a System Variable and it's different in some way from the ReportCaption label and the COMPANYNAME textbox.

    I've created a new Table in the RTC Body section and put those hidden info there but nothing changed.
    Can u please look at the pic I attached & tell me where would you put those hidden info textboxes in order to show those 2 items of the Page header on the top of every page???
    * IF NOT done THEN REPEAT UNTIL done *
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Did you check the dataset result?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • ILMEILME Member Posts: 23
    What exactly do you mean by saying "Check the dataset result" Mohana?
    Can you be more specific on exactly what values do I need do check?
    And how to check? with debugger?

    Thanx
    * IF NOT done THEN REPEAT UNTIL done *
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    When we run report in navision...result dataset is flown to rdlc and there we need to show the data..

    to check the dataset we need to activate about this report first and then run again..

    search the forum with about this report and dataset result..

    http://mibuso.com/forum/viewtopic.php?f=32&t=48738&hilit=about+this+report

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • ILMEILME Member Posts: 23
    Well, I finally found it.
    After adding an Integer data item on the report, it looked like this:

    Integer
    --Item
    ----CustomTable A
    > (1)
    --Manufacturer
    ----CustomTable A
    > (2)

    Then I put all the header details to the Integer Header and the hidden info
    at the bottom, in a new details section.
    It ran pretty smoothly showing everything in place.

    Thanx
    * IF NOT done THEN REPEAT UNTIL done *
Sign In or Register to comment.