Skip to main content
A
Abdlah
Inspiring
April 23, 2008
Question

Reporting

  • April 23, 2008
  • 1 reply
  • 512 views
I have various tables in my database and I am creating a report that should show an electoral constituency along with the votes that each party has received in that constituency. But I ca figure out how to create a report that shows the constituency and then all votes received for each party, one row at a time. My query right now shows the constituency name, the party name and the votes received.

I tried to use CFReportBuilder but could not figure it out. Please help. Thanks


My tables are as follows:

VoteResults(Party, ResultCategory, Votes, AgentPhone)
Cnstituency( ConstituencyNo, ConstituencyName,RegionCode, District)
PollingStation(StationNo, COnstituencyNo, StationName, AgentPhoneNo)
    This topic has been closed for replies.

    1 reply

    N
    Newsgroup_User
    Inspiring
    April 23, 2008
    So first of all, do you need help with the query or the output or both?
    I.E. are you getting the results you need from your query?

    If you don't know, <cfdump var="#qryName#"> is great for quickly seeing
    what was returned.
    A
    AbdlahAuthor
    Inspiring
    April 24, 2008
    Sorry my question was not clear. The query works fine, I am just trying to find out how I can display my output so that for each constituency I show the constituency name in a column followed by results for all the parties in that constituency in my VoteResults table.

    Currently I can only show the results by repeating the the constituency with each party's vote count.

    So instead of having to report the results as:

    London: Labor 40, London: Conservatives 33, London: Reform Party 20, and London: Liberal Democrats 15

    I Want to report it as:
    London: Labor 40, Conservatives 33, Reform Party 20, Liberal Democrats 15

    I hope I have made it clearer.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices