Activity Kit

Creating Html Reports With Virto Workflow Activities Kit For Sharepoint

Introduction

The necessity of data receiving from a certain list and generating a report often appears when sending e-mail alerts or creating a document. For instance, a user needs to display the list of his active tasks, administrator needs information about new users in the system, a client wants to see his active issues, etc. In other words, it’s highly important and effective to create a report based on data list.

Activities of business process automation are often implemented with Microsoft Office SharePoint Designer, which is easy to use and suitable for quick implementation. But unfortunately, generating reports is not available with Microsoft Office SharePoint Designer.

This article describes how to create a report with VirtoSoftware Workflow Activities Kit for SharePoint and prepare it for sending/processing.

Installation

Install and activate VirtoSoftware Workflow Activities Kit for SharePoint on your site.

Case Example

Then add fields.

ame Type Description IssueOwnerEmail Single line of text Responsible Person or Group Description Multiple lines of text Enhanced rich text (Rich text with pictures, tables, and hyperlinks) Priority Choice (menu to choose from) Choice:
Low
Normal
High
IssueStatus Choice (menu to choose from) Choice:
Active
Closed Resolution Multiple lines of text Enhanced rich text (Rich text with pictures, tables, and hyperlinks)

After completing that, add several issues to this list where Issues with different responsible users are contained and whether they are active or closed Issues.

Creating a Report

Let’s run Microsoft Office SharePoint Designer 2007, connect to the site and select File/New/Workflow in the menu. Then enter name “Create report for Responsible“ in the displayed window, and select list ”Company Issues” that was created before. Since we need to generate a report, both while creation and modification of a list, we should check all the boxes in “Select workflow start options for items in …” block.

After checking all the boxes, click Next to create activities.

To create a report, you only need to create one activity – “Generate report”. “Generate report” activity produces the report template parameters and parameters of collecting items from a list. The generated report is stored to a string variable. You can even describe the data source, filters and data sorting on the activity level. You should also describe the view structure of your report with the help of header, footer and list item templates.

Scheme of the report:
[Header]
[Row for List Item 1]
[Row for List Item 2]
…
[Row for List Item N]
[Footer]

Since “Generate report” activities work with rows, we can generate the report in any text format: simple text, XML, HTML, etc.

To add new activity, click Actions and select More Actions in the drop down. In the displayed window select Virto Actions category and select “Generate report” action. Then click “Add”.

You will see the new activity in the list as a result.

“Generate report” activity contains the following parameters:

Parameter Description this header Optional. The template for the heading section of the report. this row template Optional. The template for the report rows. Use string [%FieldName%] construction to resolve field value from current list item. FieldName can be field display name, field id (GUID) or field index (int). this footer Optional. The template for the footer section of the report all Optional. List item filter. The filter string supports View Name, View ID and CAML string (…). Empty filter returns all items.
Use … element to sort list items. current list Optional. Source list. Default value is current list.

We will leave Current list field without any modifications since we are going to select data from the current list. In your projects you can select any available list as a data source.

We should point CAML request instead of all. CAML request will select open Issues for a current responsible user and sort them by priority.

CAML request which selects all Issues sorted by priority for user ID #123 looks as follows.

We should insert the text highlighted with bold instead of “all” value. This means that we will not insert Query tags and replace user ID with Responsible value from the current row. Unfortunately, if we add direct link to the value of Responsible field, Workflow will replace it to the row of DOMAINuser type while implementation. To receive user’s ID we need to use one more activity from Virto Activities Kit – “Lookup site user property”. This activity stores the value of select user profile in the variable. Let’s add this activity before report generating.

Insert responsible variable to CAML request.

Instead of CAML request description, you can use Web interface to create new view, filter and sort required rows, and enter name or its ID in the activity.

For simplifying reasons, the report will not contain too much HTML. Use the following values instead of this header, this footer and this row template values.

this header Active issues:

Title
Priority
Created
Description

this row
[%Title%]
[%Priority%]
[%Created%]
[�scription%]

this footer

If we leave at least one of these values without any modifications, empty row will be used while report generating. The most significant in these rows is the fact that you can use both Workflow Lookup and links to field values in row template description. To do this you should use [%Field name%] constructions. They will be replaced with real values while report generating.

The description of “Generate report” activity parameters is completed. Now, while creating or modifying of a current Responsible in the Issue, the report will be generated.

