GrapeCity Forums

RussCam Episode 58: Part 3 - SQL Saturday #133 Costa Rica

rfustino — Fri, 11 May 2012 21:34:03 GMT

Anyone who has met the Devfish himself, Microsoft Developer Evangelist, Joe Healy, will absolutely love this video. Even if you have not met Joe, it’s vintage Joe, who finally gets his moment in the spotlight on Russ Cam! The opening is definitely a side splitter! Awesome job Joe! It's the final episode from Costa Rica, SQL Saturday 133 at perhaps my favorite!

First Russ talks with MS MVP Salamon Henriquez about the big event in Costa Rica. Then, we talk with two speakers from SQL Saturday 133, Solid Quality Mentor’s Javier Loria and SQL Server MVP Jesus Gil. They tell us about their unique role playing session using Tacos. Then (drum roll...) it's the DevFish himself, Joe Healy who is very excited about what he just witnessed in the strong developer and database community in Costa Rica and predictions for an even larger event next year, perhaps 600 people! And Jeff Zwickol is back with his summary of the SQL Saturday. Finally, Wes Dumey makes a return appearance on Russ Cam. Watch until the end for photos and outtakes! In these outtakes, we complete our journey to Jaco Beach with crocodiles along the way and a incredible sunset over the pacific. HAPPY COSAT RICA Day!

CLICK here to watch video!

Joe Healy Episode – Vintage Devfish.
Captions available in Spanish! Los títulos disponibles en español!
Raw Link: http://gvtv.gcpowertools.com/#russcam58

Nice shot of Nizar Lavji, President Vista Technologies , with plane and great sunset.

My prize photo of a Jaco Beach Sunset! The island mountain on the horizon only is visible with the sun setting directly behind it.
I talk about this sunset as it is happening in this episode.

Javier Loria and SQL Server MVP Jesus Gil

RussCamTV, Russ Fustino, with MS MVP Salamon Henriquez holding .NET Gurus Can Cook!

More Photos of SQL Saturday 133 Costa Rica

More Photos of Costa Rica trip to Jaco Beach

Technorati Tags: Jeff Zwickel,SQL Saturday 133,sql saturday,www.sqlsaturday.com,SQL,GrapeCity powertools,sharepoint,idera,Alex Funkhouser,Russ Caaaaaam,Joe Healy,Keith Kabza,Yuri Porras,Eduardo Castro,SQL Server MVP,Jorje Aguilar,Stephen Purkiss,Sherlock Technology Recruiting,Nizar Lavji,Javier Loria,Jesus Gil,Salamon Henriquez

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/11/russcam-episode-58-part-3-sql-saturday-133-costa-rica.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

RussCam Episode 57: Part 2 - SQL Saturday #133 Costa Rica

rfustino — Thu, 10 May 2012 22:34:41 GMT

Russcam has more from SQL Saturday 133 in Costa Rica! First, I chat with Jeff Zwickel about what he's up to plus his thoughts on SQL Saturday Costa Rica! Then, we briefly catch Stephen Purkiss on Russ Cam! He's the Chairman at Sherlock Technology Recruiting. And Nizar Lavji tells us all about the work he does as President of Vista Technologies. Keep watching until the end for all of the outtakes and photos including a trip to Jaco Beach with Joe Healy, Keith Kabza, Alex Funkhouser and more! Find out how Sugar Cain juice is made!

CLICK here to watch video!

Stephen Purkiss and Jeff Zwickel
Captions available in Spanish! Los títulos disponibles en español!
Raw Link: http://gvtv.gcpowertools.com/#russcam57

Nizar Lavji, President Vista Technologies

Nazir, Jeff, Alex, Fruit Stand owner, Joe, Wes, Henry, and Russ. The mango was delicious!

More Photos of SQL Saturday 133 Costa Rica

More Photos of Costa Rica trip to Jaco Beach

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/10/russcam-episode-57-part-2-sql-saturday-133-costa-rica.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

RussCam Episode 56: Part 1 - SQL Saturday #133 Costa Rica

rfustino — Thu, 10 May 2012 21:49:18 GMT

Russ Cam is taking you to Costa Rica for SQL Saturday 133! First, we'll talk with Eduardo Castro, SQL Server MVP, keynote speaker and organizer of SQL Saturday 133! Then, Jorge Aguilar tells us about the new Sharepoint solutions at Idera. And wouldn't you know it...Alex Funkhouser makes yet another appearance on Russ Caaaaaam, along with Joe Healy, Keith Kabza and Yuri Porras, representing Microsoft in Costa Rica! Watch until the end for photos and outtakes!

CLICK here to watch video!

Eduardo Castro, Conference organizer
Captions available in Spanish! Los títulos disponibles en español!

Raw Link: http://gvtv.gcpowertools.com/#russcam56

Jorje Aguilar of Idera

Yuri Porras, Microsoft DE, was a bit hit!

More Photos of SQL Saturday 133 Costa Rica

Technorati Tags: SQL Saturday 1333,sql saturday,www.sqlsaturday.com,SQL,GrapeCity powertools,sharepoint,idera,Alex Funkhouser,Russ Caaaaaam,Joe Healy,Keith Kabza,Yuri Porras,Eduardo Castro,SQL Server MVP,Jorje Aguilar

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/10/russcam-episode-56-part-1-sql-saturday-133-costa-rica.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

ActiveReports Developer 7 Beta 2 Now Available!!!

ActiveReportsTeam — Thu, 03 May 2012 20:57:23 GMT

The ActiveReports Developer 7 team is proud to release the second beta build to the public. This build includes fixes for numerous issues that were reported internally, as well as a new CharWrap mode for use with East Asian languages.

The new build can be downloaded from our download site: ar7-beta-7.0.4439.0.zip (80MB).

GrapeCity Spread WPF-Silverlight CTP2, now with a Go Live License! Part 15 – Resources

rfustino — Wed, 02 May 2012 23:54:58 GMT

It’s an exciting time! Spread WPF-Silverlight is now CTP2 with a go live license!

Contact sales at PowerSales@GrapeCity.com to purchase your Go Live license today.

Click here for a WPF-Silverlight evaluation copy

Visit http://www.gcpowertools.com/Products/SpreadWPFSilverlight/Overview for some amazing UI abilities in Silverlight and WPF. Wow!

This is the final blog post in a 15 part series on Spread WPF-Silverlight CTP…

Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding
Part 11: Drag and Move
Part 12: Drag and Fill
Part 13: Edit Mode and Frozen Columns
Part 14: Row Filter

Spread WPF-Silverlight

Spread is an embedded spreadsheet platform component for application development.
Spread WPF-Silverlight includes a WPF spreadsheet control and a Silverlight spreadsheet control.
These controls address use cases best solved using cell-based, free-form, gridded layouts.
Spread WPF-Silverlight includes rich designer to simplify development and produce quick results.

