Data item report issue

chris_luther

Hi,

I'm trying to generate a report which has three data items associated to it,

The first is the main header, this is the staff name using the system.
The next is the refund they have done.
The third is the reason why they refunded, I have indented the tables to each other, I.e 1-2, 2-3. As the third table information (the reason) needs to be on the same line as the refund on the report.

Here's my problem, when you run the report the reason for the first entry is blanked and entered on the second entry and so forth. I understand that this is due to the way the report process in order.....

My question is how do I fix this? Really need to get it done, am fairly fresh to the Nav world but am keen to learn on my own so would really appreciate the help.

Thanks

GRIZZLY

What is link condition between dataitems?

mohana_cse06

and you can show report sections screenshot..

chris_luther

I have attached screen shots of the following:

Data Item Layouts

Sections

As you can see from this screen shot of the 'printed report', it simply misses the first line, but takes that data to the second line.

chris_luther

Also the properties for the data items:

mohana_cse06

try by moving the fields from section "Trans. Sales Entry" body to "trans. infocode entry" body ..

chris_luther

Thanks that worked...so obvious when you mentioned!

I have another issue now though, if there is no reason code for that entry, it doesn't display it now, I have checked 'PrintOnlyIfDetail' and that is set to no!

It appears to be that if there is no 'Trans. Infocode Entry' then it won't include the 'Trans. Sales Entry'

Any ideas?

mohana_cse06

You have to check whether Trans. Infocode Entry exists or not from Trans Sales Entry onAfterGetrecord..
If exists then show the Trans. Infocode Entry sections
if not show Trans Sales Entry Sections

chris_luther

Ok, that seems relatively straight forward, what would the code on the AfterGetRecord trigger look like?

mohana_cse06

chris_luther wrote:

Ok, that seems relatively straight forward, what would the code on the AfterGetRecord trigger look like?

are you a technical person? :-k

chris_luther

Yes, just we tend to use a company to design reports for us, however I am in the process of doing relevant courses in C/Side, so i'm trying to learn how to do this. I run the IT for my business and need to move my Nav development forward.

mohana_cse06

Create a global variable as TransInfoCode with record trans Infocode Entry

Write below code in onAfterGetrecord of Trans. Sales Entry

TransInfoCode.RESET;
TransInfoCode.SETRANGE("Transaction No.","Transaction No.");
// if you have staff ID in TransInfoCode entry table, you can filter on that also
IF TransInfoCode.FINDFIRST THEN
  InfocodeExists := TRUE // InfocodeExists is a global boolean variable
ELSE
  TransInfoCode := FALSE;

In Trans. Sales Entry Sections write

CurrReport.SHOWOUTPUT := NOT TransInfoCode;

In Trans. Infocode Entry Sections

CurrReport.SHOWOUTPUT := TransInfoCode;

PS: Above code in not tested so you may require some changes..