Hi All,
I have a question in Impromptu 7.1,
There is a simple list that runs every month.
TNo TAmt
----------
1 $25
2 $139
1 $100
1 $39
3 $90
Final Report should be
----------------------
TNo Curr.Month Amt Last_Mon_Amt Inc/Dec %Inc/Dec
--------------------------------------------------------
1 $164 $100 $64 64%
2 $139 $110 $29 26.4%
3 $90 $50 $40 80%
My question is how do I get the transaction amount for the last month and get the increase/decrease and Inc/Dec% in the same page.
Is this possible or should I add one more list frame with date prompts and run the report for the previous month?
One more problem I face with this report is:
If I run the report it prompts me for the date for the first simple list report. This is OK. But it prompts again to display the summary report with the total transaction amount. How can I avoid this?
Note: I have simple list and summary report on the same page.
Please help. Thanks in advance
I have a question in Impromptu 7.1,
There is a simple list that runs every month.
TNo TAmt
----------
1 $25
2 $139
1 $100
1 $39
3 $90
Final Report should be
----------------------
TNo Curr.Month Amt Last_Mon_Amt Inc/Dec %Inc/Dec
--------------------------------------------------------
1 $164 $100 $64 64%
2 $139 $110 $29 26.4%
3 $90 $50 $40 80%
My question is how do I get the transaction amount for the last month and get the increase/decrease and Inc/Dec% in the same page.
Is this possible or should I add one more list frame with date prompts and run the report for the previous month?
One more problem I face with this report is:
If I run the report it prompts me for the date for the first simple list report. This is OK. But it prompts again to display the summary report with the total transaction amount. How can I avoid this?
Note: I have simple list and summary report on the same page.
Please help. Thanks in advance