I have an InfoPath (2010) designed holiday request form. The holiday to and from dates are date picker controls. The holiday unit fields are number fields. These fields are published to a SharePoint 2010 form library. The InfoPath fields look like (infopholiday.jpg).
I have an external timesheet software (SQL) which records each day as an individual line entry not as a group like on a holiday form.
This is starting to play havoc when trying to marry up and do reporting. The reporting is done via SSRS.
The reporting is basically summing the billing software holiday total taken for an individual user, then matching against the SP list: 1. does a holiday request form exist. 2. how many holiday units were taken.
How could I easily change the design of the InfoPath form to record each day as an individual entry. Ideally I don't want a table with X number of date controls showing. That I think looks really untidy.
I could use a repeating table on the form, however individual repeating tables lines aren't published to a SharePoint library.
Any advice?
Thanks
W
