frank.py

I'm using report studio 6.3.0. I would like to create a variable that shows a date range. I don't need it to show any parameter values or field values from a database. 1. If it is Tuesday thru Friday, I want the date varaible to show the day before to the current day. For example, if it was Tuesday, display the text: "For the dates November 21, 2016 to November 22, 2016" 2. If it's a Monday, display the previous Friday to Monday. For example: "For the dates November 18, 2016 to November 2, 2016. I was doing the logic in SQL before, and then just using a variable to display it, but want to get away from this now: SQL: (CASE WHEN TO_CHAR(SYSDATE,'D') = 2 Then trunc(sysdate -3) ELSE trunc(sysdate -1) END )StartDay, trunc(sysdate) CurrentDay[/code] "For the dates -" + " " + DATEFORMAT($F{STARTDAY},"MMMM, dd yyyy")+ " to " + DATEFORMAT($F{CURRENTDAY},"MMMM, dd yyyy")[/code]I'm not sure what functions to use to do this or what datatype my variable needs to be. Help appreciated. Thanks,Frank

Hello hozawa, we are using Oracle. We can get the desired result in SQL. But was wondering if Studio had the ability to sort groups in a specified order that you could define in the studio UI and not dependent of any database field for sorting. Thank you

Hello, we have Studio Professional 6.3.0 I have a group header on my report that I would like to group in a specified order. Additionaly, I would like it to not print records that are not specified in the orderI want to sort on car color in a specified order, I want: Red Blue Green But if "Brown" is in the data set, do not print that grouping, becasue it is not in my specified order. I can actually control this with my query WHERE cluase, so the specified order is the most important thing here. Help appreciated. Thanks. Frank

Hello, we are using server Jaspersoft server 6.1. We are experiencing long wait / load times to launch our ad-hoc views. When we select one of our ad-hoc views, we see the "Loading Please Wait" circle for about a second, and then a blank gray screen for around 45 seconds, and then "Loading Please Wait" circle again for about 10 seconds before we finally see our view. Admittedly, the queries are rather large and the domain used pulls real-time data (not using data warehouse). Has anyone ran into this issue? What options do we have? Thanks, Frank

Are there any known issues with runnig Jaspersoft Studio 6.3 with the 6.1 version of the server? What setup is required in order to do this? Thanks, Frank

Hello Hozawa, thanks. How would I then create a parameter that uses a query to obtain its select list values ? thanks, Frank

Hello, I would like to schedule a report with default selections in a parameter. The parameter needs to be dynamic, like a select list that generated from a SQL Query. This way, items selections in the parameter are dynamic with what is available in the database and we can change our selections if we want before re-scheduling the report. Do I need to do this with an input control, parameter or both? Thanks, Frank

That makes sence, Hozawa. Thank you. will give it a try after some security setup. Frank

Hello, my question regards the Scheduler File System Output, if "Output to Host File System" is set to true (with checkbox), I understand that a file can be saved reporting server's file system. But what if a mapped drive was created on the report server? For example, if we created a mapped drive named Q:that was actually mapped as a share on another computer, could we output our reports to the Q: drive then? Thanks, Frank

Hi, there doens't appear to be a way to add variables or parameters in the subject line or body of the e-mail (notification section) when scheduling a report. For example, if we wanted to include a date range parameter in the subject line, how would we do that? Thanks, Frank

Hi Hozawa, thanks for your reply. That may be so, but I actually did find a solution that woks perfectly. During my discovery, I tried the horizontal layout, but everytime I tried to set the horizontal layout, Report Studio would re-arrange the order of my columns! Horizsontal Layout also wanted each field width to remain a fixed width and did not render properly when I tried to change the width of one of my fields (I did not want it to wrap). Solution: I had to remove all the fields and column headers and start over. I set the details section and group header column bands to free layout. When I placed the fields and column header names on the report, I made sure all the fields were the same height. I also made sure that the corresponding column header static text in the group header band was the same height and width as the field in the details section. I also made sure that there were absolutely no gaps between the fields/column headers. This sounds like stuff we should be doing anyway, but it rendered to HTML in the body of our outlook e-mail perfectly. We are using Office 365 (so the latest version of outlook). Thanks, Frank

We have created a complex Gantt view in Crystal Reports using bar charts in which we have layered several bar charts for the purpose of displaying multiple milestone types. I see that we can also layer charts in Jasper Studio, but wondering if we also have the ability to emulate the “Underlay Following Sections” property we used on a Crystal Reports section expert. In other words, if we have 3 details or 3 groups sections, we want the ability for each of the sections to overlay each other to appear as one seamless group. Help appreciated. Thanks, Frank

I have a report in report sutdio with about 3 groups and a detail section. This is a simple layout. I'm displaying 2 of the group headers and have my column headers on one of them. I'm using a free layout (this might be the issue). When I schedule the report, I select options: Output: HTML Notifications: Include report files as attachments Include HTML report in e-mail body The problem is that when I open the e-mail in Outlook to view it, the layout is very misaligned. Outlook gives you the otpion to view in a web browser, and then it looks OK in that, but I do NOT want the user to perform that extra step. The rendering in e-mail is awful and unexpected. How do I make HTML reports in e-mail look better? Help appreciated. Thanks, Frank

Sorry, I was able to use Evaluation Time property and set it to group I wanted and it works fine. Thanks!

Hello Hozawa, thanks I see the values being diplayed properly in the details section now with your syntax example, but when I move the variable field to the group header just above the details section, it doesn't work. You mentioned the defaults for the first group, but not sure I will always want to "hard-code" a default for the first iteratiion of group (if that is what you meant). Also, when placed in the group header, Manger is displayed as Employee. So, Im thinking I need to learn how to use the evaluation time options avilable, but not sure the correct combination. Any help appreciated. Thanks, Frank