reporting using tx:SQVI

[Tolulope_O]

Hello gurus,

I am new to reporting and am looking to create my first report from r/3. I have used tx:sqvi to join the following tables (ekkn, vbrk, vbrp).

I have selected the fields I require however when I execute the report, it request for a layout view.

did i miss anything in the process?

how do i create my report?

Regards,

Tolulope

[former_member191735]

Just come back to initial screen then choose your query then execute it. If you dont find it, you may not saved your query

It is very simple - Go to change mode (if you have the query in place) - select fields that you want to see, go to sort order tab then choose sort order and selection fields as well . (do it in basic mode)

Save and come back then select your query - execute.

[former_member206396]

Hi,

follow the steps:

SQVI

enter Data Source as table join. and continue.

inset the tables one by one..

come back and follow below

Select the fileds using "Selection fileds" tab ( for selection screen )

and select the output as "list seld flds" tabl ( for output fileds )

hope this helps

Ram

[Tolulope_O]

Thank Sampath & Ram,

I did just that initially; however when I execute the report if gives me a warning that "some currency fields would not be filled".

when i continue from there; the next screen did is requires a layout type which does not exist.

am stock at this point.

regards,

Tolulope

[former_member191735]

What does that mean?

You dont have any output fields

Do you have fields in List fld.select tab? If no... please add what you want there?

Do you have fields in selection fields tab? if no.... add selection screen for ur query

there is nothing i could see wrong other than this... this is a simple query

Also check what is the data source and tables joined?

[Tolulope_O]

I changed the option in the export as frame to MS excel