Jump to content
We've recently updated our Privacy Statement, available here ×

jigar.patel

Members
 View Profile  See their activity

  • Posts

    18

  • Joined

  • Last visited

jigar.patel's Achievements

Apprentice

Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges

0

Reputation

  1. jigar.patel
    Thanks to ernst_2 for answering. But, That's not what I want. I want to pass my array to SQL function as an arguement, from report query. As for example, SELECT * FROM my_function($P{my_array_parameter}) which will pass entire array in my PostgreSQL function and I will receive it in my function as I have set datatype text[] as arguement datatype in PostgreSQL function. Any Ideas...
  2. jigar.patel
    Hi, I want to pass array kind of structure (from report query) to my PostgreSQL function which accepts text[] as input. I tried String[] and ArrayList, but it gives compile time error saying "Parameter type not supported in query". Then I tried passing it as a string ($P!{array_parameter}) but it gives error while deploying report to jasperserver saying: "The selected JRXML could not be parsed. You might have selected the wrong file." Any Suggestions...!
  3. jigar.patel
    Hi, I use ireport & JasperServer. Version 5.6.0 I have one subreport in detail band as I want my subreport run multiple times generating different outputs each time. My detail band height is 1 px. My subreport height is also 1 px (as I know it will be increased dynamically). Detail band contains nothing else. When I generate report in PDF, everything is perfect. I get what I want. Also in JasperServer everything is perfect. I get what I want. But issue is when I schedule this report in JasperServer & try to schedule it in HTML format and send it via email with "embed report in email body" checked, Then in email it shows huge white space before printing subreport each time. and the height of that white space is exactly the height of subreport (for that particular iteration (of main report)). I have googled a lot, changed attributes of subreport, detail band, also tried to apply properties... but nothing helped. Please help.
  4. jigar.patel
    Thanks Mr. Hozawa. I didn't understand what you mean by changing the home page. I updated below line in jasperserver-servlet.xml and it worked. <value>ROLE_ADMINISTRATOR|redirect:/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2FTest_Report</value> I copied that link of report from address bar of the browser. But now I want to open specific folder in repository after login. And the problem is I don't have the link for specific folder. Because whenever we navigate in repository, address bar shows the same address: /flow.html?_flowId=searchFlow, which is not the actual link to specific folder. Do you have any idea?
  5. jigar.patel
    Hi. I have Commercial Version of JasperServer 5.6.0. I want every user to be directed to their specific folder in repository after login. I'm not sure whether it is possible or not. I have tried making changes in repository.search.components.js. But its not working.
  6. jigar.patel
    Thanks for the meaningful conversation. Good Experience. :)
  7. jigar.patel
    Alternative solution is passing parameter value to another parameter and putting condition to check null before assigning value.
  8. jigar.patel
    Its not working. I have already tried that. If I do it like this, it shows me null(not empty collection) in the report. But if I save the schedule from web UI selecting none from that input control then in the report, parameter shows [], which is correct (empty collection) according to JRS. You, 1) create one report with one parameter having Parameter Class: java.util.Collection 2) put textfield to print the value of that parameter in Page Header (or somewhere else) 3) Now create a multi-select-query input control in JRS 4) deploy the report in JRS, add that input control in the report 5) schedule the report with your sample code (with no item in value tag) and see the value of the parameter ( ...shows null ) 6) And then schedule the report again from web UI and check the value of the parameter. (...shows [] ) Thanks...
  9. jigar.patel
    Thanks a lot tchen. Sorry, its my mistake. date is passing fine. The issue is multi-select query in input control. we need to pass collection for such input control. Below is my XML code. Region 34 This code works fine. Schedule runs fine. report is filled with table and its data. But that 'multi-select-query input control' is not mandatory field for the report. So the issue occurs when collection is empty (means I want to pass empty collection). At that time its passing null. which is creating problem at schedule time... Now when I re-Save that schedule from web UI, then it converts that null into an empty collection for that input control. So after re-Saving, schedule runs fine, report is filled with table and its data.... So now the real question is... How to pass an empty collection (for multi-select query input control) through XML? FYI: I'm using JRS 6.0.1.
  10. jigar.patel
    I created a schedule from web UI. It shows me the below format (dateTime - ISO 8601) . <entry> <key>start_date</key> <value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:dateTime">2015-02-01T00:00:00+05:30</value> </entry> I am also using the same format in the request, even I am getting date printed in Page Header in output report. But that parameter is passed into a table datasource, and that table is not appearing in the report (empty datasource). Now if I re-Save the schedule from web UI which I have created through web service, then I can see that table filled with data in the report... My start_date parameter type in the report is java.util.Date. ...also it doesn't matter whatever the xsi:type I input (date,time or dateTime), job definition always consider it as a dateTime format.
  11. jigar.patel
    HI, I passed my date parameter in XML. Selected date is also appearing normal in JasperServer Report Schedule List. But when the report is generated, date filter is not applied correctly, my report shows blank. Now when I manually save that schedule from UI, then my report is scheduling fine and filled up with data. It seems like while clicking on 'Save' button, 'Something' is happening which is not happening while scheduling from web servicies. I am even seeing date in the report, but data is not coming. Please help.
  12. jigar.patel
    I did this and it worked... <source><parameters> <parameterValues> <entry><key>parameter1</key><value xsi:type='xs:string' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>ASDF</value> </entry></parameterValues></parameters> <reportUnitURI>/reports/Test_Report</reportUnitURI> </source>
  13. jigar.patel
    How to pass a single parameter through XML using rest_v2 (for scheduling report)?
  14. jigar.patel
    I am also stuck here. Please help...
  15. jigar.patel
    Thanks
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore