Post reply

Can't find hidden field

  • December 23, 2015 at 10:42 am

    #307252

    I inherited this report and need to update it with a new query. I've been through the report twice trying to find the field, ID2014_10_11. I keep getting this error, "The Hidden expression for the tablix ‘Tablix1’ refers to the field ‘ID2014_10_11’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case."

    Any thoughts?

  • December 23, 2015 at 5:30 pm

    #1847861

    Try the dropdown list at the top of the properties window.

    If that fails, open the report xml and search for it there.

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • December 24, 2015 at 4:06 am

    #1847894

    I'm using Report Builder and don't see any dropdowns or how to open in xml.

  • December 24, 2015 at 5:10 am

    #1847898

    deleted (misread)

    LinkedIn

  • December 24, 2015 at 5:16 am

    #1847900

    NineIron (12/24/2015)

    I'm using Report Builder and don't see any dropdowns or how to open in xml.

    Instead of opening the report in report builder, download the rdl and open it with an xml editor or even notepad++

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • December 24, 2015 at 5:30 am

    #1847903

    I gave up on it and will recreate it the correct way. Thanx for your help.

  • December 24, 2015 at 6:35 am

    #1847911

    If you can open it in BIDS / SSDT the Document Outline window is the way to find these things.

    • Viewing 7 posts - 1 through 6 (of 6 total)

    You must be logged in to reply to this topic. Login to reply