InfoPath Dev

Can I attach .png files so you can see the screenshot I was referring to? I attached it earlier but it looks like you only saw my .xsn file. I'm re-attaching the .png file here, where you can see I get hundreds of blank records; a few before the first record and many after the last record. The form prompts the user to enter in an ID from a ...

I think I see where you put the conditional formatting. It's a rule called 'Hide for Blank'. Note that I do not want to hide the control. the repeating table you added does bring back the five rows I need, but the table shows blank records before the first value, and hundreds of blank records after the last value. If you look at ...

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 ...

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, ...

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 ...

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 ...

Thanks for the quick response

Hello, I am totally new to Infopath. I am using it to retrieve data from sql server. My result set for one field consists of more than one row, but the text box i display the results in is only showing the first row. Is it possible to get the additional records to show in the box? The maximum number or records would be less than 10 rows. ...

Hello, I am totally new to infopath. I have one .xsn file that has two views. The user fills out the fields in viewA and I have a button that then switches them to viewB. On viewB I have a submit button to email the form. It works except that only viewB appears on the email even though I start out on viewA and then go to viewB. Is there a way ...