Hello all,

I just recently joined the forum and i need some help from you all,

here's the case:

system : LN 6.1 FP3

i want to make a report with the SQL queries thru the ttadv3580m000, i already made the layout and the data is correct.

but there's one problem, there are no zooming in my report parameter, if there's no zooming in my report it means that the user need to know each of the order number that he/she wants to print.

so, is there any way for me to edit the form? it seems i can't edit the tools session, or is there any way for me to add the zoom in the sql report?

any suggestion and links will be a great help.

Cheers and regards,

Roy.

I didnt get your point clearly.

If you want to add a zoom field in print session then,

You can edit the form and add "to" and "from" table fields and you hav to write sql in program script of that print session inorder to force the report to read the data from corresponding fields.
This is one of the solutions.
try it.

Hi & welcome to the forum :),

I didn't get it clear either. Is the zoom fields you want related to the print session? Zoom comes in the session not in the report. in the report you can get the zoomed-to values from the session.

Can you post a screen shot of the print session you are talking about and mention the fields that you need. Also if you have written any code, we would like to see it.

- George

Hi,


Thank you for the fast reply,

before i tried with the sql data session i already tried with the session and programming script, but the result is very strange, the only record that correct is the first record, the other is either zero for number and blank for item, so i think i want to try with the sql queries, because i'm more familiar with sql language than the 4gl baan script.

i already read the programming guide but perhaps i missed something

this is the report script,


declaration:
table twhinh200
table twhinh220
table ttccom130
table ttcibd001
extern domain tcsern sernc
extern domain tcitem itemc
extern domain tcpono ponoc
extern domain tcmcs.str100m lncus
extern domain tcdsca dscac

header.10:
before.layout:
select whinh220.oset:sernc,whinh220.item:itemc,whinh220.pono:ponoc
from whinh220
left outer join whinh200
on whinh220.oorg =:whinh200.orno and whinh220.orno =:whinh200.orno and whinh220.oset =:whinh200.oset
selectdo
endselect

i think the problem is either on the queries relation or the report layout.


any suggestion is a grand^^.

Roy.

Hi,


My bad with words i think^^,

what i meant with sql data is the ttadv3580m000 and after i created the report i'm using the specific->run query, the session that appeared seems to be default and i can't change it.

correction will be honored^^,

Roy.

If you need the user to select a specific range for his data, it is recommended to create a new report and attach it to the most relevant session or create a session by your own. It is not hard.

Let us know if you already have a relevant session or do you need a new one.

- George

ok i will try again to use the session.

by the way, how's my syntax? i'm not sure about the table relation one....i still can't understand the difference between table a = table b and table a =:table b

:).