mnoland2
-
Posts
26 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Everything posted by mnoland2
-
I seen in the 5.0 server download some reports the discripition show "parameter isJasperAnalysis=true/false" but can't seen to find anything on "isJasperAnalysis" what is this parameter and how does one use it ?
-
yes both can be pased with the "domain Parameters" in Ireport under the palette in the tools section drag "domain Parameters" into your report this will alow you to add the Logged in user , and logged in user roles
-
I just installed so far I have a few comments/questions setup - Wow this migh be easy for a Java developer but for your avrage report writer you have a long way to go befor the avrage user will be able to use this as a Ireport replacemnt UI - finding things is a bit of a problem. Not sure how i got the outline to come up (showed up after right clicking on the report desighn prospective and selecting reset) still have not found the Palette once i found the "cheat sheets" this helped some but... How can you tell what band is what in ireport there was a watermark in each band to let you know that the band was (in the designer screen).
-
Is ther any way to use the other fusion Charts ? Any of the CombinationSingleY style charts are what I am working with right now, I see alot of the widgets as my next project
-
Nope:( just about any thing to do with what is in the element (fonts, fills,borders,...) but not the size of the element
-
I was able to do this by making each page it's own sub report using the "no data" bands for pages with no data elements.
-
Have you tried seting the ignore pagination setting under the report's properties
-
is there same way to set the Height and width of new objects IE when i drag a new "static text" element in to my report off the palette it is 35X100 then i have to resize it to fit the report (15X35).
-
I have don this with changing the page size of a report in i-report
-
I want to create a report that would have many pages of "boiler plate" text with some fields on some pages and 2 list reports on pages 12 and 14. I can't seem to find any way to create pagesto drop the "boiler plate" onto. Any sugestions ?
-
has any one created a report that would list all the reports housed on a JS and what roles/users can say read/write/admin ? something like : Report name roles user permisions ------------------- --------------------------- --------------- ---------------- Report A User Joe_user read User superuser admin admin superuser admin Report B admin superuser admin
-
also have the ability to revert to a prior "version" of the report would be nice !
-
We are using a report we built using this SQL SELECT DISTINCT "jiuser".fullname , date_trunc('minute',"jiaccessevent".event_date) as "accessed on" , "jiresource".label AS "report label" , "jiresourcefolder".label AS "folder label" FROM ((public.jiresource "jiresource" INNER JOIN public.jiresourcefolder "jiresourcefolder" ON ("jiresource".parent_folder = "jiresourcefolder".id)) INNER JOIN public.jiaccessevent "jiaccessevent" ON ("jiaccessevent".resource_id = "jiresource".id)) INNER JOIN public.jiuser "jiuser" ON ("jiaccessevent".user_id = "jiuser".id) WHERE ("jiresourcefolder".name NOT IN ('Beta', 'Beta_Reports', 'datasources', 'DataSources', 'datatypes', 'domains', 'Domains', 'Domain_Topics', 'images', 'Images', 'Input_controls', 'Input_Controls'))
-
I want to create a report that has a listing of all the reports I have on my Jasper server and what "role" has access to that report. has any one done this or have any ideas on how i would go about this ? I have createed a report of user by role (see code below) if everything went well I would want to join this up to a list of reports this user has access to Code:SELECT "jiuser".username , "jiuser".fullname , "jirole".rolename , "jiuser".enabledFROM (public.jiuserrole "jiuserrole" INNER JOIN public.jirole "jirole" ON ("jiuserrole".roleid = "jirole".id)) INNER JOIN public.jiuser "jiuser" ON ("jiuserrole".userid = "jiuser".id) ORDER BY "jiuser".username ASC
-
I am sure i am missing somthing here, but i want to have a report write back to the DB when the report is run in Jasper server the SQL is simple but i can get it to work on the jasper server SQL insert into bi.jr_input_demo values ($P{Branch},$P{user_input_1},$P{user_input_2}); commit; select * from jr_input_demo Post Edited by mnoland2 at 12/22/2010 23:45
-
I was able to make this work a little better by excluding things like datasources, and Input_controls (see the where clause) you may need to chane the "date_trunc" and where statement depending on youre setup Note this only shows if the user accessed a report. Code: Post Edited by mnoland2 at 12/01/2010 22:35
-
Not sure if ireport or iserver is the place to post this but her goes I have a report with a subreport in the title band i want to pad in the "max pages" to the subreport so that the pages on the subreport would have the right max page # right now the subreport will have "page X of 10" then on page 11 the main report starts and has "page X of 26" how do i pass the 26 into the subreport ?
-
Is there some way to set $P{loggedinusername} inside of iReport ? I have a prompt that does a SQL query to give me a list to pick from and this query uses the domain parameter $P{loggedInUsername}. Now the only way I have to test it is to put it out on the jasper server login in ot that and run it then use the "log in as another user" to test it for other users. there must be a better way to do this. Any ideas ? Post Edited by mnoland2 at 10/13/2010 16:58
-
Highlite all your data elements/fields ($F, $V) right click select "Padding and Borders"
-
why not put a left and right border on your cells ? Post Edited by mnoland2 at 10/08/2010 15:45
-
How would i do somthing like $X{IN, full_name, '%' || parmeter_name} is SQL it would look somthing like where full_name in ('%'|| (select last_name from emp where last_name = 'smith')) I.E. return all employees with the last name "smith" from a full name field
