amit.nanote

HI, I am trying to connect my remote server using XML/A Server connection to execute the MDX. But I am unable to get the Metadata details to proceed further. After providing Username/password in main window and testing it gives successful message, but when I click on get metadata and provide the username/password getting following error message. The metadata could not be read from the server. Check the login information. The connection operation returned the error code 200.The metadata could not be read from the server. Check the login information. The connection operation returned the error code 200. The metadata could not be read from the server. Check the login information. The connection operation returned the error code 200. Regards Amit

Hi All, Can we treat that parameter file as datasource and use a data connection to call that datasource in our current to report. for eample - there is a data souce params which have the paramters in a xls or csv file. Our report "samplereport.jrxml" have to use that data adpater to use above mentioned data source to use all the listed parameters in current report. Say params.xls file having list of ids, start date, end date etc. can we access these parameters as params.record1 or params.recordx to use them in current report. If yes. How? Regards Amit

Thanks Hozawa. Is there any other way to pass the parameter file, with Jaspersoft Design view. I donot want to go with scripting kind of thing, if possible. Regards Amit

Hi, I am using eclipse integrated JasperStudio. My requirement is to provide a file or say list of parameters to jasperreport in which one parameter can have multiple values or file location holding those values e.g. param1 - {list of ids} or {Filename with its respective location} --> file having list of ids in thousands param2 - report start date param 3 - report end date param 4 - Some selection value param 5 - some flag param 5 - {list of ids} or {Filename} .... Param 25 (CurrentTimestamp) I am seeking solution using design view. Thanks in anticipation. Regards Amit Nanote

Hey Hozawa, Thanks to you as well. :) .. Regards Amit

Thanks Hedge, I was earlier thought that I was selecting from main, but it was subtype from where I was selecting the fields in detailed area. When tried with main fields it worked and now I am able to see the data. Regards Amit

Hi, Again no data displayed using text field. I have confirmed query used for the dataset which is running fine. Also, when I drag and drop the fields on detail or Summary band of report get following error message - You drop an object from a subdataset into the report, this is not possible. Regards Amit

Thanks for the reply. Yes I have associated a valid dataset for the table. I have a CummTot.csv file which I have assiociated with Jasperstudio using CSV adapter. Also I have checked that my query is returning the rows agains the submitted query. Following is the output - I have deleted the table from detailed field and added it to summary section. After that I have checked the above query and clicked on preview button but again no output got displayed. Thanks again. Amit

Hi, I have created a Report on the basis of CSV file on machine. I am using Eclipse plugin for Jaspersoft Studio. On Data Preview I am able to see the data. But when I check the design preview I am not able to see the data in generated report. Select type in Detail of report is Table. Blank report generated. Please help me to resolve this issue. Regards Amit