Features:

AutoFit - Set Row height and Column width to the minimum size needed to include all the text for every cell in the row or column.
Cell Formatter - Format numeric data in a cell to a specified Excel-style format string.
CellOverflow - Allow cells data to overflow from a cell into adjacent, empty cells.
Cell Span - Merge a range of cells into a group that is displayed as a single cell.
Clipboard - Cut, Copy, Paste, Paste Special.
Conditional Format - Apply custom styles to cells whose values meet specific conditions or rules.
- Average Rule - compare cell values to the average of a specified range.
- CellValue Rule - compare cell values to another value.
- DateOccuring Rule - compare cell values to a date range.
- Formula Rule - evaluate a formula.
- Scale Rule - compare cell values to scale values of a specified range.
- Top10 Rule - compare the cell value to the top 10 or bottom 10 of a specified range.
- Unique Rule - whether the cell value is unique for a specified range.
Text & CSV File Import and Export - Load and save Text (txt) and CSV (comma-delimiited) files.
DataBinding
DragMove
Editing Always
Fill
Filter
Freeze Heading & Trailing Rows & Columns
Grid Line & Border
Html_Export FeaturePoint
Input Mapping
Multiple Header
Navigation
SavePDF
Cell Lock & Worksheet Protection -
Range Group - Excel style grouping.
Resize
Scrolling
Search
Selection
ShrinkToFit
Sparkline
StyleInfo
Table
TabStrip
Theme Manager
UndoRedo
View port
Zoom

On a personal note, I would like to wish Robby Powell the best of luck in his new endeavors and many thanks for all of the Spread management, support and love over several years! You will be missed but not forgotten! Best wishes!

Technorati Tags: Spread,Excel,Silverlight,CTP,labs@grapecity.com,visual studio,AutoFit,borders and Grid lines,cell format,cell overflow,cell span,clipboard,clipboard operation,conditional formatting,CSV,CSV Import and Export,data binding,drag and move,drag and fill,edit mode,frozen columns and rows,row filter,go live,ctp2

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/05/02/grapecity-spread-wpf-silverlight-ctp2-now-with-a-go-live-license-part-15-resources.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

Introduction to Fixed Page Layout–Part 3

ActiveReportsTeam — Fri, 27 Apr 2012 17:49:00 GMT

Welcome to the last post in this short series on Fixed Page Layout in ActiveReports Developer 7. There is more to come in the future about ActiveReports Developer 7 though.

Overflow is an important concept in FPL reports, and a powerful feature is the ability to decide where to put it. Overflow occurs whenever the content in a data region grows beyond what can fit in the area allotted by the data region's FixedSize property. Once the content overflows, the reporting engine looks to see what it should do with the rest of it. It takes direction from the OverflowName property on each data region.

If the property isn't set then it just uses the same page over again to display the additional data. If it is set, then it begins filling the designated OverflowPlaceHolder on the report with additional data. Once the OverflowPlaceHolder is filled, it repeats the process, looking for the appropriate placeholder to fill. Using the OverflowName property and the OverflowPlaceHolder control you can create sophisticated layouts easily.

Overflow Example

To demonstrate, we'll create a simple report which uses overflow to fill up two columns on one page, and an additional page that uses a slightly different layout. This report will contain inventory data and a place for someone to write down the actual count. We'll start by creating the report and gathering the data.

Create a new Page report, and in the Report Explorer, right click the Data Sources node and select Add. Check the "Shared Reference" box and browse to the Reels.rdsx. This adds DataSource1 to your Report Explorer. Right click on DataSource1 and choose Add Data Set. Go to the Query page and use the following query: SELECT * FROM DVDStock

Our data is somewhat wide, so we'll set the left and right margins to 0.5in.

Adding the controls

Drop a table onto the report and drag the Title and InStock fields into the first two columns. In the last column we'll put a series of underscores that will be the line for the stock people to write on. Resize the columns as needed to show the data. I found 2.5in, 0.625in, and 0.5in worked well. Place the table against the left margin and position it high on the page. Set the FixedSize Height property so that it fills the page.

If we preview the report right now, you'll see that we get this same page repeated over and over again with our additional data displayed. One thing that is missing is the table header on each subsequent page. To add it, select the table header and set the RepeatOnNewPage property to True.

Now according to our design, we wanted a second column for the data; this is easy to add. Drag an OverflowPlaceHolder to the right side of the report and align it with the table. On the table, set the OverflowName property to OverflowPlaceHolder1. Once you do this, the placeholder resizes itself. Reposition it on the page if you need to. That is all we need to do to create the second column!

Lets add a header to this report and then we're done with this page. Drag out a textbox and set the text to Inventory Report and make it fairly large for the title. You can also add a Page N of M to the top. If you preview the report now, you'll find both columns filled; but we are still using this same page over and over again. We already know that this is the inventory report, so we don't need to repeat it on each page. Let’s design a new page without this header.

Creating the second page

At the bottom of the designer is the page bar. Right click on Page 1 and choose Duplicate. Duplicate takes the page you are duplicating and copies its contents, replaces any data regions with OverflowPlaceHolder controls, and then hooks those placeholders up in the chain. The result is that all we need to do is remove the header info we don't want, and make both overflow placeholders taller. Now we can preview the report and get a unique first page design with all subsequent pages having the second design.

Themes and Collation

In ActiveReports Developer 7 we've revamped our theme support from Data Dynamics Reports, changing the way colors are used, and we added a new feature, the ability to add constant strings to the theme.

What is the use of a constant string in the theme file? Well, we also added the ability to have multiple themes in a single report that you can use one after the other to produce replicated forms that differ only in styling or static text. You may have seen this before where a delivery driver has nearly identical slips: one for you, one for him, and one for the office. So with the new collating feature you can print out these delivery slips or other multi-copy documents from a single report!

We'll create a basic report which uses this feature to create the delivery slips we mentioned earlier.

Example

Download the XML data file here. It contains the orders for our three stops in the delivery truck where we are carrying snacks and frozen dinners to stores.

Create a new Page report, and set the page margins to 0in and the page size to 4.5in x 3.5in. In the Report Explorer, right click the Data Sources node and choose Add Data Source. Under the Type dropdown, specify the "Xml Provider" and in the Connection String box type: XmlDoc=path to file\orders.xml

Click OK to accept our data source and close the dialog. Right click on our newly added data source and choose "Add Data Set." Data sets in an XML data source use XPath to pull the data out of the file. Set the query string to the XPath query which will return the elements you wish to work from (one element per "row" of data) and then the fields are constructed via additional XPath expressions to pull the individual items from the elements returned.

Set the query string to: //orders/order/items/item

Go to the Fields page and add the following fields:

Field Name	Value
OrderID	../../@id
Name	../../address/name
Address	../../address/street
City	../../address/city
State	../../address/state
ZIP	../../address/zip
Item	@item
Count	number(@count)

