I had thought about using a dropdown control (ASP or SharePoint) to select from a list the number of invoices to report. Then I'd take the selected number as a parameter to conditionally display the necessary fields (date1, amount1, description1, date2, amount2, description2, etc.).
I also need to save the selected number of invoices as part of the expense report, because I can use it in a SPD workflow as part of my process control.
What I have found is the following:
* If I use an ASP dropdown, I can convert the selected number into a parameter and have a "dynamic form" but then I don't have a way to save the number selected in one of the fields (columns) of the expense report.
* If I use a SharePoint dropdown, I can preserve the number selected in the dropdown, because it is bound to one of the fields in the expense report, but I can't use it as a parameter to conditionally display / hide the other fields.
Can you help me out in this challenge? Any important point that I may be missing?