Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Sub Reports for definitions
Topic Summary:
Created On: 20-Mar-2007 12:08
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by SA Team, on Thursday, April 19, 2007 1:17 PM

Answer:
Hi

I have spoken with a collegue and established that the stylesheets are quite particular about the format of the data which they process. It appears that you need to report on the 'Name' of the top level items in the subreport, and specify that it is 'invisible' (since we don't want them output). Since you also want to report on 'Name' at a lower level of the report, you also need to change the 'legend' at that level, to ensure it does not also take the type 'invisible'.

Attached is the ammended sub report.

Hope this does what you require (it worked in my sample)

Thanks
Ian
 20-Mar-2007 12:08
User is offline View Users Profile Print this message


Mark Frazier

Posts: 41
Joined: 6-Dec-2005

We've created countless custom definitions and IWP generation reports for these definitions.  However, I'm having problems creating one.  Here's what we want to do....

We have a Definition call it A that is used by a definition call it B.  We want the "A" definition report to generate the properties of definition A and then 'conditionally' run a sub report that says if there are definitions B that use definition A list them.

This would seem to be simple but we can't get it to work.  What happens is if definition A is used by B our report/subreport work fine.  However for those times when definition A does not have any definition Bs that use it, then it generates none of the properties for the definition A what we want because the sub report is false.

If someone can give me a sample report/subreport that will do this I can tailor it for our needs.  Thanks!

Mark
Report this to a Moderator Report this to a Moderator
 28-Mar-2007 09:52
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

I think what you are trying to do requires the keyword PARTIAL.
If you place this at the level in the report where you are outputting definition A's properties, it will not require the match on definition B.

The reporting system requires a match at all levels in order to produce output.
PARTIAL tells the reporting system to output the higher levels, even if the lower levels don't produce a match.

Hope this helps - if not, please add a sample report, that might help us.

Thanks
Ian

-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 6-Apr-2007 21:22
User is offline View Users Profile Print this message


Mark Frazier

Posts: 41
Joined: 6-Dec-2005

Hi Ian,

I tried using partial and have not made it work yet.  Here's what we're trying to do...We have two user definitions "Master Capability Library" and "Intel Programs".  Within "Intel Programs" is a property called 'Related MCL' that links the two definitions.  Thus "Master Capability Library" is used by "Intel Programs". 

Here's the IWP code everything in the definition "Intel Programs" works EXCEPT the last subreport.  This subreport is what I need help with.

Please advise what's wrong with this subreport code.  Note that within a definition (MCL) used by another definition (Intel Programs) I'm trying to get the names of the Intel Programs using that MCL.

P.S. I attached the report code.

Thanks,

Mark

Report this to a Moderator Report this to a Moderator
 10-Apr-2007 10:01
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi

On having a quick look I think the subreport should be as attached.
The subreport will execute for every item found in the list "Related Programs" of the items in the parent report, so you should be getting 'Programs' at the top level in the subreport. I think that is why the subreport is currently outputting nothing.
I don't think you need PARTIAL with this type of report, since SUBREPORTs are not part of the SELECT chain.
I will try and find a moment to test this later today (although I can't promise). But in the mean time you could give this a go yourself, and see if it is correct.

Thanks
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 13-Apr-2007 21:39
User is offline View Users Profile Print this message


Mark Frazier

Posts: 41
Joined: 6-Dec-2005

Your suggestion does not work.  Again what we're trying to do is in IWP we have a report saying what properties we want to display for that definition type.  Then we want to run a sub report showing any DIFFERENT definitions of type xxx that USE the definition in our main report.  We can show definitions used by the one in our main report but not the reverse.

Edited: 13-Apr-2007 at 21:40 by Mark Frazier
Report this to a Moderator Report this to a Moderator
 16-Apr-2007 12:59
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi
Maybe I'm not understanding but... would this scenario suit you needs (attached reports)
I have switched the 'used by' with a 'uses' and reversed the SELECTs in the subreport.
NB: I have also corrected the SUBREPORT call (it was spelt SUPREPORT), also I believe it needs { } braces following it.

Since I don't have your data I mocked this up with some other definitions. I get the entries for all main definitions, and I get a subreport for each main entry. Some of the subreports (where there are no 'uses' relations) are blank. The rest have content.

NB: I simplified the report (removed the other fields), so you may want to make the changes to your own copy.

Hope this helps
Ian



-------------------------

Senior Software Developer
Telelogic UK Ltd.

Edited: 16-Apr-2007 at 13:01 by SA Team
Report this to a Moderator Report this to a Moderator
 16-Apr-2007 22:06
User is offline View Users Profile Print this message


Mark Frazier

Posts: 41
Joined: 6-Dec-2005

Ian,

This almost works.  What's now happening is if there are two or more 'Intel Programs' linked to a 'Master Capability Library' then the sub report runs and correctly lists all the intell programs that use it.

However, an odd thing is happening.  For those cases where there is only one 'Intel Program' that uses a 'Master Capability Library' the sub report runs and does NOT list the one intel program.  If I then add to any other 'Intel Program' a link saying it uses the same 'Master Capability Library' that was previously used by only one program, it will then show both programs.  But it never works when there is only ONE.

P.S.  I run these same reports in SA reports and everthing works correctly, however in IWP I'm getting what I descriped above.

Mark
Report this to a Moderator Report this to a Moderator
 17-Apr-2007 11:16
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Hi

I have reproduced your scenario in IWP on my machine with my test data. I will take a look to see what is happening, it may be my report, or something in the stylesheet which is not coping with the XML properly. (I'm guessing the stylesheet as I think the subreports are being generated correctly)

I will try to look at it over the next couple of days. If you need this escalating you may have to go through support and raise an issue. I have attached my test files if you do decide to raise an issue - these should help if a bug gets raised.

Thanks
Ian

EDITED: - Modified attached report file so it now works correctly. The Report was incorrect - see next post.






-------------------------

Senior Software Developer
Telelogic UK Ltd.

Edited: 18-Apr-2007 at 15:13 by SA Team
Report this to a Moderator Report this to a Moderator
 18-Apr-2007 15:09
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005

Answer Answer
Hi

I have spoken with a collegue and established that the stylesheets are quite particular about the format of the data which they process. It appears that you need to report on the 'Name' of the top level items in the subreport, and specify that it is 'invisible' (since we don't want them output). Since you also want to report on 'Name' at a lower level of the report, you also need to change the 'legend' at that level, to ensure it does not also take the type 'invisible'.

Attached is the ammended sub report.

Hope this does what you require (it worked in my sample)

Thanks
Ian

-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 19-Apr-2007 13:18
User is offline View Users Profile Print this message


Mark Frazier

Posts: 41
Joined: 6-Dec-2005

Thanks!

Mark
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.