Views

Re: Group data from repeating table based on one field

Unreal1998 — Fri, 30 Oct 2009 17:55:38 GMT

I do not have a good understanding of XLS or HTML. I really appreciate the help. Does IP 2007 have better "reporting" capabilities than 2003? The application I'm building is a Personnel database that is linked to an Access db. I want to keep IP as the front end app for everything, but I'm afraid that I may have to do the roster printing with reports in Access. There I'll have the abilitity to print headers(something not easily done in IP 20030 and group data.

I wonder if you can open access from infopath.

thanks again for all your help sir.

Re: Group data from repeating table based on one field

Jimmy — Thu, 29 Oct 2009 15:34:36 GMT

Thank you for the screenshot. As far as I can think, what you describe is possible, but fairly complicated. I can think of two approaches:

Manually modify the form's XSL file to generate the tables from your existing data source (requires a good understanding of XSL and HTML).
Use code to organize your data into a tiered structure in a secondary data source, and display that in the form (requires a good understanding of code [C#, VB, or JScript], but doesn't require manually modifing the form's files).

I'm attaching a simple example of the first approach. If you at least have a good understanding of HTML I can try to walk you through it, but it would require re-extracting the form and modifying the XSL any time you want to make changes to that part of the form. If you're willing to give that a try, let me know.

It would be far simpler to display only one of these Jurisdiction tables at a time, and have the user select which one they want to view at any given time. This wouldn't require either of the workarounds above and could be done entirely in the InfoPath designer. Would that possibly be an option for you?

Re: Group data from repeating table based on one field

Unreal1998 — Thu, 29 Oct 2009 13:07:17 GMT

Here's a screenshot of data source. I'm working off a primary EMP table.

Re: Group data from repeating table based on one field

Jimmy — Wed, 28 Oct 2009 23:24:29 GMT

Would you mind attaching a screenshot of your data source (from the taskpane)? I have a feeling that there's no easy way to do this using just the InfoPath designer, but let's have a look at the data source first.

Group data from repeating table based on one field

Unreal1998 — Tue, 27 Oct 2009 14:46:02 GMT

I have an employee table where people are assigned to different jurisdictions. In the form print view I have a repeating table and I want to group EMP from the same jurisdiction together as shown in the attached screenshot from an Excel file.

Note: Each record or EMP has a jurisdiction attached to it.