jasemilly
-
Posts
89 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by jasemilly
-
Hi In your sql where statement you want where ($P{dept_name} = 'ALL') or (dept_name = $P{dept_name} on the Input Control You need another entry called ALL I tend to create a sql statement that would select my departments and then union in 'ALL' I would create an exra field that containd 'A' for the All entry and 'b' for my normal departments and order on this field. 'ALL' is now the first entry it works great for me. I struggled along time on this one. regards Jasemilly
-
I have created a report and it all works fine in ireport. I have uploaded it to the repository and created a user control, which is a date type. But when I try and select the report through jasperserver I get an error about converting data type string to date, but I cant see anywhere where I have created a string and not a date. This is the first time I have tried to pass a date to a subreport in Jasperserver, like it says it works all fine in Ireport, Am I missing something. I have attached more info on the error. thanks jasemilly
-
Hi I would like to create a percentage for an item against the report total is this possible? thanks
-
Hi I have my reports appearing as I want them formatted in Ireports preview and the web browser. But when I upload to the repository and view the report underlines and colored bands and styles dont appear. Does anyone have any ideas what I need to check or alter for the formatting to appear better? thanks Jasemilly
-
I have it working, a slight change in thought and it's much less complex. the where statement now just looks like this where ($P{myrange} = 'ALL') or ([id] = $P{myrange}) it works perfectly the user gets everything if they select all or an indiviual range if thats what they select. I have expanded it to include a few other user options to increase flexibity with out lots of complex SQL statemtents or other form of control logic.
-
yes it's an sql statment and range is a field name
-
I got the If statement from a search and it works fine for them. The user has a long list of range codes to filter on or I would like them to choose All, which would effectively mean no filter. I know you can do if statements in sql just the format a little unsure of. thanks jasemilly
-
Hi guys I have this condition where IF($P{Usr_Rng}<>'All',Range = $P{Usr_Rng}, Range <> $P{Usr_Rng}) and it says incorrect condition near IF and I can't see whats wrong!!!!!! the parameter Usr_Rng is a string. The user will be promtped with a list of Range codes and the word All as the first choice. If they choose All then this statement should be false and everything not like Range should be selected, if they choose a range then the condition is true and it filters on the desired code. But I can't see whats wrong with the syntax Any ideas would be much appreciated
-
Hi everyone Don't know what I have done. but when I go tools/report inspector nothing happens I can't get to my variables or parameters etc for my report. how do I correct? thanks Jasemilly
-
Hi Trying to get this going and I think I am missing something very basic, if anyone can point me in the right direction that would much appreciated, From searching the Forum I have Created a Parameter called LoggedInUser I have set the parameter class to com.jaspersoft.jasperserver.api.metadata.user.domain.User I am under the understanding that this is a hidden class and the username should just pull through to the parameter. But when I try to run the report in Ireport.I get a class not found exception, which kind of makes sense sense the report isn't in the repository. How can I create this parameter point it at this class, and still test it in I report. Then get it working when I move the report to the repository?? Sorry if I have been a little stupid and thanks in advance for you assistance this has got me puzzled. thanks Jasemilly
-
Hi I have created some reports and what I would like to do is pass the username in jasperserver to the actual report. This would allow me to filter the report for that actual user, I am sure I read that this is possible but I can't seem to find any infomation. If someone could point me in the correct direction that would be great. many thanks Jasemilly
-
Hi I was runnig a repot in Ireport that was taking an age to run. I ended task on it and started it up again. Now the program starts but minimises back to the task bar it has been like this for 20 minute? Is there some check point flag that needs resetting very puzzled. thanks Jasemilly
-
I have the styles working showing if a value is good or bad. But I have a rectangle box across the width of the detail band this alternates between green and white just a nice banding effect. But the field no longer allows the colour underneath to come through I have played with the opaque tick box but to no difference. I only want the field to be red otherwise I want it to be the colour of rectangle box beneath. thanks Jasemilly
-
Hi everyone I have a calculated field and if the value it contains is <=0 I would like the actual text box colour to be red how do I do this? thanks Jasemilly
-
Hi I have noticed a parameter called subreport_dir, the value of which is a folder on my local c drive and the folder I save my reports in. should I alter this value to repo: ????? or some other value thanks
-
I was being a little stupid I have found that directory and my subreports were already in there. So left with the problem why is the error message saying it's trying to open subreports from the c drive? thanks for any help!!
-
I can't see any such directory I may be being a bit stupid.
-
Hi I have a report that contains a couple of subreports that works great in I report. I have uploaded each subreport into the repository I then uploaded my main report. When I run my report from JasperServer I get an error saying report cannot be found and it references my c drive not the repository. I changed the links when I uploaded the main report. Pointing the references for the sub reports to the repository. I can't see what I am doing please help!!!!! I have a presentation tomorrow argh!!!!! thanks Jasemilly
-
I have created a Cube in JasperAnalysis Schema Workbench, and creating a little text query when I try and run it. I get the message data truncation. But I can't see anything regarding field sizes and since it is a select query why would field length matter? Thanks JaseMilly
-
Hi Wanting to foramat a heading report to display 2010-11, the user enteries a parameter of 2010. I thought I would create a variable that would use a if type statment to hold the format like below. A text box would be assigned to the variable, Tried it and the report just flicks back to design mode. Any suggestions? $P{Year1} = 2010 ? "2010-11" : $P{Year1} = 2011 ? "2011-12 : $P{Year1} = 2012 ? "2012-13" : "0000" thanks
-
Hi I have 2 subreports in the detail section on the master. I can retrieve a parameter from the first subreport and display it's value in a text field in the master report. I thought it would be easy to pass this value to the second subreport but it seems a little harder than I thought. any help would be appreciated. thanks
-
The main report holds 3 sub reports the other 2 sub reports appear fine no problems. The thirs sub report just isn't there. I am assing the varaible a value from within the report and then doing a simple if statement saying If the variable value is > then 16500 then "passed" else "fail" thanks Jasemilly
-
I have a very simple report that accepts a few parameters and contains a variable. It all works perfectly fine. I then added this report as a subreport and it doesn't come up as a sub report. It was all working fine until I added the variable. Is there anything that needs setting when your sub report contains a variable?? thanks
-
Hi I have 3 sub reports that work fine their own right, a mix of order intake and actual sales infomation on any given customer. I have created a master report that contains nothing apart from the 3 sub reports. I have created the parameters in the master report and tied them to the subreport. The Datatypes match but when I run the report it says no pages to display. I know that this is incorrect as when I run the reports indvidually they return data what am i doing wrong?? thanks Jasemilly
-
I am creating a subreport and the last part of the report has a section where it says a customer has achieved enough sales to be a goldstar customer or star customer. The preceding report shows one figure that is how much they have sold over a given time period. How do I pass this figure from one report to the last one? I then want to say if the value is > then xxxxxxx 'goldstar' achieved and another field tha says if value is > then xxxx 'star' achieved. I am a little stumped thanks for any ideas in how to achieve this. jasemilly