So after completing all that, send this report by e-mail. In order to do this, let’s add Send Email activity after report creating. We can use standard activity or one of the Virto Activities Kit. In this case you will have an opportunity to attach files, add sender, or adjust SMTP server which you want to use for e-mail sending.

The full scheme of the business process looks as follows:

Save this business process. Then go to your site, add a new Issue or close (edit) the existing one. The responsible user will receive an e-mail notification to his e-mail address with the list of active Issues.

Conclusion

With the help of Virto Software Workflow Activities Kit for SharePoint, we have found the solution for business tasks regarding HTML report generating based on SharePoint list data. Further versions may include table display improvement and adding HTML links on objects. This is helpful to navigate to objects from the e-mail message directly.

About the Author

VirtoSoftware designs and builds innovative web parts for Microsoft® SharePoint® 2007 and 2010. It’s compiled using the best Ajax and Silverlight technologies. The very first Virto Web Part was released in April, 2009, and the current comprehensive lineup includes calendaring, alerting, collaboration, workflow and administration capabilities for SharePoint users.

The Elephant Game Activity Kit – Introduction

Ecr4kids Kids Holiday & Back Yard Activity Play Kits Balance Builders 17 Pc $1,900.88

Deluxe Student Class Activity Kit Various Games New $599.95

Deluxe Class Activity Kit Field Day Gym Youth Fitness $579.99

SENSORY STIMULATION ACTIVITIES KIT basic cognitive rehab program NEW NIP OT O.T. $349.95

ASSESSMENTS – SENSORY STIMULATION ACTIVITIES KIT $333.00

Sensory Stimulation Activities Kit $299.00

Therapy Aid * BAG * Be Active with Games Activity Kit $175.00

96 Shopping Spree Activity Kits $141.99

CHICKEN RUN ACTIVITY BOOK KIT POSTER PAINT STICKERS $125.00

NRS Colour & Shape Beads Sequencing Activity Kit $119.00

OWI-535PC-ACT ROBOTIC ARM KIT w/USB PC INTERFACE Asmb & Activities/Exp Curri $119.95

72 Shopping Spree Activity Kits $110.99

Time to Enrich: Grades K-6 Activity Kit for Before & $99.95

Time to Enrich: Grades 7-12 Activity Kit for Before & $99.95

Hello Kitty Sewing Machine & Bead Applicator Activity Set Kit $99.99

NEW* Alex Musical Jewellery Box Kids Activity Craft Kit $44.66

OWI-535-ACT ROBOTIC ARM EDGE KIT & Activities – Experiments Curriculum $89.99

48 Shopping Spree Activity Kits $88.99

Animal Activities ages 5 – 9 a Complete KIDPIX activity kit $82.55

Super Spacer® Desiccant Activity Test Kit $75.47

TORNADO TUBE Classroom Science Activity Kit Be Amazing $69.99

All About Air Classroom Science Activity Kit Be Amazing $69.99

Grow Snow Classroom Science Activity Kit by Be Amazing $70.99

Math for Elementary Teachers: An Activity Approach with Manipulative Kit Mathema $75.26

New 96 Packs of Shopping Spree Activity Kit Games $75.16

FABER CASTELL CRAYON RUBBINGS *NEW* COMPLETE KIT *IN STOCK IN BRISBANE* ACTIVITY $29.76

Art History and Appreciation Activities Kit: Ready-To-Use Lessons, Slides, and.. $69.69

GAP kids DVF FUN activity package *KIT* COLORING BOOK/ PAPER DOLLS/ STICKERS $65.00

Medical Doctor Nurse Kit Toddler Preschool Toy Pretend Play Child’s Activity Kid $32.74

Car emergency kit, survival kit, hiking, any outdoor activity MUST HAVE!!!!!!!!! $59.99

New 72 Packs of Shopping Spree Activity Kit Games $58.51

PARALLAX BASIC Stamp Activity Kit – Serial + USB (Text v.3.0) $49.95

Chenillekraft – 1720 – ChenilleKraft Plastic Masks Activities Kit – Plastic Craf $56.76

Company CKC1718 Wood Crafts Classroom Activities Kit $56.63

Company CKC1719 Paper Mache Classroom Activities Kit $55.90

Chenillekraft Wood Craft Classroom Activities Kit – 2100 Piece(s) – Natural - $47.74

Chenillekraft Plastic Masks Activities Kit – Chenille Kraft Ckc-1720 (ckc1720) $46.30

Chenillekraft Paper Mache Classroom Activities Kit – Chenille Kraft Ckc-1719 $45.63

