Crystal Report RRS feed

  • Question

  • My query is like this "SELECT DISTINCT dist, COUNT(dist) AS CNT FROM [Member] GROUP BY dist"

    If i run this query in Access 2007 i'll get like this,

    DIST     CNT

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

    city1      3

    city2      5

    city3      6

    city4      2

    I need to display this in Crystal Report Viewer. I have a field(dist) which is present in my query on the report page from Database expert. And i'm creating another field which is not present in report page, but by the query. How can display the second column in the report page??

    I'm using VB.NET 2008 and Access 2007.. Any suggestion???

    • Moved by Jie Bao Monday, July 9, 2012 9:33 AM (From:Visual Basic General)
    Sunday, July 8, 2012 5:21 PM


  • I accomplished it in some other way.. Somewhat difficult way.. :)

    Anyways Thank you all for ur suggestions.. :)

    • Marked as answer by Aruncode47 Monday, July 9, 2012 4:23 PM
    Monday, July 9, 2012 4:23 PM

All replies