InfoPath Dev

Sorry...IP 2007 and OL 2007.

Hello, Check out this link, http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/973e3546-3f52-4d1e-b370-6af79a4c3c53/

Yes, it would be nice if you could populate static text from a secondary data source just like that, but I'm afraid that there's no way to copy repeating data without code.  Anyway, good luck with the method I described, and let me know if we should start exploring other options.

I had put that rule in because I wanted to test a data connection to an external Access Database that i couldn't get to work.  hopeing to populate those static text boxes with the data from the database.  it never really works for some reason.  maybe i'm not doing it the right way.  other than that yes, my original ...

thanks Swathi, any solution to it? Experts, please help.

This code is actually at the top of my file.  It is only called once, and since YeastStorage is the only variable I use again (and actually I am not even using that right now), I store that globally, and discard the rest.  The delete line does not need to be in there...it crashes with or without it, I just wanted to see if that ...

Wow.  You have more categories than I remembered.  Unfortunately, the simplest way to populate it without using code is to enter the values by hand.  I'll show you the steps for how to do that here, but if it's just too many rooms we can look at other options. Before that, I noticed that there is a rule on the room ...

You can autopopulate a text box, too. For example, if you had a field called 'Area' and a data source that related areas to quantities, you could set a rule on your areas field to fill the Quantities field based on the selected area. While this blog post refers to a drop down list selection, the same logic would work with other controls.

The names are static, the only variables would be in the quantities, unit areas and comments.  It is also nice that it's repeating since there maybe some additional rooms added.  I've got someone working on converting the excel into an access database now, but I haven't been successful in populating the form with ...

If your room names and areas change often, you might find it easier to use a database like Access or SQL Express (which is the free version of SQL from Microsoft -- I like it better than Access). If they are pretty static, you can either type in manually the entries for a drop down list control, or create xml files that you can use as a secondary ...