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

Smartform Problem

Former Member
0 Likes
541

Hi friends,

I'm new to smartforms. I have created a smartform for customer outstanding Report. but have some issues.

That is,

I want to categorize all rows in reports to,

- Unsettled Invoices (Condition is -> BSID-BLART = 'RV' AND BSID-BLART = 'SA')

- Unsettled Advances/Credit Notes (Condition is -> BSID-BLART = 'DZ' AND BSID-BLART = 'DG' AND BSID-UMSKZ = 'A')

- Unsettled return Cheques (Condition is -> BSID-BLART = 'DZ' AND BSID-UMSKZ = 'D' AND BSID-XBLNR = 'R')

This is the download link to my smartform - https://rapidshare.com/files/785255519/zcusrep.xml

please help me someone. Thanks

Moderator Message: Please dont expect the forum to do your work for you. Also, Smartform-related questions belong to Form Printing Forum.

Edited by: kishan P on May 19, 2011 12:06 PM

3 REPLIES 3
Read only

Former Member
0 Likes
507

please help me someone..

Read only

0 Likes
507

could you please ellaborate on "I want to categorize all rows in reports to ..... "

Do you intend to display rows together base don conditions specified? or something else?

Read only

0 Likes
507

ya i want to display rows together based on the conditions i specified

for example the output is like this:

Date invoice No Amount No of Days Balance Less30 Over30 Over60 Over90 Over120

Unsettled Invoices

15/03/2010 HHIN00023952 100000 100 750

15/03/2010 HHIN00023952 100000 100 750

15/03/2010 HHIN00023952 100000 100 750

Unsettled Advances/Credit Notes

15/03/2010 HHIN00023952 100000 100 750

15/03/2010 HHIN00023952 100000 100 750

Total 500000

Unsettled Return Cheques

15/03/2010 HHIN00023952 100000 100 750

15/03/2010 HHIN00023952 100000 100 750

Total 200000