gohlj

Thank you once again!, The plan is to experiment with php producing a minimalist paramdef.xml file on the fly so I can specify the dates from the date which data was last synchronised to the current date.

Ok come to think of it periods aren't really important, as long as I can tell between session marks and lesson marks, this report doesn't seem to include session marks anyway. When specifying the .xml in the output arg in CLR it appears to only produce the schema version of the xml report. It looks like I am actually getting somewhere now, thank you so much you are a life saver! I'd come to far to give up, I'd written my own XML parser in php; capable of parsing huge files (we're talking gigabytes) in order import data from these reports into a mysql database. My next step is to be able to produce a fresh paramdef.xml file using php to define the between dates. How did you produce this paramdel.xml file? James

Josh, This is exactly what I need , but how do I modify the report from here? I'd like to include period name and output to XML. James

Hi, Sorry for my delay in getting back to you, I have imported the report but cannot find it to run James

Hi I am trying to produce a report in Sims .Net which can obtain lesson attendance marks (not just marks for sessions, am/pm) for every student between two dates. I need to get this report with the command line reporter tool. I am having a bit of a dilemma here because I am able to manually produce the lesson monitor report (reports > lesson monitor > full register report) but have no idea how to do this using the CLR (perhaps a secret report name), Our local education authority support do not know either. If this is possible I also need to be able to specify the from and to-date at the command line. If I try to create a report using the design report tool in .Net I cant seem to be able to retrieve data containing marks for lessons or be able to filter between dates etc, it all seems a bit flaky. Hope somebody out there can help me! James