antzjos Posted February 6, 2007 Share Posted February 6, 2007 In the below table; In the subreport TV, Radio etc are retrieved from the DB and shown one each in a column. The numeric values are also part of the subreport. The activities A1, A2 etc are part of main report. Pls let me know how do I display the media elements in a column. Activity TV Newspaper RadioA1 2 1 0A2 1 3 2A3 0 2 1 Post edited by: antzjos, at: 2007/02/05 20:54Post edited by: antzjos, at: 2007/02/05 20:58 Link to comment Share on other sites More sharing options...
jmurray Posted February 7, 2007 Share Posted February 7, 2007 Maybe grouping could help you. See the tutorial at http://www.jasperforge.org/index.php?option=com_docman&task=doc_download&gid=120&Itemid=248 Unfortunately your problem description isn't clear enough to provide a better solution. Link to comment Share on other sites More sharing options...
antzjos Posted February 8, 2007 Author Share Posted February 8, 2007 Let me try to explain in a better way I would like to display the values returned by a query one in each column. For example if my query returns TV, Radio and Stores. I would like to display TV, Radio and Stores as column headers. Let me know if more explanation is required. Thnx for the response. Link to comment Share on other sites More sharing options...
jmurray Posted February 8, 2007 Share Posted February 8, 2007 Use a crosstab Link to comment Share on other sites More sharing options...
antzjos Posted February 8, 2007 Author Share Posted February 8, 2007 thanks murray Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now