Click OK to accept our list of fields and close the dialog.

Now that our data is set up we can begin constructing our report. Drag out the Name, Address, City, State, and ZIP to form a nice address header near the top of the report. Now add a table and put the Item and Count fields in it, sizing the table appropriately. If you right click on the rightmost column header you can remove it so it is just the two columns.

Set the table's FixedSize property so that it takes up most of the page, but leave room for a textbox at the bottom. This textbox will tell the driver which of the three copies they are looking at; we'll add that in a bit. Finally, we need to set up fixed page grouping.

Click the white background of the report and at the bottom of the property grid click the “Property dialog” command. On the Grouping page, click in the "Group On" list and select the OrderID field.

If you preview the report now you will see three pages in the report, one for each of the customers and their orders.

Now for the fun part! We're going to create a theme to set the background color of the report (since we're not really printing it) and in the theme we'll also specify which copy of the report this is for.

On the Report menu, select Report Properties. Go to the Themes page, and click the New button on the toolbar. This launches the theme editor. We'll use Accent 1 as our background color so click on that color box and choose White. Since all we're interested in is this one color and the text, go ahead and go to the Constants tab.

In the Name column, type "Copy" and in the Value column, type "Customer." When we are using this theme, the Copy value will contain Customer. Click OK to exit the theme editor and save the theme.

Now we'll do the same thing again, only this time choose a faded yellow color for Accent 1 and specify "Driver" as the value for "Copy" on the Constants tab. Click OK to exit the theme editor and save the theme.

Finally, once more but choose a faded pink color for Accent 1 and specify "Office" as the value on the constants tab. Once again, click OK and save the theme.

Now that we have our themes, its time to apply the values.

Click on the white background of the report (if your report has margins you need to click in the middle of the report and not on the margins of the page) and specify your background color, in this case click the 3rd icon in the drop down to switch to the themes page, select Accent1 here or you can type in the expression: =Theme.Colors!Accent1

Next add a textbox to the bottom of the report in that space we saved before. Set its value to: =Theme.Constants!Copy

If we preview the report now we'll have three copies of the slips. However, if you run through the pages you'll see that you get all of the Customer copies first, followed by Driver copies, and finally the Office copies. What if you want each order to print its Customer, Driver, and Office copies together? Fortunately this is easy to do with the Collate option. In the Report Explorer, click on the Report node at the very top, in the property grid you'll find the Collate property. If you change this to "Value" you'll now get each order's slips printed together!

I've provided my copy of the example files here, it contains some spruced up versions of the reports we created today as well as pre-defined theme files if you don't want to create them manually.

Well, that's it. We've covered a lot of things in FPL but there is much more available in ActiveReports Developer 7. Check back soon for the next post in the "What's New in ActiveReports Developer 7" blog series, or subscribe to our RSS feed to stay up to date. Next time, we'll look at what's new in the Windows Forms Viewer control.

GrapeCity Spread Silverlight CTP, Part 13 – Edit Mode and Frozen Columns and Rows

rfustino — Fri, 27 Apr 2012 15:24:54 GMT

Spread CTP - Script 13: Edit Mode and Frozen Columns and Rows

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 13^th in a series of Spread CTP Blogs and is a continuation of:

Edit Mode Always

If you are interested in downloading the Spread CTP 2 with a go live license, please email labs@grapecity.com .

You can set the cell to always be in edit mode when the user clicks on it. Normally the user types or double-clicks before the cell goes into edit mode.

Set the StartCellEditing method in the EnterCell event to cause the cell to go into edit mode as soon as the user clicks on or uses tab or enter to move to the cell.

Frozen Columns and Rows Feature

You can specify whether you want frozen rows or columns or both in a sheet. Frozen columns and rows do not scroll. You can also specify whether to have frozen trailing rows or columns. A line is displayed below frozen rows (or above frozen trailing rows) and to the right of frozen columns (or to the left of frozen trailing columns).

Frozen rows stay at the top of the sheet and frozen columns stay on the left of the sheet. Frozen trailing rows stay at the bottom of the sheet and frozen trailing columns stay on the right of the sheet.

Using Code

CS
gcSpreadSheet1.Sheets[0].RowCount = 10; gcSpreadSheet1.Sheets[0].ColumnCount = 8; gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1; gcSpreadSheet1.Sheets[0].FrozenRowCount = 1; gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1; gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1; gcSpreadSheet1.Invalidate();
VB.NET	Copy Code
GcSpreadSheet1.Sheets(0).RowCount = 10 GcSpreadSheet1.Sheets(0).ColumnCount = 8 GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1 GcSpreadSheet1.Sheets(0).FrozenRowCount = 1 GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1 GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1 GcSpreadSheet1.Invalidate()

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/27/grapecity-spread-silverlight-ctp-part-13-edit-mode-and-frozen-columns-and-rows.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 14 – Row Filter

rfustino — Thu, 26 Apr 2012 14:40:00 GMT

Spread CTP - Script 14: Row Filter

If you are interested in downloading the Spread CTP2 with a go live license, please email labs@grapecity.com .

This is the 14^th in a series of Spread CTP Blogs and is a continuation of:

You can hide filtered rows. A filter button is displayed in the column header for a column that allows filtering. The user can click on the button and select the item they wish to filter by and they can sort the list of items.

The following image displays the filter dialog.

The user can use the mouse or various keyboard keys to interact with the filter dialog. The ESC key can be used to cancel the dialog. The TAB key can be used to move to different sections and the up and down arrow keys can be used to move in the list of items. The SPACEBAR can be used to change the checked status.

The following image shows the list sorted in ascending order.

Using Code

CS
GrapeCity.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1); GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange); gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;
VB.NET
Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1) Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange) GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter GcSpreadSheet1.Invalidate()

Spread, Excel, Silverlight, CTP, labs@grapecity.com , visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill, edit mode, frozen columns and rows, row filter

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-14-row-filter.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 12 - Drag and Fill

rfustino — Thu, 26 Apr 2012 14:26:00 GMT

Spread CTP - Script 12: Drag and Fill

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 12^th in a series of Spread CTP Blogs and is a continuation of:

GcSpreadSheet has a drag fill option that allows the user to select cells and fill other cells with the same or different values. The fill type can be set to linear, growth, date, or automatic fill. The fill direction can also be specified. Additional options can be set such as step and stop values.

Select a cell or block and move the mouse pointer over the square at the corner of the selection. The mouse pointer changes to a double arrow that can be used to expand the fill range. Click on the plus mark to display a menu with additional fill options as shown in the following image:

Drag fill is not supported if the destination range contains a spanned cell. Drag fill does not apply to a conditional format or filtered range.

The AllowDragFill property is used to specify whether to allow drag fill. The FillAuto Method, FillDate Method, FillGrowth Method, or FillLinear Method can be used to programmatically specify the type of fill.

Using Code

CS
gcSpreadSheet1.AllowDragFill = true; gcSpreadSheet1.Sheets[0].SetValue(0, 0, new DateTime(2011, 1, 1)); gcSpreadSheet1.Sheets[0].SetValue(0, 1, new DateTime(2011, 2, 9)); gcSpreadSheet1.Sheets[0].SetValue(0, 2, 5); gcSpreadSheet1.Sheets[0].SetValue(0, 3, 10); gcSpreadSheet1.Sheets[0].SetValue(0, 4, 1); gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e) { GrapeCity.Windows.SpreadSheet.Data.CellRange r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1); gcSpreadSheet1.Sheets[0].FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2); GrapeCity.Windows.SpreadSheet.Data.CellRange r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1); gcSpreadSheet1.Sheets[0].FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, new DateTime(2011, 2, 11).ToOADate()); GrapeCity.Windows.SpreadSheet.Data.CellRange r3 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1); //gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down); gcSpreadSheet1.Sheets[0].FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column); GrapeCity.Windows.SpreadSheet.Data.CellRange r4 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1); //gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column); //gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2); gcSpreadSheet1.Sheets[0].FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55); GrapeCity.Windows.SpreadSheet.Data.CellRange r5 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1); //gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column); //gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3); gcSpreadSheet1.Sheets[0].FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20); gcSpreadSheet1.Invalidate(); }
VB.NET
GcSpreadSheet1.AllowDragFill = True GcSpreadSheet1.Sheets(0).SetValue(0, 0, New DateTime(2011, 1, 1)) GcSpreadSheet1.Sheets(0).SetValue(0, 1, New DateTime(2011, 2, 9)) GcSpreadSheet1.Sheets(0).SetValue(0, 2, 5) GcSpreadSheet1.Sheets(0).SetValue(0, 3, 10) GcSpreadSheet1.Sheets(0).SetValue(0, 4, 1) GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 4, 1) GcSpreadSheet1.Sheets(0).FillDate(r, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 2) Dim r2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 1, 4, 1) GcSpreadSheet1.Sheets(0).FillDate(r2, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, GrapeCity.Windows.SpreadSheet.Data.FillDateUnit.Day, 1, New DateTime(2011, 2, 11).ToOADate()) Dim r3 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 4, 1) 'GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillDirection.Down) GcSpreadSheet1.Sheets(0).FillAuto(r3, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column) Dim r4 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 3, 4, 1) 'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column) 'GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2) GcSpreadSheet1.Sheets(0).FillGrowth(r4, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 2, 55) Dim r5 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 4, 4, 1) 'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column) 'GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3) GcSpreadSheet1.Sheets(0).FillLinear(r5, GrapeCity.Windows.SpreadSheet.Data.FillSeries.Column, 3, 20) GcSpreadSheet1.Invalidate() End Sub Part 13 : Edit Mode and Frozen Columns and Rows

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-12-drag-and-fill.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 11 - Drag and Move

rfustino — Thu, 26 Apr 2012 14:18:00 GMT

Spread CTP - Script 11: Drag and Move

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 11^th in a series of Spread CTP Blogs and is a continuation of:

The user can use the mouse to select a cell or block of cells and move them to a new location. Move the mouse pointer to the edge of a selected column, row, or block of cells and then click and drag the selected range to the new location.

The following image displays a selected block of cells with the drag icon:

Move the block to the new location.

Release the mouse to display the data in the new location.

You can select and drag multiple contiguous columns or rows.

Using Code

CS
gcSpreadSheet1.AllowDragDrop = true;
VB.NET
GcSpreadSheet1.AllowDragDrop = True

Part 12: Drag and fill

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-11-drag-and-move.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 10 - Data Binding

rfustino — Thu, 26 Apr 2012 14:02:07 GMT

Spread CTP - Script 10: Data Binding

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 10^th in a series of Spread CTP Blogs and is a continuation of:

GcSpreadSheet supports binding to any object that implements the IEnumerable interface. This includes the Ilist, ObservableCollection, and WCF datasource. The control also supports binding to an RIA datasource.

GcSpreadSheet supports one way data binding. Changes to the source automatically update the target but, changes to the target are not propagated back to the source.

Specific columns can be bound with the DataField Property.

Using Code

CS
public class lname { public string last { get; set; } public int val { get; set; } public lname(string last, int val) { this.last = last; this.val = val; } } private void Window_Loaded(object sender, RoutedEventArgs e) { lname[] arr = new lname[] { new lname("Smith", 100), new lname("Fender", 3), new lname("Gill", 5) }; gcSpreadSheet1.Sheets[0].DataSource = arr; gcSpreadSheet1.Invalidate();
VB.NET
Public Class lname Public Property last() As String Get Return m_last End Get Set m_last = Value End Set End Property Private m_last As String Public Property val() As Integer Get Return m_val End Get Set m_val = Value End Set End Property Private m_val As Integer Public Sub New(last As String, val As Integer) Me.last = last Me.val = val End Sub End Class Dim arr As lname() = New lname() {New lname("Smith", 100), New lname("Fender", 3), New lname("Gill", 5)} gcSpreadSheet1.Sheets(0).DataSource = arr gcSpreadSheet1.Invalidate()

Part 11 : Drag and Move

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-10-data-binding.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

RussCam 55: Part 4 of 4 - Orlando Code Camp

rfustino — Mon, 23 Apr 2012 14:48:11 GMT

This is one of my favorite episodes in large part due to the huge 500 person ‘RussCammmmmmm’ yell (largest to date!)! I talk with Windows Phone MVP, Atley Hunter about his session and a really cool app he's working on! Check out my new cameraman for this interview (hint, he's not the owner of a major pizza franchise)! Then, Microsoft MVP and RD Elijah Manor talks with me about his two sessions about jQuery. Event organizer, Esteban Garcia, takes a few moments away from his busy schedule to be on Russ Cam! And Peter Bromberg from EggHeadCafe shows us the enormous schedule for code camp, and also tells us why he's really into MVC these days. Plus, don't miss the behind the scenes photos and outtakes at the end of the video!

Raw Link:

http://gvtv.gcpowertools.com/#russcam55

Organizing committee for Orlando Code Camp.

RD’s Elijah Manor and John Papa

More Photos Photos: Orlando CodeCamp

Technorati Tags: atley hunter,Elijah Manor,jQuery,Phone 7,estiban garcia,peter bromberg,eggheadcafe,mvc,john papa

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/23/russcam-55-part-4-of-4-orlando-code-camp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

Russcam Episode 54: Part 3 of 4: Orlando CodeCamp

rfustino — Sun, 22 Apr 2012 21:38:43 GMT

