InfoPath Dev

Hi,

I was very excited on the prospect of displaying Charts on an InfoPath after seeing this video

https://channel9.msdn.com/Blogs/donovanf/InfoPath-2010-and-Creating-a-Form-that-Consumes-a-REST-enabled-WCF-Service

I jumped up & down when I got my first chart on the form. That party came crashing when I realized the URL length limits at 255 chars.

I use an Excel chart model and passing values from another data source to graph.

I looked all over to find out the way to bypass, but doesn't look like I could. So now I have to ration the naming and ranges.

I created SD folder in lieu of Shared%20Documents 

EC.xlsx for ExcelCharts.xlsx

CB for ChartBudget etc

My QUESTION: is there way to cut down the repeating of 'ranges'?

For example:

https://server/_vti_bin/excelrest.aspx/SD/EC.xlsx//model/Charts('CB')?Ranges('A1')=2018&Ranges('A3')=2019....

I would like to combine to something similar to this: Ranges('A1|A3|A5')=2018,2019,2020

Is it POSSIBLE? Please show me a miracle :)

 PLEASE!!??

Sorry - I don't really know of a way to do this. Is the sample you are showing representative of your actual data? Could it be the user could just pass in a start year, and you could use formulas in Excel to populate additional fields with that year incremented?

It's not possible as we are not setting values back to Excel WB in SP. There is no data connection and we use Excel REST service to just use the Chart model and the model graphs on the value we pass in the URL. So it could gets lengthy, but the linked Image only read upto 255 chars.

The simplified sample is representative of actual. I have seen reference of multiple range name in 1 ranges(). Example: Ranges('A1'|'A3') etc, but I don't know how to assign the values. Ranges('A1') = 1000 is easy, but Ranges('A1'|'A3') = ? how to assign 1000 to A1 and 2000 to A3 is the issue. No luck on my end in term of that.