Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Parameter selection in query reports

Former Member
0 Likes
1,867

Hi,

Does anybody knows how to create a parameter selection in a query report?

Thanks in advance,

Eduardo

5 REPLIES 5
Read only

Former Member
0 Likes
1,797
Read only

Former Member
0 Likes
1,797

Follow the below steps:

Tcode is SQVI

->Create

Enter the Title, Select the data source & provide the Table/View details. Select the Basis mode.

In List Fld Selection Tab, select the fields from Available fields. These fields will appear in your report.

In Selection Fields Tab, select the fields from Possible Selection fields. These fields will appear in your parameter selection.

->Execute.

Hope this helps.

Kind Regards,

Satish Kanteti

Read only

0 Likes
1,797

Hi,

  1. Run the transaction SQ01.
  2. Display your Query.
  3. Press the next screen button on the top left corner.
  4. On Third screen you can find the selection fields from your field group.
  5. Check the boxes  you will those field as parameters on selection screen.

Or

May be the steps are in older version

<< Moderator message - Cut and paste response from  http://msdn.microsoft.com/en-us/library/dd788562(v=bts.10).aspx  removed and points unassigned. Plagiarism is not allowed in SCN >>

Read only

Former Member
0 Likes
1,797

Hi you can try to use SQVI t-code  which does the same job and have a provision of parameter selection.

Best Regards,

Sarveshvaran

Read only

Former Member
0 Likes
1,797

Hi,

You can try this.

1.) Go to SQ01 > Enter your query name. > Click CHANGE

2.) In the Menu bar, Click GO TO > Field Selection > Selections

3.) Select your desire fields then check this two check boxes.

4.) Then Execute. This will be the final output.

Regards,

Jake