InfoPath Dev

Thanks but I downloaded your attachement and tried to test it out. When I click on preview, my data connections to SQL server no longer work. I closed out of your attachment and opened my version, and it no longer works either. I don't get any error messages, but when I click on Preview I do get the prompt to connect to the database, but I ...

On the repeating table, add conditional formatting to hide if the field is blank. See attached.

Hello, I am totally new to Infopath. I developed a form and I would like to create a button where the user clicks on it and the form is downloaded to their PC in PDF format. I understand this is possible, but do I need to write code? do I need to download some other software to do this? Thanks for any assistance. Lou

Thank you. Your solution brings repeats the records hundreds of times and also brings back hundreds of blank records. I modified your .xsn to filter the formula on the metric_code from the data connection, which is field32 in my group. This does retrieve the five rows I am expecting, but it creates a few blank values before the first record, ...

I put a repeating table with a single column, a calculated value, and the header and borders removed at the bottom of the view in this copy of your form. I also included some info on what I did. This is the approach I'd take rather than using a formula.

Thanks. The result set would just have one column. There are other fields that will have multiple rows, but I was hoping to figure it out for this one and then I'll do the others. I added a repeating section towards the bottom of the Modify Metric view to test this out, and dragged the field from the SQL data connection onto the form. It ...

So - in my sample form, I just used a repeating table to show you how a double eval works. In your form, the formula would change - feel free to attach your form to a reply if you need a hand. You can attach the form under the options tab in a reply. Does your returned data only have one column? Or are there multiple columns? Personally, I'd ...

Thanks for the info. This form is running a sql query and returning the result set to the form. I do not need to enter rows onto the form; i just need to display the sql results. There are a few fields that have more than one record and it would be easiest (if possible) to display the multiple rows (never more than 8) in a text box. Do I add ...

I would just use a repeating section for this - is there a reason all the data needs to be in the same text box? I mean, you could use double eval for this - see attached sample. Right click the link in the heading, save the file locally. Right click the saved file, and select design to open in design mode, then you can preview.

Thanks for the quick response