SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 4 of 4

Thread: Report-Help

  1. #1
    Junior Member
    Join Date
    Oct 2009
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Report-Help

    Can someone advice me how to generate a Excel report which can identify testcases in TestPlan which are not linked to TestLab with Designer name and Project ID. If you have any queries that meet my requirement then that would be great.

    Currently we have about 1000 testcases in TestPlan but not that many in Testlab. So I want to Identify which testcases are just sitting there in Testplan without any action.

    Any Help would be greatly appreciated

  2. #2
    Member
    Join Date
    Oct 2009
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Report-Help

    I think that you can use a cross filter to obtain this information. Cross filters in the Test Plan module have the option "Filter tests not in any test set". If you use this option to display all such tests in the Test Grid, you can then display the columns you want in the grid and then export the data to Excel.

  3. #3
    Member
    Join Date
    Aug 2008
    Posts
    172
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Report-Help

    In the Excel Report Generator:
    _____________________________
    SELECT TEST.TS_TEST_ID,TEST.TS_RESPONSIBLE
    FROM TEST
    WHERE TS_TEST_ID NOT IN (SELECT TC_TEST_ID FROM TESTCYCL)
    ORDER BY Test.TS_TEST_ID
    _____________________________
    While I have been working for Businesses that are Vendor partners with HP, IBM and Microsoft, my opinions and advice is my own.
    The solutions provided are either sourced from my own scripting libraries or from a quick Google Search.

  4. #4
    Junior Member
    Join Date
    Oct 2009
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Report-Help

    Thank you

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.34%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 02:45 AM.

Copyright BetaSoft Inc.