Hi, I have a requirement like A report that shows by client all future scheduled payments,based on values and volumes,so for example ABC has 100 plans for a value of $100,these are spread over the remaining days of the month from whichever day we are. so in the above example if it was the 28 the report would show that there are a portion of the 100 due on the 29th,30th and 31st.
In the above report clientname, filecode need to come from sql server and payment plan value should be generated dyanamically in the SSRS depending on whichever day payment plan is on until last day of the month.
Please help me how to do in SSRS.