Russ is catching up with the VP of ONETUG, John Smith! Then, Luis Perez from Neuralnet makes yet another Russ Cam appearance! Alexander Koval talks about his organization, Code Masters International, plus his session at Code Camp. And Jose Chinchilla talks with us about his experience with business intelligence. We wrap it up with an appearance by another Russ Cam veteran, Greg Leonardo. Don't miss the behind the scenes photos and outtakes at the end of this episode!

Raw Link:

http://gvtv.gcpowertools.com/#russcam54

Esteban Garcia and John Smith, key organizers of Orlando Code camp.

Luis Perez enjoys the session at Orlando Code Camp!

More Photos Photos: Orlando CodeCamp

Technorati Tags: Onetug,John Smith,Luis Perezm Alexander Koval,Jose Chinchilla,greg leonardo,Business Intelligence,code masters

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/22/russcam-episode-54-part-3-of-4-orlando-codecamp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

Russcam Episode 53: Part 2 of 4: Orlando CodeCamp

rfustino — Sun, 22 Apr 2012 21:19:46 GMT

We are celebrating 50+ episodes where it all started - Orlando Code Camp! I talk with the first ever Russ Cam interviewee, MVP Dave Noderer! We discuss the upcoming second edition of the .NET Gurus Can Cook cookbook! Plus, it's the debut of the Dave Cam! Then, it's a surprise interview with RD John Papa! He talks about his session and his busy week with DevConnections, Code Camp and birthday parties! Then, Scott Dorman tells us about a website that helps you make newsletters out of Twitter feeds! He also talks with us about his session as well as a new Windows Phone Marketplace Requests website. Brian Mishler, director of marketing for ONETUG, talks with us about Send2Page and also the success of Orlando Code Camp. Watch the whole thing for behind the scenes photos and outtakes!

Raw Link:

http://gvtv.gcpowertools.com/#russcam53

The best shot ever of RD John Papa holding the RussCam Hard Hat!

More Photos Photos: Orlando CodeCamp

Technorati Tags: dave noderer,john papa,scott dorman,brian mishler,send2page,phone 7,orlando codecamp,#orlandocc

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/22/russcam-episode-53-part-2-of-4-orlando-codecamp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity RussCam Episode 52, Part 1 of 4: Orlando Code Camp

rfustino — Sun, 22 Apr 2012 01:04:39 GMT

I am in Orlando for the huge Orlando Code Camp! First, I talk with Chesapeake, VA native, Kevin Griffin. Kevin is a technical evangelist for ComponentOne. He talks about his 2 sessions at Code Camp. Then, it's a return Russ Cam interviewee - Microsoft MVP Jonas Stawski! Jonas is excited about the Windows 8 Tablet consumer preview! He's talking about his session diving into the architecture of his Windows Phone 7 apps. And find out why Jonas is also excited about ActiveAnalysis from GrapeCity PowerTools! Software Coder Marek Radacz stops by Russ Cam to say hello and share an update about JAXDUG. Matt Trask tells us about a very interesting kit called FEZ Spider, the first commercially available .NET Gageteer-compatible kit! Matt does a session at the Code Camp using his FEZ Spider. Watch this episode through to the end to see outtakes and photos from Orlando Code Camp!

Raw link: http://gvtv.gcpowertools.com/#russcam52

Jonas Stawski returns to RussCamTV!!!! (Nice shirt!)

More Photos Photos: Orlando CodeCamp

Technorati Tags: componentone,activeanalysis,windows 8,jaxdug.com,fez spider,orlando code camp,Jonas stawski,Matt Trask,Kevin Griffin,Marek Radacz

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/21/grapecity-russcam-episode-52-part-1-of-4-orlando-code-camp.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

Introduction to Fixed Page Layout–Part 2

ActiveReportsTeam — Fri, 20 Apr 2012 16:00:00 GMT

Welcome to the next post in the "What's New in ActiveReports Developer 7?" series! This time we'll go from taking a 50,000 foot view of Fixed Page Layout (FPL) reports and get into the nitty gritty and create a couple of reports.

We'll start off by creating a simple report. We have the items that a customer has purchased and want to print an invoice for it. We'll be concerned with printing just a single invoice to start with, and later we'll modify this report to be able to work with multiple invoices at once.

I'm using the standalone designer that is installed alongside ActiveReports 7, however you can also use Visual Studio to create the reports.

To create a new Page report, from the File menu, select New and choose Page Report (in Visual Studio this is called ActiveReports 7 Page Report).

In the Report Explorer, right-click on the Data Sources node and choose Add Data Source.

In the dialog that comes up select Shared Reference and browse to the samples directory included with ActiveReports. Inside of the samples directory, select the Data\ReelsDataSource.rdsx file. This file contains all of the connection information to use the Reels sample database.

Click OK to accept our changes and close the dialog.

Now in the Report Explorer, right-click on our newly added DataSource1 and choose Add Data Set. On the left navigate to the Query page, and use the following SQL query.

SELECT * FROM CustomerOrders WHERE CustomerID = 1000

This will give us just the records associated with a single customer in the database. Click the OK button to accept our changes and return to the design surface.

Now that we're here we can design our invoice. We'll just do something basic here, however you can pretty up the report as much as you want. While our data contains the customer contact info, for reasons that will become clear later, we'll not put that information on the invoice for now.

We'll start off by setting our paper size. We don't have a ton of data in our invoices so we'll make our paper smaller to work around that. Click on the page grid and set the page size to 6in x 6in and the margins to 0.5in on all sides.

Now that we have our page size set, drag out a Table from the toolbox. Click one of the textboxes inside of it to trigger the display of the row and column headers. Right-click on a column header and choose Add Columns... Specify 2 and click OK. Now we have a table with 5 columns in it.

Let's start by adding our data to the cells and then we'll adjust the size of our columns to fit the data.

As you may have noticed earlier, when your mouse cursor hovers over a textbox an icon appears on the right side of it. When you click this icon, it will bring up the Field Selection menu. This menu allows you to quickly select the field you want to use in the textbox without having to resort to typing or drag-and-drop from the Report Explorer.

Besides being quick to use, it also does a couple of other things for you. It will automatically add a title to the table or matrix column, and if you are in a data scope it will automatically apply an aggregate to it.

In the middle row, select the following fields from left-to-right: Title, Quantity, Price, and Discount. In the last column we'll calculate the total, so in the last cell type:

=[Quantity]*[Price]*(1-[Discount])

Finally, type Total in the last column's header cell.

We're almost done! Now for our total and some formatting. In the bottom left cell, in the table footer, type the following expression:

=Sum([Quantity]*[Price]*(1-[Discount]))

For the formatting, select the Price cell and the two Total cells, go to the property grid and set the Format property to C (you can also use the drop-down and select Currency). Select the Discount cell and set the Format to P0 (or select Percent with 0 decimal places).

Two more things to do and we're done, I swear! First, make the title column as large as you can; don't worry the page won't resize on you. Finally, select the table, and in the property grid, find the FixedSize property, expand it and set the Height to 3in.

