help ---help---help----

[robin2008]

here is my case---

1-need LOAN-NO, LOAN-TYPE, and DATE(from-to) as a prompt,

Then Inside

2- My report has three parts---a) Customer name,address,loan no,and loat status

b)Certain loan fields has to be shown but all must fall inside the date, that we had chosen at begining on prompt page

ans last

c) I have to show certain transaction amounts which also must fall under same date and also it must represent the code from 40-49, 80-89 and 90-99

so does anybody has any idea ....I have been through 2nd part but stuck on 3rd part as..how to display all those particular date where transaction happens....

any help appreciate

[sdee_sekaran]

Perfom some calculation like
case
when
(code between 40-49  or
code between 50-59 or
code between 80-89) then
Code
else
null
i hope it should work and if my understanding is correct.

[bonniehsueh]

If i understand correctly, this is what i would suggest.

c) I have to show certain transaction amounts which also must fall under same date and also it must represent the code from 40-49, 80-89 and 90-99

1) To fall within the same date as chosen in the prompt:
Filter the query of the list or crosstab with the date prompt.

2) For the Codes:
You can either filter the prompt using something like..

Code Select Expand

between 40 and 49 or between 80 and 89 or between 90 and 99

OR if its a dimensional model, you can directly slot in the members on the crosstab.

Not sure if this is what you were looking for. Hope this helps.