topic Re: reporting using tx:SQVI in Application Development and Automation Discussions

reporting using tx:SQVI

Tolulope_O — Fri, 30 Oct 2009 14:24:32 GMT

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

Re: reporting using tx:SQVI

former_member191735 — Fri, 30 Oct 2009 14:40:44 GMT

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.

Re: reporting using tx:SQVI

former_member206396 — Fri, 30 Oct 2009 14:57:49 GMT

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

Re: reporting using tx:SQVI

Tolulope_O — Fri, 30 Oct 2009 15:05:58 GMT

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

Re: reporting using tx:SQVI

former_member191735 — Fri, 30 Oct 2009 18:42:07 GMT

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?

Re: reporting using tx:SQVI

Tolulope_O — Fri, 06 Nov 2009 08:54:42 GMT

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