Jump to content
  • 0
roattw

One Total/Aggregate field wont display - Limit to number of Totals/Aggregates per page?

Question

I have a DP Report  that tally's some basic Yes No responses . 

One is a Yes/No data type field in table (ED_Tour).  - are you coming to this Tour.
The Other is a Text field set as radio button with Yes No options custom defined (Significant_Other?) - Bringing a significant other?

Both Total/Aggregate fields in the report "VERIFY" fine.  But only one will actually display the result on the DP - Yes/No checkbox (ED-Tour).  The text field type Yes No (Significant_Other?) wont show result.

ATTENDING Yes/No type field:  SELECT COUNT [@field:ED_Tour] FROM tablename WHERE [@field:ED_Tour] = 1

Significant_Other  text field (radio button assigned values):  SELECT COUNT [@field:Significnat_Other] FROM tablename WHERE [@field:Significnat_Other] = "Yes"

 

2020-01-25_14-08-03.thumb.jpg.7a2fa3815e8aabd7cd1b2f96b20dcd43.jpg

 

As always, all input VERY appreciated.

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Regarding the OP, I suggest to not reference from your DataSource fields ([@field:]) since you are using a SELECT statement. Secondly, try enclosing the count fieldname inside parentheses.

 

The resulting query should look like something below:

SELECT COUNT(Significnat_Other FROM tablename WHERE Significnat_Other = "Yes"

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...