Any Progresso SSRS and Visual Studio documentation out there?

[geekgirl]

Hi, I was wondering if there is any Progresso Reporting documentation out there?

I'm a newbie to the system and I'm looking for some Progresso Reporting documentation regarding SSRS using Visual Studio.

 

I haven't seen any on the new Advanced Customer Portal and was wondering if anyone on here has some or could point me in the right direction?

 

I'm doing a bit of self-study while waiting to be booked on a course.

 

Thanks!

[djrscally]

Well you don't need specifically Progresso Reporting help, SSRS is not unique to Progresso, so basically any of the online tutorials will help you get the hang of the basics.

 

Wise Owl's tutorials are really good (the guy running them is also an excellent trainer in person)

 

Although he also uses Visual Studio apparently you'll find most people doing Progresso reports (including Advanced Learning support) use Report Builder 3.0 instead.

[geekgirl]

Thanks for this. I've watched some of the Wise Owl's video this morning which are great. I've also downloaded and opened Report Builder 3.0

 

I'm having an issue with connecting to the report server though. I've put in the URL link but I'm guessing I actually need the server name or the instance of SQL?

[djrscally]

So the url is https://reporting.progresso.net/reportserver

 

If you actually launch Report Builder from the link inside Progresso, it actually connects automatically which is a little less faff.

[geekgirl]

I did use the link from Progresso to create either a model report or dataset report, it downloads and runs the application but I get an error (see screen shot and log attached).

 

 

Log file spits out:

"PLATFORM VERSION INFO

Windows : 6.1.7601.65536 (Win32NT)

Common Language Runtime : 4.0.30319.42000

System.Deployment.dll : 4.6.1055.0 built by: NETFXREL2

clr.dll : 4.6.1076.0 built by: NETFXREL3STAGE

dfdll.dll : 4.6.1055.0 built by: NETFXREL2

dfshim.dll : 4.0.41209.0 (Main.041209-0000)

 

SOURCES

Deployment url : file:///C:/Users//Downloads/reportbuilder_3_0_0_0%20.application

 

IDENTITIES

Deployment Identity : ReportBuilder_3_0_0_0.application, Version=11.0.5058.0, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=x86

 

APPLICATION SUMMARY

* Online only application.

* Trust url parameter is set.

ERROR SUMMARY

Below is a summary of the errors, details of these errors are listed later in the log.

* Activation of C:\Users\\Downloads\reportbuilder_3_0_0_0.application resulted in exception. Following failure messages were detected:

+ Deployment and application do not have matching security zones.

 

COMPONENT STORE TRANSACTION FAILURE SUMMARY

No transaction error was detected.

 

WARNINGS

There were no warnings during this operation.

 

OPERATION PROGRESS STATUS

* [02/06/2016 08:53:32] : Activation of C:\Users\\Downloads\reportbuilder_3_0_0_0.application has started.

* [02/06/2016 08:53:35] : Processing of deployment manifest has successfully completed.

* [02/06/2016 08:53:35] : Installation of the application has started.

 

ERROR DETAILS

Following errors were detected during this operation.

* [02/06/2016 08:53:35] System.Deployment.Application.InvalidDeploymentException (Zone)

- Deployment and application do not have matching security zones.

- Source: System.Deployment

- Stack trace:

at System.Deployment.Application.DownloadManager.DownloadApplicationManifest(AssemblyManifest deploymentManifest, String targetDir, Uri deploymentUri, IDownloadNotification notification, DownloadOptions options, Uri& appSourceUri, String& appManifestPath)

at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp)

at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)

at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl)

at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)

 

COMPONENT STORE TRANSACTION DETAILS

No transaction information is available."

[djrscally]

Ah yeah - you need to use Internet Explorer to launch Report Builder from Progresso. Something to do with how Microsoft ClickOnce applications work mean it only works with IE or (with the addition of a plugin) Firefox.

[geekgirl]

Oh right. Thanks very much for this. It really helped. I should be on my way now

[SimonRushton]

Hi,

 