This last step is important. Remember when we talked about Fixed Page Layout reports in the previous post? We define a page layout and then define spaces in the report in which the data will appear. The FixedSize property is how you define how large you want the space for the table to appear for your report.

Now for that picky issue with the customer's contact information I mentioned earlier. Unlike other reporting types, in FPL the layout is king. We cannot change the way things are laid out at run time like we can with the other report types by pushing things around as report items grow. This report may wind up printed on a form, after all, and moving things is not good when you've taken the time to place items *just* right.

For this reason, the behavior of CanGrow and CanShrink isn't allowed (and are, in fact, hidden on FPL reports). But this also means that where you might have expected CanGrow or CanShrink to work, you need to anticipate that and include it in your design. The customer's contact information is one place where we need to account for this because some customers have 2 address lines, and some only have 1. This leaves us with two choices, we can put up with the blank that appears there (boo) or use an expression to conditionally output it.

We can tackle the expression in one of two ways, we can output it inline, or we can pass our data into a custom code function. If it's straightforward, I prefer to use an inline expression. However, in this case we're dealing with multiple conditionals so we'll go the route of creating a custom code function that we can call.

On the Script tab, copy and paste the following code:

Public Function GetCustomerInfo(FirstName As Object, MiddleInit As Object, _ 
   LastName As Object, Add1 As Object, Add2 As Object, City As Object, _
    St As Object, PostCode As Object, Country As Object) As String
  
    Dim ret As String = FirstName
    
    If Not MiddleInit Is Nothing Then
        ret = ret & " " & MiddleInit
    End If
    
    ret = ret & " " & LastName
    
    ret = ret & vbCrLf & Add1
    
    If Not Add2 Is Nothing And Add2 <> "" Then
        ret = ret & vbCrLf & Add2
    End If
    
    ret = ret & vbCrLf & City & ", " & _
        St & " " & PostCode & "  " & Country
    
    Return ret    
End Function

Finally, we need to call this function from our report. Add a textbox to the upper part of the report and use the following expression:

=Code.GetCustomerInfo([FirstName], [MiddleInitial], [LastName], [Address1], [Address2], [City], [Region], [PostalCode], [Country])

If you run this report now, you should see we have everything needed to output a single receipt or invoice.

This is useful if you want to print this now, for this one sale, but what if you batch your invoices together?

Thankfully, this is incredibly easy to handle. You see, FPL reports have a property in them that lets you group data together at the page level. Once one instance of the group is finished you get an entirely new set of pages for the next group. We can use this to batch together multiple invoices or receipts at once. And all it takes are two changes, one to pull in more data and one to set the grouping.

First, lets get that data! In the Report Explorer, right click on our DataSet, DataSet1, and choose Edit. On the Query page, update our query to:

SELECT * FROM CustomerOrders WHERE CustomerID IN (1000, 1008, 1029)

With this change we'd have all of our data in a single report--not quite what we want. Let's add the page-level grouping now. Click on the gray surface surrounding the report. In the property grid, click Fixed Layout Settings. For Dataset name, click the dropdown and select DataSet1. Now go to the Grouping page, and under Group Expressions, click in the area and in the dropdown that appears, select, =Fields!CustomerID.Value.

That's it! We're done. We've now successfully created a report which uses FPL to display a single receipt or invoice, then updated that report to be able to handle batches of receipts or invoices.

Next time, we'll look at a more complicated layout dealing with overflow, for example, what happens when there is more data than the space defined on the page will allow? Subscribe to our feed or check back often for new posts.

Introduction to Fixed Page Layout–Part 1

ActiveReportsTeam — Wed, 18 Apr 2012 09:18:00 GMT

Fixed Page Layout (FPL) reports are the newest kind of report that you can create with ActiveReports Developer 7! The design of these reports very closely resemble the finished pages that the report will produce. Each page of the report layout contains report controls that are fixed on the page with designated areas for the repeating data rows to fill up.

In this post, I'll explain what FPL reports are, show you some examples of these types of reports, and discuss how this new reporting feature can be used in your applications. In the posts that follow, I will walk through the creation of some FPL reports and reveal more advanced features.

FPL reports give you full control over the pages in your report. You place the controls on the page where they are permanently fixed, and define where the data will later be filled in, and by tweaking some properties you can create some extraordinarily complicated reports in an incredibly easy way.

With FPL reports you no longer need to painstakingly hand-code all of the report elements and carefully measure them to make sure things fit on the paper *just* so. The WYSIWYG designer allows you to drop a table on your report, set a property to tell it how much space it should take up on the page and go. No more hassles!

FPL reports come in several varieties. The most basic form of FPL report simply repeats the same page over and over, changing the contents of the data region(s) for each page.

The next form of FPL adds the ability for a data region's contents to flow into a new area. For example, This can be combined with the single-page design to create a table which flows in two columns. Like the previous design, once we run out of room on the page we will create a new page designed in the same way and populate it with the rest of the data.

FPL reports would be cool in their own right, with just this feature. However, we've gone beyond that to allow you to create even more types of reports. Repeating the same design over and over is okay for some simple types of reports, invoices for example. However you may want that table to carry over onto the second page of a report which uses a completely different design.

This type of FPL report makes use of the same overflow concept as the previous one, only its combined with a separate page design to make subsequent pages different. This doesn't just apply to a single page, you can design multiple pages with over flows and we will fill them out as needed. Once we reach the last page in the overflow chain we'll continue to use that page to fill out the rest of the pages of the report.

FPL reports are also great for long-forms. You know the kind--the one where the entire page is used to display a single row of data? Whether you're working with a single row of data or more, you can use an FPL report to re-create the forms on screen and print them out.

As you can see, Fixed Page Layout reports offer a new kind of report not seen in other .NET reporting tools. We hope that you will find them helpful and we plan to expand what you can do with them following the release.

Next time, we'll take an in-depth look at the first kind of FPL report and walk through the creation of such a report. Be prepared. It's easier than you think!

This is just the second post in a long series on the new features you'll find in ActiveReports Developer 7. Many more will be coming over the next few weeks. Subscribe to our feed or check back often for new posts.

Introduction to ActiveReports Developer 7

ActiveReportsTeam — Wed, 18 Apr 2012 09:01:00 GMT

ActiveReports Developer 7 is the most significant version of ActiveReports to be released since ActiveReports for .NET 1.0 in 2002. Ten years later, we are proud to announce that ActiveReports Developer 7 is now in beta!

ActiveReports Developer 7 is the culmination of many man-years of development work, with teams in the US, Japan, Russia, India, and China all working to make ActiveReports 7 the best reporting tool available. In this version we started with the basics: we combined the reporting technologies behind ActiveReports 6 and Data Dynamics Reports to create a single reporting tool.

