Hi,
I want to make a layout for my pivot and user will not put rows columns filters everytime when he run the application.(I want to use Flat Data)
First i tried Deffer Update nothing happens then i wrote my SQL Table's entity names which are measures in the initial item field.
I edited measure field : Price, Sum of items, (each measure have to ',' if you want to see 2 or more measure)
I tried to make the same as measure to ROW, COLUMN, FILTER fields but it doesnt work, i also edited only 1 item without ','
And is it possible to COUNT, MAX, MIN, AVG to measures with flat data?
There is no sample for preparing a layout with flat data and lightswitch help is not enough in help docs.This is a web app.
Hello,
In order to load everytime some initial fields you should set the Intial values in the properties of the Infragistics Pivot Grid control. There are Columns, Rows, Filters, Measures textboxes where you could set initial values. The format that you do this is like it follows: [Date].[Calendar], [Sales Territory].[Sales Territory] . Here the comma ',' separates the items.
Currently Count, MAX, MIN are not as well as the totals are not supported. You can fill out are form for a Product Idea here: http://devcenter.infragistics.com/SignIn/SignIn.aspx?ReturnUrl=%2fProtected%2fRequestFeature.aspx
Best regards,
Anatoli
Thank you Anatoli
I wrote as you said to row [EML_PORTFOYs].[GMTipi] but bothing happened. I tried [EML_PORTFOYs(item)].[GMTipi] which is databinding property of item no result. If i can put one item ill try others with comma. (2 Attached pics)
Do you have other idea?
http://s8.postimage.org/c5nqdqlf9/image.png
Hi
You have this issue because the given value of Rows/Columns is not discoverable.
In Columns or Rows fields try to fill you property name in the following format. If your's property is called Customer, in Rows/Columns you should write [Customer].[Customer].
Best Regards,
OK DONE:)
I have some big numbers in data, how can i change their format?
Ex: 2650000,00 to 2.650.000,00
Hello serseriyim,
I have sent your Product Idea directly to our product management team. Our product team chooses new Product Ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your friendly ID for this Product Idea is PI12070046.
If you would like to follow up on your Product Idea at a later point, you may contact Developer Support management via email. Please include the reference number of your Product Idea in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com
Thank you for your request.