We've been using Progresso since last September and are very pleased with the progress that's been made. If you make contact with Michael Donnelly at Advanced he can introduce you to a suite of assessment and behaviour inputs and outputs that will save you a lot of time and effort compared with building a model from scratch - the schedules, language, and scales used can be adapted to meet your expectations and the reports being SSRS are of course all editable.

 

For us Progresso is now just what an enterprise MIS system should be: a powerful, robust, quick, reliable system that simply works, and works simply, in day to day operations, yet has the capacity to meet the most off the wall/unique/demanding requirements of individual schools across the whole spectrum of MIS functionality.

 

Whilst we are pleased with the system as it stands, we do want to see it develop further and faster especially across clusters of schools. We think an independent association of users would help both its members and the company in this respect. If you would be interested in joining such an organisation please let me know either through this thread, PM, or email to [email protected].

[geekgirl]

Hi,

 

We've been using Progresso since last September and are very pleased with the progress that's been made. If you make contact with Michael Donnelly at Advanced he can introduce you to a suite of assessment and behaviour inputs and outputs that will save you a lot of time and effort compared with building a model from scratch - the schedules, language, and scales used can be adapted to meet your expectations and the reports being SSRS are of course all editable.

 

For us Progresso is now just what an enterprise MIS system should be: a powerful, robust, quick, reliable system that simply works, and works simply, in day to day operations, yet has the capacity to meet the most off the wall/unique/demanding requirements of individual schools across the whole spectrum of MIS functionality.

 

Whilst we are pleased with the system as it stands, we do want to see it develop further and faster especially across clusters of schools. We think an independent association of users would help both its members and the company in this respect. If you would be interested in joining such an organisation please let me know either through this thread, PM, or email to [email protected].

 

Hi, yes I would be interested in joining a Progresso user forum for help and general information. I'll send you an email in a sec.

 

I actually have one more query. In the Staff Record under Personal Details I've created two UDFs for "Teaching and Support" where you select which field and a text box for their "Job Title". It took me a while to find these in the Query Designer as they were named "Custom Fields Staff Name" and "Value". I've placed them in but they don't pull through right and I'm not sure what I've done wrong.

 

I want one column for "Teaching or Support" field and one column for the "Job Title". At the moment its pulling through each staff member twice - one for "Teaching or Support" field and one for their "Job title" field:

 

Can anyone help?

[djrscally]

@geekgirl

 

UDFs are annoying in Progresso Reports. The simplest way I've found to do it is just to have a separate Dataset fetching all your UDFs, and then use the LookUp() function to fetch them matching on a concatenation of staff ID and UDF Name, like this:

 

=LookUp(CStr(Fields!SchoolOrClusterEmployeeID.Value) & "Job Title", CStr(Fields!SchoolOrClusterEmployeeID.Value) & Fields!Name.Value, Fields!Value.Value, "<>")

 

...does that make sense?

Edited June 2, 2016 by djrscally

[SimonRushton]

I think the data you describe can be stored in system fields and they are much easier to use in reports.

 

It might be a good investment of time and effort to spend a couple of days with one of AL's trainers (one-to-one, ideally not in a many-to-one course setting). It would enable you to get really familiar with the system's scope and structure, learn how to make best use of the highly configurable interface, and avoid creating a bespoke environment, at least until you've pushed the standard one to its (standard) limits.

[NotSoFast]

Hi,

 

We've been using Progresso since last September and are very pleased with the progress that's been made. If you make contact with Michael Donnelly at Advanced he can introduce you to a suite of assessment and behaviour inputs and outputs that will save you a lot of time and effort compared with building a model from scratch - the schedules, language, and scales used can be adapted to meet your expectations and the reports being SSRS are of course all editable.

 

For us Progresso is now just what an enterprise MIS system should be: a powerful, robust, quick, reliable system that simply works, and works simply, in day to day operations, yet has the capacity to meet the most off the wall/unique/demanding requirements of individual schools across the whole spectrum of MIS functionality.

 

Whilst we are pleased with the system as it stands, we do want to see it develop further and faster especially across clusters of schools. We think an independent association of users would help both its members and the company in this respect. If you would be interested in joining such an organisation please let me know either through this thread, PM, or email to [email protected].

 

Hi Simon,

 

