white_falcon02

Hi all, I have several reports designed in studio which I have uploaded to the server. I want to be able to manually trigger running a set of reports manually once the last peice of data is received each month, which has no set schedule. Some of the reports need to be saved for accounting in xlsx format with a specific name to a specific folder. Others are ment for management and need to be saved in PDF format. Is there a way I can set up a job to with all of the input controls selected and file names designated by manually triggering the report run? I cannot run the report set on a schedule as I do not know from month to month when the reports will be ready to run.

My title is the correct format. I was tired! I was looking to place the $ sign completely left-justified and the amount completely right-justified in the box and a whole lot of white space between no matter what the amount is. Excel does this with the accounting format.

In a text box, I am looking to format an amount so that the $ appears on the right side of the box, and the amount on the left similar to how excel displays amounts. This report will actually be exported to Excel when it is ran and sent to the accountants. Is it possible to do as I ask?

Exactly like below! Thanks. I was trying to do it in the pattern for the text field and absolutely had a Java mental block.

Hi all, In Jaspersoft Studio 7, I am looking to add a report created line on the Last Page Footer band. I am using the following line in a text field: "Report created " + new java.util.Date(). I am looking to format it so that the output looks like "Report created 02/27/2019 2:30:00 PM EST" however the format I am getting with the above is "Report created WED Feb 14:30:00 EST 2019". Can someone assit me in correcting my pattern or expression so that I display the desired date and time?

@Yann22300, you gave me enough of a clue to be able to get this working. It was the dataset step that I skipped that created the issue. Thanks!

All I did was create a report with the sql to produce the records you see above, dragged a chart to the details band and attempt to set the x and y. I do not want to display the actual data in the report. Only the chart.

Hi all, I am a newbie so please excuse my ignorance. I have the following data set which is generated from the sql analytical query that I am looking to turn into a line chart. periodsummedorderPeriod17-Dec69061230.1512/1/201718-Jan101563562.41/1/201818-Feb119569031.12/1/201818-Mar118191987.83/1/201818-Apr123163992.74/1/201818-May135128309.45/1/201818-Jun133909155.66/1/201818-Jul133295855.67/1/201818-Aug117197691.98/1/201818-Sep299121973.39/1/201818-Oct128298360.410/1/201818-Nov137291993.811/1/201818-Dec135947879.912/1/2018The datatypes are as follows: Period: String Summed: big decimal datePeriod: Date I have tried evrything I can think of to turn this into a line graph but with no luck. I am tring to set the period as the x-axis and the summed as the y-axis. I know once I see how this isdone, I will be fine from that moment forward but I am definately having issues getting the first chart knocked off and decided it was time to ask for help from you experts. I really appreciate any assistance you pros can give me.

Hi Andy, It is not for prompting. I have never explored working with xml/xpath or really know where to begin.

Hi all, I am desperate here. I am working in Studio 7.1. I have set up a parameter called Program_ID in the main report with a default value STRINGvalue of 'education' that I want to use as part of a WHERE clause in the subreport. I then added a new subreport with the following with use same report connection as main and add the following simple query: SELECT emp_numberFROM "emp_tbl" WHERE PROGRAM_ID = $P{Program_ID}[/code]I added a parameter Program_ID to the subquery. I returned back to the main report and clicked on the subreport, edit parameters button, and set the expression to $P{Program_ID}. When I return to the subreport, it turn up zero results. If I hardcode the program_id as 'education' instead of $P{Program_ID}, I get back the full results that I am looking for. I have tried everything I can thing of and would really appreciate any help one of you can give me.

Hi all, I want to create a subreport studio that uses the same saved subreport multiple times but have one variable change. The query in the subreport is SELECT DISTINCT DATEADD(MONTH, -13, GETDATE()) AS monthYearFROM "mytable"[/code]For the first column, I want to display the month and year from 13 months ago. The next time, I want to display the month year from 12 months ago, and so on. Is there a way to do this?

I am looking to create a simple trends report in report studio as a simplified proof of concept for a report we currently run in excel. The data is as follows in a database: Purchase date formatted mm/dd/yyyycost with decimal placesI am looking to setup a studio report with 13 columns. Each of these columns would represent the previous 13 months and would have a format such as Oct 18, Sep 18, and so on. For the row, the data would be a summary of purchase costs rounded off with no decimal. I attempted to do this as a cross tab but with no luck. Can someone talk me through this first report?