Next, we created a unified set of viewer and designer controls to provide a consistent look and feel across all reporting types. The APIs used for the reports are the same as well, so you only have to know one way of loading a report into the viewer or designer.

Finally, we created a brand new reporting technology, Fixed Page Layout. This new page layout option makes it easy to reconstruct forms and other complex report layouts. The next posts in this series will discuss this incredible new way of creating reports.

Over the next few weeks I'll reveal more features of ActiveReports Developer 7, as well as show you how to create some of these new reports. It's easier than it looks!

You can find the download link as well as links to our online help in our ActiveReports Developer 7 beta forum.

This post will serve as a table of contents for the rest in the series. Subscribe to our RSS feed, or check back often for new posts. The first one is already available for you. Read more about Fixed Page Layout in this week's first What's New in ActiveReports 7 blog post series.

Introduction to Fixed Page Layout

Windows Forms Viewer Control – Coming soon!

GrapeCity RussCam Episode #51–Windows Phone 7 UG Tampa March meeting

rfustino — Wed, 11 Apr 2012 18:44:28 GMT

We are at another Windows Phone 7 User Group meeting in Tampa, with a surprise visit from Bill Steele! Bill shares some of the creative ideas he's been generating post-Microsoft. We have some great clips of the Microsoft Mustang that Bill helped build as seen on the Discovery channel. Then, I talk with Luis Perez once again (a frequent guest on Russ Cam)! This time, Luis is telling us about his new MLB Pro '12 app just released -- exclusively available for WP7! Michael Stark talks about his interesting phone apps that reveal what kind of criminal you are! Finally, Paul Beaton tells us about his apps and his experience using OAuth. Be sure to watch until the end for the behind-the-scenes photos and outtakes!

Raw Link : http://gvtv.gcpowertools.com/#russcam51

Photos from WP7 UG March 2012:

Luis Perez, Michael Stark, Paul Beaton and RussCam.

Technorati Tags: wp7,wpdev,wp7dev,wp7ug,microsoft Mustang,Michael Stark,Paul Beaton,Bill Steele,luis perez,MLB Pro '12.

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/11/grapecity-russcam-episode-51-windows-phone-7-ug-tampa-march-meeting.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity RussCam Episode #50- SQL Saturday Tampa Part 3

rfustino — Wed, 04 Apr 2012 20:21:49 GMT

Jenifer Underwood, a Data Platform Technology Specialist with Microsoft, shares with Russ Cam some information from her presentation at SQL Saturday. This is the first time in the country a topic like this has been presented! See for yourself how reporting, analysis and BI work on both Windows 8 tablets and the iPad! Products like Mobi Weave and PushBI are on the cutting edge of BI for mobile devices! Don't miss this episode!

Raw link: http://gvtv.gcpowertools.com/#russcam50

Link to SQL Saturday 110 Tampa Photos

Link to episodes and more http://www.gcpowertools.com/russcam

Technorati Tags: SQL Saturday,SQL,Mike Wells,Max Trinidad,PAM SHAW,Mat Mathiasen,tribridge,SQL Server 2012,martin cairns,jen underwood,mobility BI,iPad,Mobi,PushBI

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/04/grapecity-russcam-episode-50-sql-saturday-tampa-part-3.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity RussCam Episode #49- SQL Saturday Tampa Part 2

rfustino — Wed, 04 Apr 2012 19:39:07 GMT

In this episode I talk with Mike Wells about his session on SQL Server 2012 running on Server Core. Then, Jason Hofferle, who is a huge PowerShell fan, tells me about his session on PowerShell remoting (plus Max Trinidad has a cameo)! Jason also talks about the awesome food they had at the speaker dinner! Then we have some footage from the dinner with Pam Shaw, organizer of the event, thanking the speakers and volunteers for their hard work. Mat Mathiasen talks about his new job at Tribridge. Robert Volk makes us laugh with is deranged usage of SQL Server! From the other side of the pond, Martin Cairns shares what it takes to become a Microsoft Certified Master for SQL Server. Then I share with the SQL Saturday attendees information about the products from GrapeCity PowerTools at the closing ceremonies.

Raw link: http://gvtv.gcpowertools.com/#russcam49

Max Trinidad and Jason Hofferle

Randolph West and Martin Cairnes

Link to SQL Saturday Tampa Photos

Link to episodes and more http://www.gcpowertools.com/russcam

Technorati Tags: SQL Saturday,SQL,Mike Wells,Max Trinidad,PAM SHAW,Mat Mathiasen,tribridge,SQL Server 2012,martin cairns

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/04/04/grapecity-russcam-episode-49-sql-saturday-tampa-part-2.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 9 - CSV Import and Export

rfustino — Wed, 28 Mar 2012 05:04:00 GMT

Spread CTP - Script 9: CSV Import and Export

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 9^th in a series of Spread CTP Blogs and is a continuation of:

GcSpreadSheet has additional settings that are available when saving or loading CSV files. You can only save or load text, include row or column headers, save or load unformatted values, export or import formulas, and set the encoding.

Using Code

CS
string fileName; fileName = "..\\..\\bin\\savespreadstream.csv"; System.IO.Stream stream; stream = System.IO.File.Create(fileName); gcSpreadSheet1.Sheets[0].SaveCSV(stream, GrapeCity.Windows.SpreadSheet.Data.CSVExportFlags.AsViewed); or System.IO.Stream stream; stream = System.IO.File.Open("D:\\SpreadFiles\\file01.csv", System.IO.FileMode.Open); gcSpreadSheet1.Sheets[0].LoadCSV(stream, GrapeCity.Windows.SpreadSheet.Data.CSVImportFlags.None);
VB.NET
Dim fileName As String fileName = "..\bin\savespreadstream.csv" Dim stream As System.IO.Stream stream = System.IO.File.Create(fileName, System.IO.FileMode.Create) GcSpreadSheet1.Sheets(0).SaveCSV(stream, GrapeCity.Windows.SpreadSheet.Data.CSVExportFlags.AsViewed) or Dim s As New FarPoint.Win.Spread.Model.SpreadSerializer Dim stream As System.IO.Stream stream = System.IO.File.Open("D:\SpreadFiles\file01.csv", System.IO.FileMode.Open) GcSpreadSheet1.Sheets(0).LoadCSV(stream, GrapeCity.Windows.SpreadSheet.Data.CSVImportFlags.None)

Part 10 Data Binding

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/03/28/grapecity-spread-silverlight-ctp-part-9-csv-import-and-export.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 8 - Conditional Formatting

rfustino — Wed, 28 Mar 2012 04:59:00 GMT

Spread CTP - Script 8: Conditional Formatting

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 8^th in a series of Spread CTP Blogs and is a continuation of:

Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation

GcSpreadSheet supports conditional formatting in cells. You can use styles to set the visual appearance of the formatted cell. There are several types of conditional rules. They are as follows:

· AverageRule Class The average rule checks for values above or under the average.

