Thanks for posting this Adam! I just wanted to add that as far as I am aware you don't need to install Crystal on all machines in order to run the reporting within the console as this uses just a crystal runtime component.
It was more that we couldn't get it to install as part of our singl einstallation (nor could our consultant) so we would have had to deploy it seperately on each PC.
It also seemed quite a slow process but I may have another look!
Cheers - Adam.
A very nice solution Adam, similarly VB or C# etc ASP.NET pages can do the same as PHP for those thinking of trying this. Although we all know PHP is far superior
I expect the reason against using Crystal in your case was that the reports need direct database access and so on an Oracle backend this means every workstation having the Oracle client installed and configured.
Yes Stu, the Oracle client issue was exactly why we did this, but it is a quick and easily customisable option regardless.
The ability to pass field values to web forms is particularly useful and an area we will be looking to exploit. For instance, the WARS lookup in the screenshot above checks student account and module information for that account username.
Very pretty, still considering posting that script?
I asked our sysadmin for ITBM and he has sent me a zip file containing his script for this. Apparently it's not as complex as it looks.
Database access seetings go in config.php; index.php in the printing folder generates the page.
Thisis all Oracle but should be fairly easy to convert for MS SQL usesr.
Cheers - Adam.
LANDeskPHP.zip 12.4 K