Drawing Draw Art Learning Craft Activity w/ Projector Book Set Kids Toy Kit NEW $53.02

Kids Drawing Art Activity Projector w/ Flip Book Marker Kit Set Kids Toy NEW $53.02

Chenille Kraft Wood Crafts Classroom Activities Kit CKC1718 $42.98

Essentials of Music Theory: Teacher’s Activity Kit Complete Book $48.95

Alex Butterfly Mobile Activity Craft Kit NEW IN BOX $26.78

Smart Lab Space Exploration Activity Kit__Solar System, Rocket Launcher & More! $42.29

Lot of 24: shopping spree activity kit $51.49

Materials Kit Teachers Need 4 Sink Float Lesson Summer Activity Supplies Gift $51.48

CSIRO PRESSURE POWER Double Helix SCIENCE KIT 18 Activities & Instruction Book $29.76

PARALLAX WHAT’S A MICROCONTROLLER KIT BASIC STAMP ACTIVITY KIT #90005 NEW $49.99

Houghton Mifflin GEOGRAPHY KIT Grade 7/8? Maps/Activity $29.99

Chenille Kraft Company Wood Crafts Classroom Activities Kit $48.93

Chenille Kraft Company Paper Mache Classroom Activities Kit $48.93

Be Amazing! BIG BAG OF SCIENCE Activity Kit $43.95

Environmental Science Activities Kit Ready-to-use Lessons, Labs | Michael L. Roa $36.46

FIRST AID ONLY 71 PIECE SPORTS KIT LARGE PLASTIC CASE 1 EA FOR SPORTS ACTIVITIES $47.00

Color Loco Colorblast! El Grande Activity Kit $46.70

Winnie Pooh 45 piece ACTIVITY SET / CRAFT SET Paints Crayons TRAVEL KIT – NEW $12.87

ELENCO CHEMISTRY 60 ACTIVITIES KIT CRYSTAL MAGNETISM OPTICS SCIENCE TRICKS 7075 $34.97

GLOBE THEATER Playhouse coloring activity book Paper Model Kit 1977 cut-out $45.00

Alfred Essentials of Music Theory Teacher’s Activity Kit Complete Complete $44.96

Alfred Essentials of Music Theory Teacher’s Activity Kit Complete Complete $44.96

Zoku Character Kit $14.99 Freeze your own unique character pops fast with the Zoku Character Kit. Create animals, faces, and fun characters of your own design, or follow Zoku’s designs included in the instruction booklet. The creative possibilities are endless! The kit includes 14 stencils, 1 faceplate, 1 stand for holding the pop maker steady, a pusher tool for removing fruit slices from the stencils, instructions, and sa…

Whipple Ice Cream Set $8.99 WH60005 Features: -Whipple ice cream set.-Everything you need to create the perfect dessert.-Decorating with bling, beads or decorative elements.-Whipple treats are perfect to wear, share or give to a friend.-Makes 4 ice cream treats.-Recommended for ages 7 and up….

Sassafras Ice Cream Sundae Mini Kit $14.99 Window box contains 2 ice cream cups, 2 spoons, sanding sugar, 2 soda jerk hats & ice cream decorating ideasProduct Measures: 8.5 X 8.5 X 2.5Recommended Ages: 5 years & up…

12 Pack Kids Party Favor Super Songs CD (Packaged in carrying case with Stickers, Crayons and Coloring Book) $34.50 This 12 Pack Kids Party Favor Super Songs CD will be a big hit at your next birthday party. This party favor set includes 12 individual activity kits. Each kit has: 1 CD with 50 Super Songs that kids are sure to love (see track listing for entire list of songs), Stickers, Crayons and a Coloring Book all packaged in a convenient carrying case. This product is a perfect party favor to hand out at yo…

50 Silly Songs CD Activity Kit (Packaged in carrying case with Stickers, Crayons and Coloring Book) $1.98 This product will soon be your child’s new favorite toy. This 50 Silly Songs For Kids Activity Set is an amazing valued product. Inside each kit has: 1 CD with 50 Silly songs (see track listing for entire list of songs), Stickers, Crayons and a Coloring Book, all packaged in a convenient carrying case. This is a perfect product for any parent who is looking for a great new toy to buy for their chi…

