Skip to main content



      Home
Home » Archived » BIRT » my parameter problem
my parameter problem [message #1059951] Wed, 22 May 2013 06:30 Go to next message
Eclipse UserFriend
Hi,


my requirement is:
1) geography-------->separate listbox

2) country------------separate cascading parameter
city
...etc


3)to drop table like i)mrp
ii)buy
iii)etc....

4)and then i want to select year,quarter,month

5)which type likewise i want to select value-wise like 1,2,3 or percentage-wise

kindly add payment date in this report............for year,quarter,month

my question is when i select in geography value and then i have to drop a table,and then i want to select a year,quarter,month,percentage-wise or value-wise

and then again i will select from cascading paramter and then i have to drop a table,and then i want to select a year,quarter,month,percentage-wise or value-wise


and then when i select year it automatically change the quarter,month for particular year.....like wise...


i have run both by separate it run ......good


when i combine in same report it cant be run....so it possible to exceute in same report



i have attached a report ...here

can u modify a report and send to me

kindly help me.....its urgent


thank u .....
  • Attachment: A.rptdesign
    (Size: 124.76KB, Downloaded 277 times)

[Updated on: Wed, 22 May 2013 06:48] by Moderator

Re: my parameter problem [message #1060089 is a reply to message #1059951] Thu, 23 May 2013 00:54 Go to previous messageGo to next message
Eclipse UserFriend
I'm not sure I'm understanding exactly or not, but if you select your geography and want the chart's x-axis category to match that field, you could write an expression for the x-axis field. Then, when you select your country and city parameter, your query will change the data by parameter. Dropping the appropriate chart already works fine. Changing the chart value to percent or value would be done in the chart script. Selecting the time period would just be another change in the query. What part of this is where you're stuck?
Re: my parameter problem [message #1060188 is a reply to message #1060089] Thu, 23 May 2013 08:41 Go to previous messageGo to next message
Eclipse UserFriend
thank for reply ....

you are understood correctly.......wt i want...but my probelm...

i)first i select geography it want to change chart's x-axis category to match that field is work fine then i have to drop a table work fine,and then i want to select a year,quarter,month,percentage-wise or value-wise--am not getting this- paramter selection------>this is separate way to run the report


ii)at that same time again i will select country and city parameter, query have to change the data by parameter then again i have to drop same table for this parameter too,and then i want to select a year,quarter,month,percentage-wise or value-wise am not getting this- paramter selection for this report

if u look at this report u will get only selection of country and city parameter only passing paramter not for a geography selection so check it well and give solution for this report

kindly can u able to create sampledb with my requirement with
year,quarter,month,types


thanks in advance
  • Attachment: report
    (Size: 126.48KB, Downloaded 365 times)
Re: my parameter problem [message #1060277 is a reply to message #1059951] Thu, 23 May 2013 15:50 Go to previous messageGo to next message
Eclipse UserFriend
If I was understanding correctly, here is the report that does all of this, except I didn't do the year,quarter,month deal. Let me know if we're getting closer.
Re: my parameter problem [message #1060409 is a reply to message #1060277] Fri, 24 May 2013 10:09 Go to previous messageGo to next message
Eclipse UserFriend
first of all thank u very much....for a example which u given ..its perfectly running........

i have attached a screenshot......

again it struggle a lot...(i.e)if i don't have data in databases it generate a error script are produced

give some idea how to remove error..and then if i dont have value in databases at that time i have to produce some alert msg like......
"there is no data like that...."

its helpful if u give idea .......

thank u in advance again for wonderful post......to help me.....

[Updated on: Fri, 24 May 2013 10:10] by Moderator

Re: my parameter problem [message #1060474 is a reply to message #1060409] Sat, 25 May 2013 00:13 Go to previous messageGo to next message
Eclipse UserFriend
kindly reply for this post.....


thank u very much....
Re: my parameter problem [message #1060646 is a reply to message #1060474] Mon, 27 May 2013 09:03 Go to previous messageGo to next message
Eclipse UserFriend

Hi..

kindly reply for this post.....


thank u very much....
Re: my parameter problem [message #1061047 is a reply to message #1060646] Wed, 29 May 2013 12:28 Go to previous message
Eclipse UserFriend
To avoid something like this, you'd just need to check if the series was null before trying to check the series identifier. If it was, you'd stop doing any script and then could show a text in your report letting you know that the data was null. Hope this helps.
Previous Topic:Designer plugin classloader exception
Next Topic:Printing labels horizontally
Goto Forum:
  


Current Time: Mon Mar 24 16:57:05 EDT 2025

Powered by FUDForum. Page generated in 0.05010 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top