Jump to content

JRoss

Members
  • Content Count

    3
  • Joined

  • Last visited

  1. I'm using the below select statement in a calculated field, the resultset works great in the html grid when I fire the datapage, but when I export the datapage the columns are blank. I am able to get results if I change the values from 'true' and 'false' to 1 and 0. Has anyone run into this? We would like the text value of either 'true/false' or 'yes/no' Thanks, -John select case when sum(b.CCO_Place_Points) > [@field:State_Points_Required_Required_Points] then 'True' else 'False' end from JRRESULTSTABLENEW a join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID where a.Me
  2. Update : I changed the replaceable parameter [@MemberID] with a static value and the select works as expected, I also created a calculated field that only contained [field:MemberId] which returned the MemberID for each row. I would think that this type of calculated field should work w/o needing to embed it into a separate datapage, Its like the replaceable parameter is not being correctly set by the db . Yes the @MemberID is dynamic. - I'll check that each of the parameter names are identical between datapages. I'm really only trying to produces a distinct list of Members, coun
  3. I have a calculated field that uses SQL, I plan on using this datapage as a child called from a parent that passes in MemberID When I run the child datapage by itself that uses the select below It does not seem to pass in the parameter entered on the first sceen, I always get the same number , Its like the @field:MemberID value is the last row in the dataset or something. select sum(b.CCO_Place_Points) from JRRESULTSTABLENEW a join Lookup_Places_2 b on b.CCO_Place_ID = a.CCO_PlaceID where a.MemberID = [@field:MemberID] Thanks, -John
×
×
  • Create New...