150 Toddler Songs – Set of 3 Activity Kits (Packaged in carrying case with Stickers, Crayons and Coloring Book) $13.18 This special collection features 150 songs on three separate CDs. Also included in each activity set are crayons, coloring book and stickers. Each one of these 3 activity sets is packaged in a convenient carrying case that your child will carry around the house. Songs featured on these CDs includes such favorites as: Twinkle, Twinkle Little Star, The Muffin Man, The ants go marching, John Jacob Ji…

Great Ape Activity [VHS] $9.59 …

Disney’s Aladdin Videocassette and Activity Kit $68.98 …

Diva Puppies Activity Kit $14.34 Spoil your kids with a Diva Puppies activity kitKids’ craft kit features a trio of bobble head puppies Activity kit allows you to dress up puppies with ribbons, bows, feathers and more

Craft ‘n Play Unicorn Jewelry Activity Kit $4.37 This fun activity kit contains everything you’ll need to make two piece of jewelry. This set includes beads, glitter glue, foam stickers and chipboard shapes.

Craft ‘n Play Flower and Butterfly Activity Kit $5.98 This fun activity kit contains everything you’ll need to make two chipboard stand-ups. This set includes: Two chipboard stand-ups, glitter pen, rhinestones and foam stickers.

Craft ‘n Play Princess Carriage Activity Kit $5.98 This fun activity kit contains everything you’ll need to make two stand-ups. This set includes two chipboard stand-ups, a glitter pen, rhinestones and foam stickers.

Craft ‘n Play Girls Pony Activity Kit $5.98 This fun activity kit contains everything you’ll need to make stand-ups. This set includes: two chipboard stand-ups, glitter pen, rhinestones and foam stickers.

Craft ‘n Play Heart Crown Activity Kit $6 This fun activity kit contains everything you’ll need to make two stand-ups. This set includes: two chipboard stand-ups, glitter pen, rhinestones and foam stickers.

Craft ‘n Play Fairy Pony Activity Kit $5.98 This fun activity kit contains everything you’ll need to make two chipboard ponies. This set includes: two chipboard stand-ups, glitter pen, rhinestones and foam stickers.

Craft ‘n Play Flower Jewelry Activity Kit $4.34 This fun activity kit contains everything you’ll need to make two piece of jewelry. This set includes: beads, glitter glue, foam stickers and chipboard shapes.

Foam 3D Fairy Hut Activity Kit $6.66 This 3D Foam Fairy hut is easy to assemble with no glue required. A delightful way to entertain and occupy children, this activity kit encourages critical thinking and imagination.

Creativity For Kids Shrinky Dinks BFF Jewelry Activity Kit $6.39 This Creativity for Kids Shrinky Dinks color kit makes it fun to color, bake and create a bracelet for you and three of your BFFs. This colorful jewelry activity kit will give you up to four friendship bracelets.

Slinky ‘All About Volcanoes’ Activity Kit $16.03 Kids can learn about, paint, and create a lava eruption right at home with this fun kit from Slinky. This activity kit makes one volcano landscape measuring approximately 10 inches wide x 12 inches long.

Craft ‘n Play Butterfly and Flower Jewelry Activity Kit $4.34 This fun activity kit contains everything you’ll need to make two jewelry pieces. This set includes: beads, glitter glue, foam stickers and chipboard shapes.

Craft ‘n Play Stand Up Under Sea Activity Kit $7.98 Each of these fun activity kits contains one chipboard background and assorted chipboard stand-up puppets. Your child will enjoy decorating these cut-outs with a glitter pen, rhinestones and foam stickers.

Craft ‘n Play Activity Kit – Girls Rock Jewelry $4.37 This fun activity kit contains everything you’ll need to make two pieces of jewelry. This set includes: beads, glitter glue, foam stickers and chipboard shapes.

Perler Fun Fusion Fuse Cupcakes and Butterflies Bead Activity Kit $7.59 This cupcake and butterflies bead activity kit is fun for the whole family. From Perler Fun Fusion, this bead kit includes everything needed to custom-make bead creations.

Shrinky Dinks Fairy Garden Activity Kit $17.05 This fun activity kit for children features over 50 pre-cut Shrinky Dinks with clear plastic character stands, playscape, sticky dots, foam flowers, glitter gel and more. This kids’ crafts kit is sure to keep young minds enraptured.

Alex Toys Giant Pipe Cleaner Activity Kit $15 Make hats, jewelry, flowers and more with a pipe cleaner activity kit by Alex ToysKids’ craft kit includes 120 pipe cleaners in a variety of colorsActivity kit contents conform to ASTM D4236 and F963

