csv - Jaspersoft Studio : issues while drawing graph -



csv - Jaspersoft Studio : issues while drawing graph -

i new jasperreports / jaspersoft studio , struggling bit charts. experts may find primitive , possible missing basic stuff here.. here brief of trying do 1) info source csv next fields sr_no, uri, total_time_taken, no_of_requests, avg_time_per_req, most_expensive_req, timestamp_of_exp_req 2) csv has around 40,000 lines in it 3) want create study has 40,000 lines in (a simple columnar study based on fields, sorted no_of_requests in descending order). piece of cake in jasperstudio ! 4) next, want summary page "top 10" uris in pie chart value of pie series no_of_requests , key uri (pretty straight forward)

i have created study in jasperstudio info source csv. have selected fields , applied no filter query primary dataset (i.e. default dataset while creating report). helps me print 40,000 lines in "details" band of report...so first part taken care off.

for summary page need pie chart challenge "top 10" records entire dataset. thankfully "top" criteria based on no_of_requests field , info sorted based on field. still, need subset of info draw meaningful chart. accomplish this, tried create new dataset 2 fields, uri (which key pie) , no_of_requests (which value). applied filter look "($v{report_count} > new integer(10)) ? false : true" new dataset "top 10" records sorted data. verified filter working correctly running in "data preview" tab of "dataset , query" dialogue. have chosen new dataset "dataset" pie chart..

when run study (in preview mode of jasperstudio), 40,00 0 lines printed corrected (in details band) summary empty. draws no pie chart. tried same bar chart, result same. summary in case shows x , y axis no info points. graph empty.

am missing something?

any help in regards highly appreciated.

i have created 2 variables gonna utilize in pie chart select top n values dataset. accomplish have used $v{report_count} variable follows

if($v{report_count}<=n,$f{your_field},"") - if variable string if($v{report_count}<=n,$f{your_variable},0) - if variable integer.

substitute n desired number.if need top 10 values n=10

now have used these 2 variables create pie chart.

i have written blog same not upload images here.

please check same detailed solution.

http://www.rajeshsirsikar.com/selecting-top-n-values-from-a-csv-datasource-jaspersoft-studio/

csv charts jasper-reports

Comments

Post a Comment

Popular posts from this blog

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* -

xslt - DocBook 5 to PDF transform failing with error: "fo:flow" is missing child elements. Required content model: marker* - i've inherited doc publishing process takes docbook , builds html , pdf output, using apache fop both. project had been started, never completed. lots of tweaking, i've able of doc sets build (20+), except handful, , fail severe code 1 of these 2 conditions: "fo:flow" missing kid elements. required content model: marker* "fo:block" not valid kid of "fo:root" the xml output comes out of docbook , docbook-fop checks out well-formed. the fop error in 1 book, "endecagloss", example, points end of string: <fo:flow flow-name="xsl-region-body" start-indent="4pc" end-indent="0pt"/> here’s log output in case: [java] severe: javax.xml.transform.transformerexception: file:/scratch/publishing/hudson/jobs/build-main-endeca-documentation/workspace/serverdoc/w...
Read more

mediawiki - How do I insert tables inside infoboxes on Wikia pages? -

mediawiki - How do I insert tables inside infoboxes on Wikia pages? - i want insert tables in infoboxes. example, have proteinbox i've developed using infobox template (http://health-and-medicine.wikia.com/wiki/template:proteinbox), , fasta field big fit comfortably in proteinbox. hence collapsible table within box. this tried: {{infobox | row 1 = {| class = "mw-collapsible mw-collapsed wikitable" |- | <!-- table content --> |} }} your problem is, putting nested table within template. pipe characters ( | ) in table syntax collides pipe usage in templates. the commonly used hack around create template called template:! , containing pipe character, , utilize when need set tables, parser functions or other stuff using pipe characters, within templates. table (with every | replaced {{!}} ): {{{!}} {{!}}- {{!}} a1 {{!}} b1 {{!}}- {{!}} a2 {{!}} b2 {{!}}} ...the equivalent of {| |- | a1 | b1 |- | a2 | b2 |} furthermore, hav...
Read more

Local Service User Logged into Windows -

Local Service User Logged into Windows - i created windows service tracks app server user connected through load balancer. it retrieves user logged windows on machine, cross references active directory (ad) business relationship homecoming first name, lastly name , e-mail (for notification through website created project) there 1 scheme on network users remote system, vista system, reason returning values "local service" logged machine, it's weird , security guys impossible "local service" business relationship logged windows. here how user logged windows managementscope ms = new managementscope("\\\\.\\root\\cimv2"); objectquery query = new objectquery("select * win32_computersystem"); managementobjectsearcher searcher = new managementobjectsearcher(ms, query); foreach (managementobject mo in searcher.get()) { _username = mo["username"].tostring(); } // remove domain part username string[] usernameparts = _...
Read more