· CellValueRule Class The cell value rule compares values.

· DateOccurringRule Class The date rule compares dates.

· FormulaRule Class The formula rule allows you to use formulas when checking the condition.

· ScaleRule Class The scale rule uses a sliding color scale. For example if 1 is yellow and 50 is green, then 25 would be light green.

· SpecificTextRule Class The specific text rule searches for text strings.

· Top10Rule Class The top 10 rule checks for values in the top or bottom of the range.

· UniqueRule Class The unique rule checks to see if the value is the only one of that value in the range (if the duplicate option is false).

The scale rule has an option for two or three colors in the scale (TwoColorScaleRule Class or ThreeColorScaleRule Class). The following image is for a three scale rule.

Using Code

CS
var rule = GrapeCity.Windows.SpreadSheet.Data.ThreeColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 100, Colors.Red); rule.Ranges = new GrapeCity.Windows.SpreadSheet.Data.CellRange[] { new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1) }; gcSpreadSheet1.Sheets[0].ConditionalFormats.AddRule(rule);
VB.NET
Dim rule = GrapeCity.Windows.SpreadSheet.Data.ThreeColorScaleRule.Create(GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 1, Colors.Yellow, GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 50, Colors.Blue, _ GrapeCity.Windows.SpreadSheet.Data.ScaleValueType.Number, 100, Colors.Red) rule.Ranges = New GrapeCity.Windows.SpreadSheet.Data.CellRange() {New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 20, 1)} GcSpreadSheet1.Sheets(0).ConditionalFormats.AddRule(rule)

Enter values to test it out… -1, 50, 100, etc…

Part 9 CSV Import and Export

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/03/28/grapecity-spread-silverlight-ctp-part-8-conditional-formatting.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 7 - Clipboard Operation

rfustino — Wed, 28 Mar 2012 04:47:00 GMT

Spread CTP - Script 7: Clipboard Operation

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 7^th in a series of Spread CTP Blogs and is a continuation of:

Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span

The user can cut, copy, and paste data in the control by default. You can set AutoClipboard to false to prevent this. The ClipBoardOptions property allows you to control what data is pasted by the user. If the user cuts the data before pasting, all the information is pasted.

The cut action is treated as a copy action if the user cuts the data between controls, between the control and an Excel-formatted file, or between the GcSpreadSheet control and other controls.

Copying and pasting between the control and a CSV file is only supported if the text is separated with /t.

The following conditions apply when using cut, copy, or paste:

· If a selected range includes a hidden cell, then the hidden cell information is cut, copied, or pasted as well.

· The active cell becomes the first cell of the target range when pasting.

· Text is treated as a formula when pasting text that starts with an "=" from another control or application.

· Cut, copy, or paste is not supported with data validation, conditional formats, and filter actions.

· Cut, copy, or paste is not supported between the control and an HTML file.

· The target range size may be adjusted to the source range size when copying and pasting.

Add a button to the page for “Copy and Paste”:

Using Code

CS
gcSpreadSheet1.AutoClipboard = true; gcSpreadSheet1.ClipBoardOptions = GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions.All; gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = "Copy"; gcSpreadSheet1.Sheets[0].Cells[1, 1].Value = "Cut"; gcSpreadSheet1.Invalidate(); private void button1_Click(object sender, RoutedEventArgs e) { GrapeCity.Windows.SpreadSheet.Data.CellRange r; r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2); GrapeCity.Windows.SpreadSheet.Data.CellRange r2; r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(3, 3, 2, 2); GrapeCity.Windows.SpreadSheet.UI.GcSpreadSheet test; test = gcSpreadSheet1; test.View.ClipboardCopy(r); //test.View.ClipboardCut(r); test.View.ClipboardPaste(r2); gcSpreadSheet1.Invalidate(); }
VB.NET
GcSpreadSheet1.AutoClipboard = True GcSpreadSheet1.ClipBoardOptions = GrapeCity.Windows.SpreadSheet.Data.ClipboardPasteOptions.All GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = "Copy" GcSpreadSheet1.Sheets(0).Cells(1, 1).Value = "Cut" GcSpreadSheet1.Invalidate() Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2) Dim r2 As New GrapeCity.Windows.SpreadSheet.Data.CellRange(3, 3, 2, 2) Dim test = GcSpreadSheet1 test.View.ClipboardCopy(r) 'test.View.ClipboardCut(r) test.View.ClipboardPaste(r2) GcSpreadSheet1.Invalidate() End Sub

Run the app and click on the button and say Yes to the prompt

Part 8 Conditional Formatting

Spread, Excel, Silverlight, CTP, labs@grapecity.com , visual studio, AutoFit, borders and Grid lines , cell format, cell overflow, cell span, clipboard, clipboard operation

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/03/28/grapecity-spread-silverlight-ctp-part-7-clipboard-operation.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';

GrapeCity Spread Silverlight CTP, Part 6 - Cell Span

rfustino — Wed, 28 Mar 2012 03:56:00 GMT

Spread CTP - Script 6: Cell Span

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

This is the 6^th in a series of Spread CTP Blogs and is a continuation of:

Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow

You can create a cell span in the cell, row header, or column header area. You can also remove or clear cell spans.

The entire span is treated as an active cell when using the Tab key to move the active cell to the spanned cell. The active cell outline includes the entire span.

The following image displays a span in the cell and header areas:

Using Code


GrapeCity.Windows.SpreadSheet.Data.CellRange r; r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 3, 3); gcSpreadSheet1.Sheets[0].AddSpanCell(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells); gcSpreadSheet1.Sheets[0].RowHeader.ColumnCount = 2; gcSpreadSheet1.Sheets[0].ColumnHeader.RowCount = 2; GrapeCity.Windows.SpreadSheet.Data.CellRange r2; r2 = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2); gcSpreadSheet1.Sheets[0].AddSpanCell(r2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader); gcSpreadSheet1.Invalidate();
VB.NET
Dim r As GrapeCity.Windows.SpreadSheet.Data.CellRange r = New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 3, 3) GcSpreadSheet1.Sheets(0).AddSpanCell(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells) GcSpreadSheet1.Sheets(0).RowHeader.ColumnCount = 2 GcSpreadSheet1.Sheets(0).ColumnHeader.RowCount = 2 Dim r2 As GrapeCity.Windows.SpreadSheet.Data.CellRange r2 = New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 2, 2) GcSpreadSheet1.Sheets(0).AddSpanCell(r2, GrapeCity.Windows.SpreadSheet.Data.SheetArea.RowHeader) GcSpreadSheet1.Invalidate()

Technorati Tags: Spread,Excel,Silverlight,CTP,labs@grapecity.com,visual studio,AutoFit,borders and Grid lines,cell format,cell overflow,cell span

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells_blog/archive/2012/03/27/grapecity-spread-silverlight-ctp-part-6-cell-span.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';