Learn To Crochet Hat and Scarf Activity Kit $10.21 Teaching your child to crochet is easy with this hat and scarf kit. This activity kit includes all the yarn and tools you’ll need to make these cozy accessories.

Craft ‘n Play Fairy Mushroom Stand Up Activity Kit $6.17 Each of these fun activity kits contains one chipboard background and assorted chipboard stand-up puppets. Your child will enjoy decorating these cut-outs with a glitter pen, rhinestones and foam stickers.

Stick-On Glamz Rainbow Activity Kit $5.69 Add these self-adhesive, brightly colored gems to all your craft projects. This package contains 100 gems in assorted sizes and colors.

Petite Sweets Soaps Activity Kit $18.9 Make super cute mini soaps for display or bath-time play using soft soap clay. This kit contains 6.35 ounces of soap clay in assorted colors.

Fuzzoodles Small Monster Activity Kit $8.69 Make oodles and oodles of Fuzzoodle combinations. Just pick some parts, twist it, bend it, build it, then switch it up and do it again. Fuzzoodles are reusable and can be made into all kinds of fun creatures and even accessories.

Perler ‘Zoom Zoom’ Fuse Bead Activity Kit $8.89 Have hours of fun with a Perler ‘Zoom Zoom’ fuse bead activity kit Craft kit lets you build planes, cars and boatsBead kit comes with 2000 multi-colored beads

Alex Toys ‘Shrinky Dinks’ Cool Stuff’ Activity Kit $9.5 Occupying little ones on rainy days has never been easier than with a ‘Shrinky Dinks’ activity kitActivity kit features instant key chains, zipper pulls, magnets and more’Shrinky Dinks’ kids’ crafts are pre-printed and pre-cut

Fuzzoodles Small Goofy Guys Activity Kit $8.99 Make oodles and oodles of Fuzzoodle combinations. Just pick some parts, twist it, bend it, build it, then switch it up and do it again. Fuzzoodles are reusable and can be made into all kinds of fun creatures and even accessories.

Fuzzoodles Small Plush Pals Activity Kit $10.31 Make oodles and oodles of Fuzzoodle combinations. Just pick some parts, twist it, bend it, build it, then switch it up and do it again. Fuzzoodles are reusable and can be made into all kinds of fun creatures and even accessories.

Darice Foam ‘Finger Puppets’ Activity Kit (Set of 48) $6.16 Entertain your little ones for hours with a Darice ‘Finger Puppets’ activity kitKids’ craft is perfect for rainy day, party or camp projectsFabulous ‘Busy Bucket’ includes everything needed to make up to 48 bug finger puppets

Scientific Explorers Bath Fizzers Activity Kit $9.99 This bath accessory science kit is based on the nationally recognized Great Explorations in Math and Science (GEMS) program pioneered at UC Berkley’s Lawrence Hall of Science. Create eight berry scented bath fizzers.

Foam Kit Makes 24 – Visors $6.54 This 3D Foam visor Kit makes stylish visors you can decorate. A delightful way to entertain and occupy children, this activity kit encourages imagination.

Works Of Ahh Butterfly Wind Chimes Large Wood Paint Kit $19.98 Create your very own work of art with this wood painting kit. This butterfly wind chimes kit is perfect for parents and kids to complete.

Crayola Model Magic Color Fillz Fish Activity Kit $16.45 This Crayola Model Magic Color Fillz Mosaic Pop Art Kit features a 3-D fish. Color and fill the fish any way you please.

Creativity for Kids Room Decor Chandelier Kit $15.2 Create and decorate your own glistening hanging chandelier with this activity kit from Creativity for Kids. This kit contains one cardboard chandelier and various jewel, bead and yarn embellishments.

Foam 3D Jewelry Box Kit $6.66 This 3D Foam Jewelry Box Kit is easy to assemble with no glue required. A delightful way to entertain and occupy children, this activity kit encourages critical thinking and imagination.

3-in-1 ‘Butterflies & Dragons’ Foam Kit $7.41 This ‘Butterflies & Dragons’ foam sticker sets feature hours of fun for the young and old alike. This 1,000-pierce foam set is great for scrapbooking, greeting cards, kids foam crafts and much more.

Insect Lore Creature Peeper Bug Magnifier $9.83 This amazing two-lens magnifier from Insect Lore allows you to view your insect from above and below. You can use the Creature Peeper activity kit to view a variety of small objects, not just bugs.