InfoPath Dev

I have a timesheet form that I need to be able to sort by date and / or project no. There doesn't seem to be any inbuilt functionality is there a way of getting around this?

Hi,

Can you verify below links.

http://blogs.msdn.com/infopath/archive/2006/12/06/sorting-repeating-and-tabular-data.aspx

http://blogs.msdn.com/infopath/archive/2006/12/15/another-way-of-sorting-repeating-data.aspx

Hi,

   Not being a programmer myself, is there a way to achieve this without using code. I find the instructions difficult to follow

 Is the 2nd example C# or VB

We have a new beta product called qRules that is available for *free* download. It has a command for sorting. You could add some buttons to sort, and use qRules commands to sort your list -- no code! Give it a try, and post back if you get stuck....

Hi,

    I managed to use the qrules with a normal repeating table. Will the qrules work with a repeating table that is used to submit data to an SQL database. I have tried but it doesn't seem to work, it doesn't return any errors

I just tested this and it worked for me. For the /compare argument, remember that you will probably be passing in an attribute, so it will look like '@Fieldname' rather than 'd:Fieldname' or 'my:Fieldname'. Would you mind pasting in what you are setting the Command field to?

Here is the command. 

 SortTable /row=dfs:myFields/dfs:dataFields/d:Project_Hours /compare=@Project

Your command looks right. I know one of our testers uses Vista, so that shouldn't be the problem. Try a different qRules command in your form -- let's make sure the .dll is still there. Or try using SortTabl instead of SortTable -- the misspelling of the command should trigger an error, which will let us know that qRules is still in your form.... You didn't add any event handlers to your form, did you? It can be really easy to accidentally add an event handler, and if you add code to your form, qRules gets its feelings hurt....

 When I try and use qrules on vista with any infopath template I receive the following message. But when I use XP its fine.

Could not load file or assembly 'CabLib, Version=6.9.26.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.

 The root cause seems to be vista, because I created a form on a XP machine and applied the rules to sort the SQL Table without any problems

Good to know -- I'll see if we can replicate this bug.

spawforths:

Hi,

    I managed to use the qrules with a normal repeating table. Will the qrules work with a repeating table that is used to submit data to an SQL database. I have tried but it doesn't seem to work, it doesn't return any errors

Hello,

If I'm understanding it correctly, you managed to get it working before even trying in XP, which means you were still on Vista during that time. So we can tell that you're able to "inject" qRules successfully in your forms in Vista. Please correct me if I'm wrong.

Also, what version of InfoPath are you using?

Cheers!

Are you running 64-bit Vista?

Hi,

   It will not work full stop in vista, I can't inject anything into any infopath form. If I use a form that has been created on an XP machine none of the command buttons will work in that infopath form.

I am using infopath 2007 with the latest updates, my vista install in 64 bit edition doubt that will make a difference and also has service pack 1 installed.

 Darren

Hi Darren,

Currently, there's been a known issue in qRules not working in Vista 64-bit. We are working on how to resolve this issue and will be posting updates to the site as soon as we do.

Thanks,

I'm running Server 2008 (64 bit), VS 2008, InfoPath 2007, and qRules 1.8, and I'm trying to 'Inject' a pretty simple form with the Qdabra Riles Library. I've tried using both the cablib.dll (32 bit version, size= 120 Kb) and the cablib.dll (64-bit version, size 249 Kb) in both the qDabra directory and the in the WSPbuilder directory.  I've added the 64-bit version cablib version to the GAC, and I still get the following error message:

 Could not load file or assembly 'CabLib, Version=6.9.26.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.

 Admittedly, I'm new to .NET platform, but what don't I get here? I'm trying to follow the example on http://claytoncobb.wordpress.com/2009/08/03/infopath-copy-sharepoint-list-data-to-main-data-source/, and I'm stuck at " After a successful install, Inject qRules 1.7 into the form template (Fig 10)"

Thanks in advance for any assistance.