4 Replies Latest reply on Oct 19, 2015 1:21 PM by EddieLotter

    How do I output my a plain text, 2 column 'page' from the CF Report Builder 10?

    kevomac12 Level 1

      FIRST

      So I have a cover page occupying the Report Builder 10, Report Header and the size is 11 x 8.5.

      The Page Footer contains labels for the display of the company name, all rights...,copy right..., name of the report and date.

      I'd like to display this so I know it's going to work. The cfoutput tag works only on queries...so is there a CF method to display the 'report header & page footer'?

      This experiment contains a .cfm file with the query and the .cfr files, using Crimson I see the file (test1.cfm)

      test1.cfm:

      SELECTtblStateProvince.State, tblStateProvince.Name, tblFacility.Name as FName, tblFacility.City, tblFacility.PostalCode, tblFacility.Address,

      tblFacility.OID,ContractNumber,ContractEffectiveDate

      FROM  tblFacility INNER JOIN tblStateProvince ON tblFacility.OIDStateProvince = tblStateProvince.OID
      WHERE (((tblFacility.OID)=37667));

       

      Here is where I tried to assign the string to the 'Label' on the Report Header.

      tblFacility.Name = "Yosemite Valley, LLC"

      TReportStaticText104 = "#tblFacility.Name#"

       

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

      SECOND

      tblFacility.OID ="#Session.#tblFacility.OID" ( originally I had this in the query, but the 'builder objected (CF 10 runs this query). why is it the 'builder' cannot resolve this assignment? )

       

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

       

      THIRD


      In (CFeclipse - Browser View) testing works save that it displays the query...so that means if there is no data field/tblFacility.Name designated on my cover page, I can't load the label...Right?

      The "Controls" aren't something that I can program?