it would be nice, if you could help my in the following case.
In the dataset designer i got three tables. Table 1, 2 and 3. I got a relation / link from Table 1 to table 2 and from Table 1 to Table 3.
At the Moment it seems like there is no way to link Table 2 and 3.
So i nested/indented Table Two under TableOne and TableThree under Table One with the same indentation. Otherwise (if I would indent Table 3 under Table 2 or the other way round) NAV would throw out an error, because it don’t know how to connect them.
you have to Know the Rendering Process of Report .As per you said it would execute like
For Each record in table1 is indented to table 2 so respective record will get print along with table1 and coming to table 3 loop though all recs table 3 and all recs in table 3 will be printed …
for help you have to tell which tables using …indenting is nothing but looping 1st single rec with all of next table…
I can imagine how the Rendering Process of Reports works, but this doesn’t help me here.
(by the way, I solved my Problem above with C/AL code, but this doesn’t seem to me like the proper way here - and now I am developing another Report with a huge more tables, so it cannot be the only solution to get everytime in c/al code and filter there)
so to specify my problem, i think it is about the linking of 2 tables.
Table 1(indented 0 times)
Table 2 (indented 1 times)
Table3 (indented 2 times)
Table4 (indented 2 times)
Table5 (indented 2 times)
Table 6 (indented 1 times)
Table7 (indented 2 times)
Table8 (indented 2 times)
Table9 (indented 2 times)
indentitation/nesting from the tables is as above
there is a link from table 6 to table 1 and from table 2 to table 1, but there are NO conncetions from table 2 to table 6.
As you said There is Link Between table 6 to table 1 and from table 2 to table 1, but there are NO conncetions from table 2 to table 6.
then do if you indent at same level then parent dataitem(i.e Table 1 will be assigned in datatitemlinkreference property)… So you cant connect to tables at same Indent Levels…
So you have indent table6 under Table 2 so u can connect…