vnug
-
Posts
14 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by vnug
-
Without looking at your jrxml crosstab properties, it would be pretty hard to guess the problem. But, looking at your output screenshot .... it looks like you might be doing grouping on rows. Try removing the grouping option, that could give you the output you are looking for. Hope that helps.
-
Howdy all - Thanks everyone for the helpful responses. The sorting can be done outside of what iReport forces. Unfortunately, it comes at a cost .... we need to know what the data contains. So, the steps if you know the data before: 1) Setup the SQL query with "case" statements to get the proper ordering 2) use pre-sorted data in the crosstab properties 3) Create hidden row and column (depending on whether you need private sorting rather than iReport sorting). These hidden fields will get you the sorting order you need. This step is "very much" needed, otherwise the output will contain lot of unnecessary "null"s. Hope this helps.
-
Or, you could use crosstab to give you the output you are looking for.
-
Thanks, Kchaudhry for the sample file. I am attaching the output for my efforts. I have tried 3 different versions of iReport .... 2.0.0, 3.7.0, and 3.7.1. Whenever I use pre-sorted data in the crosstab setup panel, I end up getting null values in the cells as shown. Here is my select statement - select *, case when row_name='Sample1' then 0 when row_name='Sample2' then 1 when row_name='Average' then 2 end as order_ from data_values order by order_ The select output gives me the output as in excel file (which is also enclosed). I am enclosing the output received for reference. I got the order needed for rows but the output contains unnecessary "null" values. Is there something I am not configuring??? Appreciate any pointers.
-
Hi Kchaudhry: I am trying to get your above example to work .... unfortunately, it is still not displaying data properly (assuming that I know the rownames and columnnames). Would it be possible for you to give me a jrxml file for the dummy data posted in the original post? Thank you. Post Edited by vnug at 03/24/2010 10:30
-
Hi kchaudhry: Thanks for your response. Unfortunately, I do not know the contents of row_name and param_name .... as they are dynamic. That was the reason I have a column "serial_no" (hoping to sort by this column to get the data in the order that I would need). Unless I am missing something that is too obvious .... in your explanation, your query would not work in my case because I wouldn't know the dataset.
-
Hi: I am trying to avoid the default sorting of Crosstab data by passing sorted data. But, it uses in-built data sorting and the resulting output is "atds-what-I-get.jpg". What I would like to get is in "atds-what-I-need.jpg". I am also enclosing the data set for this example. I have also tried the checking the option of "pre-sorted data". Then, I got lot of rows with "null" and some data. Even the data is incomplete. I would appreciate any pointers to fix this issue. Ideally I would like to use the "serial_no" column to order the data set and be able to get the crosstab output as in "atds-what-I-need.jpg". Thanks in advance. best regards, vnug Post Edited by vnug at 04/06/2010 03:29
-
Hi baggypants - I am having a problem with default sorting for rows and columns. Even we got a simple number column in the DB for this purpose. Still, I can't get them in the crosstabs properly. I was wondering would it be possible for you to explain how you got the sorting working. Thanks. best regards, vnug
-
Hi: I am trying to create multi-column report with values added inside a rectangle. I could create multi-column report. But, I am unable to get rectangle displayed as part of the report. Thanks for any help. best regards, vnug
-
Thanks, mrcaffeine. That's what it was. We were using Helvetica and that used to truncate about 5 or 6 words in the end. Even changing the height did not help. Is that usual? (I thought the stretch with overflow should take care of that). Then, we tried with Times-Roman .. now the complete message is showing. The moral - please check the fonts if anyone is missing data in the end of the text field for PDF output.
-
Checkout the first link with google search - http://www.google.co.in/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=jtable%2Bjasperreport&btnG=Search&meta=&aq=f&oq= It might be of help.
-
Hi: We have tried 2 different versions of iReport - 2.0.0 (has iText 1.3.1) and 3.7.0 (has iText 2.1.0). This problem is weird - Here is the sample that is supposed to dispay "The retention time of major peak in the chromatogram of the Assay preparation corresponds to that in the chromatogram of standard preparation as obtained in the Assay". When we run JRViewer, the data displays properly and when we use PDF Viewer, we are missing last few words. The above sample data comes from database (postgresql). I would appreciate any pointers for this bizarre problem. Thanks in advance. best regards, vnug Post Edited by vnug at 03/26/2010 10:06
-
Thanks for the responses. As Svenn pointed out $V{REPORT_COUNT} only gives line number. I was using postgresql 8.3 which does not have the feature of ROWNUM ... so created dummy table with data and used that as part of WHERE condition. Now, onto dynamically creating column headers for the tables.....
-
Hi: I have searched the forum ... but couldn't find anything appropriate. I am trying to print a worksheet in PDF format. The idea behind the worksheet is, I would like to print out the worksheet with tables in them for the users to write into those tables. Yes, I could use other tools. But, we are trying to generate these tables dynamically depending on the variable "number of rows". Also, we would like to print "Row number" in the first column. Typical scenario - Row_Count = 6 The output should look like below: Column1 Column2 Column3 Column4 1 2 3 4 5 6 I would appreciate any pointers for this problem. Thanks.
