[isams] iSAMS SSRS report Halp!

[denzal2k4]

This is a long shot and I'm not expecting a response but I don't want to pay iSAMS and wait a month for a one word answer...

 

I'm creating a contact/medical details report it is to show parents the currently held contact and medical details for their child, all working fine having modified the built in contact details report, only issue is that it shows medical issues that are no longer active (I don't know where it is pulling them from as they don't show on iSAMS), I have added the following fields:

 

TblMedicalconditionsGroup - txtGroup

TblMedicalAuditBase - bArchived

TblMedicalAuditBase - bDeleted

TblMedicalAuditBase - intMedicalRecordTypeID

TblMedicalConditionGroup - bDeleted

TblMedicalNoteType - bDeleted

 

And have applied the following filters to show only live records:

 

TblMedicalConditionGroup - bDeleted - False

TblMedicalNoteType - bDeleted - False

TblMedicalAuditBase - bArchived - False

TblMedicalAuditBase - bDeleted -False

 

In the query builder it shows all these filters and they are showing the correct results except we have loads where it his showing false for all the filters and yet they still don't show up in iSAMS, in my mind if they aren't deleted or archived then they should show right??? Is there a field somewhere else that I am missing that shows only current live conditions as shown in iSAMS are displayed?

 

 

Thanks!

Edited November 4, 2024 by denzal2k4

[2ilent8cho]

I've not done any SSRS on iSAMS for about 6 years, but the only thing that comes to mind is they did revamp the Medical Centre module 2 or 3 years ago, it use to be called Sanatorium , could it be records from the old module name/table?

[denzal2k4]

Thanks for that, I've had a look and there is nothing in the Sanatorium tables that relate to it unfortunately, further investigation I can see that one example of this is a pupil had a medical note added in 2021 then modified in 2022 then archived in 2023 and it is pulling out the initial note (2021) but not the final archived version, as if the initial note hasn't been tagged as archived True but the amended one has.

[ticker]

Hi Denzal2k4

 

asked our SSRS report writer here in school if he could help, this was his response

 

On a quick look at what has been provided and by looking at the backend of iSAMS the where part in the query needs to include the code below:

 

(TblMedicalConditionGroup.bDeleted = 0 and TblMedicalNoteType.bDeleted = 0 and TblMedicalAuditBase.bArchived = 0 and TblMedicalAuditBase.bDeleted = 0)

 

0 appears to be active. So if all the values for the fields listed are set to 0 then it should only bring in what is current. This is not a module we use and without seeing the actual report and the results I can only make my best guess.

 

Let me know how you get on, happy to take it over to the DM's if easier.

 

Thanks

[denzal2k4]

Many thanks for that, it basically gives the same result as my one did, in that it is still showing certain archived medical conditions despite the fact the Query returns false for all those fields on all records, I wonder if it is a fundamental bug in iSAMS where if an iSAMS condition is modified and then archived/ deleted, only the modified version gets removed?? With the initial still existing invisibly in iSAMS until pulled out by a report.

 

Hi Denzal2k4

 

asked our SSRS report writer here in school if he could help, this was his response

 

On a quick look at what has been provided and by looking at the backend of iSAMS the where part in the query needs to include the code below:

 

(TblMedicalConditionGroup.bDeleted = 0 and TblMedicalNoteType.bDeleted = 0 and TblMedicalAuditBase.bArchived = 0 and TblMedicalAuditBase.bDeleted = 0)

 

0 appears to be active. So if all the values for the fields listed are set to 0 then it should only bring in what is current. This is not a module we use and without seeing the actual report and the results I can only make my best guess.

 

Let me know how you get on, happy to take it over to the DM's if easier.

 

Thanks

[Danp]

Save me for starting a new thread, I've got a query too about SSRS reports.

 

These are academic reports, I've got a table that pulls through two subjects, English and Maths, this is fine. But, for each of these two subjects, there are "Comment Elements" that are unique to each subject, so writing for English only and mental maths for maths only. I can get these to show in the table ok, but I don't want to see the maths comments on english and vice versa.

 

Can I hide a row if the comment is blank, so for the English table, if mental maths is blank (which it will be!) then it doesn't show?

 

Need something in here I guess.

 

[Ditto]

It's a while since I've used SSRS (on a Progresso report) but I'm sure you are on the right lines. I know I did something similar way back when. I even had horrible cases where I used to do something for a small number students and had dedicated code. I will have some old rdl's around so if I get a chance I'll see if I can find my technique, but what you are showing feels close to the solution.

[Danp]

It's a while since I've used SSRS (on a Progresso report) but I'm sure you are on the right lines. I know I did something similar way back when. I even had horrible cases where I used to do something for a small number students and had dedicated code. I will have some old rdl's around so if I get a chance I'll see if I can find my technique, but what you are showing feels close to the solution.

 

Thanks. I can't quite get the code right, I either get an error when uploading it back to isams or it just plain doesn't work

[vikpaw]

Don’t really know the tables other than basic training.

 

For the medical issue is there any way to select or filter the latest updated date? It sounds like it’s joining somewhere to history.

 

For the academic, it sounds like the common elements are in a separate table. So normally you use a join condition that enforces the link eg subject code = subject code or where comment is not blank.

[denzal2k4]

I think that was the crux of it, I found a standard iSAMS report that had parts of what I wanted and it had code for pulling latest auditid etc, the rest of it was gibberish including security filtering!

 

Thanks

 

- - - Updated - - -

 

I think that was the crux of it, I found a standard iSAMS report that had parts of what I wanted and it had code for pulling latest auditid etc, the rest of it was gibberish including security filtering!

 

Thanks

 

Don’t really know the tables other than basic training.

 

For the medical issue is there any way to select or filter the latest updated date? It sounds like it’s joining somewhere to history.

 

For the academic, it sounds like the common elements are in a separate table. So normally you use a join condition that enforces the link eg subject code = subject code or where comment is not blank.

[Ditto]

@Danp, sorry I couln't find a copy of my old files that dealt with this - I do recall it could be a single setting that kick it in to life. Did you manage to crack the problem? Edited November 24, 2024 by Ditto

[Danp]

@Danp, sorry I couln't find a copy of my old files that dealt with this - I do recall it could be a single setting that kick it in to life. Did you manage to crack the problem?

 

Thanks. No, I didn't get it sorted. I think the issue was I was editing a current file so expect there was some other filter in place.

[AMP49]

Hi all, help needed with editing a report on analytics and insights using ssrs. Blank pages pulling through. If anyone could take a look at it I’d be very grateful! 

[AMP49]

.

 

Edited January 14 by AMP49

[edmokeski]

If ALL blank, check your dataset isn't empty (e.g. problem w/ query).  If add't'l blanks, check sizing - some object (tablix, rectangle, etc.) is probably straying off A4 dimensions.

 

Also check out the iSAMS iCommunity.  You'll find more people who do iSAMS SSRS more often over there.