tag:blogger.com,1999:blog-251400077565768187.post3297671833987481321..comments2023-08-24T13:53:19.846+01:00Comments on Good Coffee Good Code: Pivot API for .NetChris Arnoldhttp://www.blogger.com/profile/12035328858973447091noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-251400077565768187.post-62942292128990227932014-01-22T09:43:06.305+00:002014-01-22T09:43:06.305+00:00PivotGrid C# API for .NET<a href="http://www.kettic.com/winforms_ui/pivotgrid.shtml" rel="nofollow">PivotGrid C# API for .NET</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-30124465852499122162011-01-27T22:11:02.711+00:002011-01-27T22:11:02.711+00:00sorry i figured it out. thanks. and sorry for all ...sorry i figured it out. thanks. and sorry for all the posts.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-51179067255524661872011-01-27T20:14:17.733+00:002011-01-27T20:14:17.733+00:00sorry. my xml was removed in the above post. encod...sorry. my xml was removed in the above post. encoding="utf-8 works. encoding="Windows-1252" does not. can i modify this? from the consol app? or i do i need to open up the src? thanks cpAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-25117835827865910082011-01-27T20:12:15.945+00:002011-01-27T20:12:15.945+00:00thanks so much. next question. :)
the cxml i get o...thanks so much. next question. :)<br />the cxml i get outputed from your code starts with<br /><br /><br /><br />encoding="Windows-1252" is breaking my pivot app.<br /><br />if i modify the file and change it to <br /> it works.<br /><br />is there a way for me to make this change with opening up your source and manually changing it?<br /><br />thanks!!!<br /><br />you rawk!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-3116143257649662372011-01-26T19:27:51.193+00:002011-01-26T19:27:51.193+00:00Hi hellocole2,
Once we have build the collection ...Hi hellocole2,<br /><br />Once we have build the collection we utilise 2 other classes in order to save the data to an xml file. In the Main() method you can see that we new-up an XmlTextWriter object and pass in the filename to the constructor (I have omitted the full path for brevity). Once we have this writer we can then new up a PivotCollectionXmlWriter object which will correctly serialize the collection to the writer. Hope that helps?<br /><br />ChrisChris Arnoldhttps://www.blogger.com/profile/12035328858973447091noreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-62819479589320570112011-01-26T18:02:21.908+00:002011-01-26T18:02:21.908+00:00Where does it write the cxml file to? i do not und...Where does it write the cxml file to? i do not understand.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-55423740567292082010-08-20T21:39:17.837+01:002010-08-20T21:39:17.837+01:00Having written similar code recently, I noticed th...Having written similar code recently, I noticed that the viewer is intolerant of empty elements and attributes, so you'll probably need to modify the writers. E.g., <br /><br />if(!string.IsNullOrEmpty(item.Description)) Writer.WriteElementString("Description", item.Description);William Storagehttps://www.blogger.com/profile/06380505163842301069noreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-75333372795162565072010-07-06T04:16:08.982+01:002010-07-06T04:16:08.982+01:00Wow! This is was really helpful.
To make it work ...Wow! This is was really helpful.<br /><br />To make it work I had to change NumberFacet.cs:<br />public override string ToString()<br />{<br /> return Value.ToString(CultureInfo.InvariantCulture);<br />}<br /><br />And DateTimeFacet.cs:<br />public override string ToString()<br />{<br /> return Value.ToString("s");<br />}Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-251400077565768187.post-55574231696786193442010-05-25T10:45:22.847+01:002010-05-25T10:45:22.847+01:00Hi Chris,
I am trying to figure out if Pivot make...Hi Chris,<br /><br />I am trying to figure out if Pivot makes sense for Business Intelligence. My problem is the impossibility (since each item has only one occurrence) to slice and dice through the data. Maybe it is possible to solve the problem by regenerating the cxml file dynamically. <br /><br />Best<br /><br />fabio.annovazzi@gmail.comUnknownhttps://www.blogger.com/profile/10043812566980007142noreply@blogger.com