https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/94696.aspxTue, 10 Dec 2013 10:36:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:94696wilkies0106aw0https://www.infopathdev.com:443/forums/thread/94696.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=94696<p>I have an InfoPath (2010) designed holiday request form. The holiday to and from dates are date picker controls.&nbsp; The holiday unit&nbsp;fields are number fields.&nbsp;These fields are published to a SharePoint 2010 form library.&nbsp; The InfoPath fields look like (<span id="ctl00_ctl00_bcr_bcr_PostForm_ctl04_AttachmentSubForm_ctl00_Filename">infopholiday.jpg).&nbsp; </span></p><p><span>I have an external&nbsp;timesheet software (SQL) which records each day as an individual line entry not as a group like&nbsp;on a&nbsp;holiday form.</span></p><p><span>This is starting to play havoc when trying&nbsp;to marry up and do reporting. The reporting is done via SSRS. </span></p><p><span>The reporting is basically&nbsp;summing the billing software holiday total taken for an individual user, then matching against&nbsp;the SP list:&nbsp;1. does a holiday request form exist. 2.&nbsp;how many&nbsp;holiday&nbsp;units were taken.</span></p><span><p>&nbsp;</p><p><span>How could I easily change the design of the InfoPath form to record each day as an individual entry. Ideally I don&#39;t want a table with X number of date controls showing. That I think looks really untidy.</span></p></span><p><span>I could&nbsp;use a repeating table on the form, however individual repeating tables lines aren&#39;t published&nbsp;to a SharePoint library.&nbsp;</span></p><p><span>Any advice?</span></p><p><span>&nbsp;</span></p><p><span>Thanks</span></p><p><span>W</span></p>