We're in a similar position and I'd be keen to be involved.

 

Cheers,

 

Simon

[geekgirl]

@geekgirl

 

UDFs are annoying in Progresso Reports. The simplest way I've found to do it is just to have a separate Dataset fetching all your UDFs, and then use the LookUp() function to fetch them matching on a concatenation of staff ID and UDF Name, like this:

 

=LookUp(CStr(Fields!SchoolOrClusterEmployeeID.Value) & "Job Title", CStr(Fields!SchoolOrClusterEmployeeID.Value) & Fields!Name.Value, Fields!Value.Value, "<>")

 

...does that make sense?

 

No, not really! Sorry!

 

My dataset is called Staff_UDFs.

I have a table setup with the following fields in:

Employee_ID

Staff_Last_Name

Staff_First_Name

Staff_Code

Custom_Fields_Staff_Name = "Teaching or Support?" and "Job Title" fields

Value = "Support" and "Site Staff" fields

 

In the Expressions window of the Employee ID field would it be something like this:

 

=LookUp(Staff_UDFs(Fields!Employee_ID.Value) & "Job Title", Staff_UDFs(Fields!Employee_ID.Value) & Fields!Custom_Fields_Staff_Name.Value, Fields!Value.Value,

Edited June 3, 2016 by geekgirl

[djrscally]

No, not really! Sorry!

 

My dataset is called Staff_UDFs.

I have a table setup with the following fields in:

Employee ID

Staff Last Name

Staff First Name

Staff Code

Custom Fields Staff Name = "Teaching or Support?" and "Job Title" fields

Value = "Support" and "Site Staff" fields

 

In the Expressions window of the Employee ID field would it be something like this:

 

=LookUp(Staff_UDFs(Fields!EmployeeID.Value) & "Job Title", Staff_UDFs(Fields!EmployeeID.Value) & Fields!Custom_Fields_Staff_Name.Value, Fields!Value.Value,

 

OK so...

 

=LookUp(Staff_UDFs(Fields!EmployeeID.Value) & "Job Title", Staff_UDFs(Fields!EmployeeID.Value) & Fields!Custom_Fields_Staff_Name.Value, Fields!Value.Value,

 

You don't need the "Staff_UDFs()" bit - that goes at the end of the function, after Fields!Value.Value...so:

 

=LookUp(Fields!EmployeeID.Value & "Job Title", Fields!EmployeeID.Value & Fields!Custom_Fields_Staff_Name.Value, Fields!Value.Value, "Staff_UDFs")

 

 

Buuuut that won't quite work either because EmployeeID is a number and "Job Title" and Fields!Custom_Fields_Staff_Name.Value are text so SSRS won't let you just use & to join them together, you have to enclose EmployeeID in CStr() (which means "convert to string") to turn that into text as well:

 

 

=LookUp(CStr(Fields!EmployeeID.Value) & "Job Title", CStr(Fields!EmployeeID.Value) & Fields!Custom_Fields_Staff_Name.Value, Fields!Value.Value, "Staff_UDFs")

 

If you want, PM me your email and I'll send you a report file you can look at to make it easier.

[carwardinet]

Hi,

 

We've been using Progresso since last September and are very pleased with the progress that's been made. If you make contact with Michael Donnelly at Advanced he can introduce you to a suite of assessment and behaviour inputs and outputs that will save you a lot of time and effort compared with building a model from scratch - the schedules, language, and scales used can be adapted to meet your expectations and the reports being SSRS are of course all editable.

 

For us Progresso is now just what an enterprise MIS system should be: a powerful, robust, quick, reliable system that simply works, and works simply, in day to day operations, yet has the capacity to meet the most off the wall/unique/demanding requirements of individual schools across the whole spectrum of MIS functionality.

 

Whilst we are pleased with the system as it stands, we do want to see it develop further and faster especially across clusters of schools. We think an independent association of users would help both its members and the company in this respect. If you would be interested in joining such an organisation please let me know either through this thread, PM, or email to [email protected].

 

 

Hi Simon

 

I'm in a Birmingham school moving to Progresso in September so any shared ideas sounds great to me.

 

Cheers

Tom