Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
540 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Software ==> | SSRS Reporting Services (99 exercises) |
Topic ==> | Basic Custom Assemblies (2 exercises) |
Level ==> | Relatively easy |
Subject ==> | SSRS training |
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
This exercise isn't as scary as the title above makes it sound! The idea is to display an image next to each film, according to whether it's short (under 2 hours), medium (2-3 hours) or long (3 hours +).
This person clearly isn't a film buff: the shorter the film the better.
Thoughts on how to go about doing this are shown below!
To start our report off, first add 3 images from the folder shown at the start of this exercise into a new report called Not a film buff:
Right-click on the Images category, and choose to add 3 images from the folder shown at the start of this exercise (they've got PNG extensions).
Now create a report listing out the names and lengths of films, with an image showing that each film is great:
Write a function in a class library, build it and copy the DLL over so that it is available to you in your report server project. Here's what the function should return:
Length of film (minutes) | Image returned |
---|---|
Up to 120 | great |
120 to 180 | ok |
More than 180 | yawn |
You can write your code for the custom assembly using either VB or C# - the choice is yours!
Set this function to be the source for your image:
Click on the expression builder tool to set the source for this image to be the results of your function.
Check that your images look correct in your report!
You can find other training resources for the subject of this exercise here:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.