Search the Community

Hello, I have a report looking at courses for my college. Each course can have multiple attributes (which I return with a sub query for each stating 'Y' or 'N' if they are associated with said attribute). My end user is requesting an additional column which states if they are associated with multiple attributes - so the column will return 'Y' if they have multiple attributes, or a 'N' if they only have one attribute. I am requesting assistance in coding the 'Multiple' column, as I am returning a Y or N for each attribute by using sub queries, and not quite sure how to compare the sub queries together to return a value if they have multiple attributes (meaning more than one of the sub queries will return a 'Y'). Thank you.

My report is currently displaying every test that is run. I would like to change the report format so that only the latest run (by start date) of each test case is shown. For example, a test case is run twice, and I only want the latest run on the report. It should also work when new test cases are run in the future. How can I do that in XSLT? What would my code be like or what type of function will I use? Let me know if you need more info on this. Thanks!! My XML code: <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> <Report> <Title>Test Run Summary - Last Run Only Report</Title> <ProjectData> <Project> <ProjectId>71</ProjectId> <ProjectGroupId>13</ProjectGroupId> <Name>Master Project - Marketing</Name> <Description xml:space="preserve"></Description> <CreationDate>2012-06-20T21:40:58.187-05:00</CreationDate> <ActiveYn>Y</ActiveYn> <WorkingHours>8</WorkingHours> <WorkingDays>5</WorkingDays> <NonWorkingHours>0</NonWorkingHours> <TimeTrackIncidentsYn>Y</TimeTrackIncidentsYn> <TimeTrackTasksYn>Y</TimeTrackTasksYn> <EffortIncidentsYn>Y</EffortIncidentsYn> <EffortTasksYn>Y</EffortTasksYn> <TasksAutoCreateYn>Y</TasksAutoCreateYn> <ProjectGroupName>Siebel Projects Group</ProjectGroupName> </Project> </ProjectData> <TestRunData> <TestRun> <TestRunId>8377</TestRunId> <Name>TS09 Verify system should allow for bottom/detail level campaigns to be tied 1:1 to offers-All Campaigns View</Name> <Description>Pre-requisites1. The Catalog Manager user should have been setup and is active in Siebel 2. Campaigns should be available3. Divisions should be available in Division pick applet4. Offer should be available</Description> <TestCaseId>3736</TestCaseId> <TestRunTypeId>1</TestRunTypeId> <TesterId>156</TesterId> <ExecutionStatusId>2</ExecutionStatusId> <ReleaseId>223</ReleaseId> <ActualDuration>0</ActualDuration> <StartDate>2013-07-22T11:50:30.77-05:00</StartDate> <EndDate>2013-07-22T11:50:56.687-05:00</EndDate> <AttachmentsYn>N</AttachmentsYn> <TestRunTypeName>Manual</TestRunTypeName> <TesterName>Jagdish Thakur</TesterName> <ExecutionStatusName>Passed</ExecutionStatusName> <ReleaseName>Master Release - Siebel Marketing</ReleaseName> <ReleaseVersionNumber>1.0.0.0</ReleaseVersionNumber> <PROJECT_ID>71</PROJECT_ID> <CustomProperties /> </TestRun> <TestRun> <TestRunId>8390</TestRunId> <Name>TS11 Verify system should allow for bottom/detail level campaigns to be tied 1:1 to offers-All Campaigns Across Organizations View</Name> <Description>Pre-requisites1. The Catalog Manager user should have been setup and is active in Siebel 2. Campaigns should be available3. Divisions should be available in Division pick applet4. Offer should be available</Description> <TestCaseId>3738</TestCaseId> <TestRunTypeId>1</TestRunTypeId> <TesterId>156</TesterId> <ExecutionStatusId>2</ExecutionStatusId> <ReleaseId>223</ReleaseId> <ActualDuration>0</ActualDuration> <StartDate>2013-07-22T11:53:49.52-05:00</StartDate> <EndDate>2013-07-22T11:54:22.043-05:00</EndDate> <AttachmentsYn>N</AttachmentsYn> <TestRunTypeName>Manual</TestRunTypeName> <TesterName>Jagdish Thakur</TesterName> <ExecutionStatusName>Passed</ExecutionStatusName> <ReleaseName>Master Release - Siebel Marketing</ReleaseName> <ReleaseVersionNumber>1.0.0.0</ReleaseVersionNumber> <PROJECT_ID>71</PROJECT_ID> <CustomProperties /> </TestRun> <TestRun> <TestRunId>8405</TestRunId> <Name>TS08 Verify system should allow for bottom/detail level campaigns to be tied 1:1 to offers-My Campaigns view</Name> <Description>Pre-requisites1. The Catalog Manager user should have been setup and is active in Siebel 2. Campaigns should be available3. Divisions should be available in Division pick applet4. Offer should be available</Description> <TestCaseId>3735</TestCaseId> <TestRunTypeId>1</TestRunTypeId> <TesterId>156</TesterId> <ExecutionStatusId>2</ExecutionStatusId> <ReleaseId>223</ReleaseId> <TestSetId>382</TestSetId> <TestSetTestCaseId>3342</TestSetTestCaseId> <ActualDuration>0</ActualDuration> <StartDate>2013-07-22T12:44:31.53-05:00</StartDate> <EndDate>2013-07-22T12:44:49.297-05:00</EndDate> <AttachmentsYn>N</AttachmentsYn> <TestRunTypeName>Manual</TestRunTypeName> <TesterName>Jagdish Thakur</TesterName> <ExecutionStatusName>Passed</ExecutionStatusName> <ReleaseName>Master Release - Siebel Marketing</ReleaseName> <ReleaseVersionNumber>1.0.0.0</ReleaseVersionNumber> <TestSetName>Campaign Promotion</TestSetName> <PROJECT_ID>71</PROJECT_ID> <CustomProperties /> </TestRun> </TestRunData> </Report>