Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » my parameter problem
my parameter problem [message #1059951] Wed, 22 May 2013 10:30 Go to next message
4040 4040 is currently offline 4040 4040Friend
Messages: 78
Registered: February 2013
Member
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 187 times)

[Updated on: Wed, 22 May 2013 10:48]

Report message to a moderator

Re: my parameter problem [message #1060089 is a reply to message #1059951] Thu, 23 May 2013 04:54 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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?

Michael

Developer Evangelist, Silanis
Re: my parameter problem [message #1060188 is a reply to message #1060089] Thu, 23 May 2013 12:41 Go to previous messageGo to next message
4040 4040 is currently offline 4040 4040Friend
Messages: 78
Registered: February 2013
Member
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 242 times)
Re: my parameter problem [message #1060277 is a reply to message #1059951] Thu, 23 May 2013 19:50 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Re: my parameter problem [message #1060409 is a reply to message #1060277] Fri, 24 May 2013 14:09 Go to previous messageGo to next message
4040 4040 is currently offline 4040 4040Friend
Messages: 78
Registered: February 2013
Member
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 14:10]

Report message to a moderator

Re: my parameter problem [message #1060474 is a reply to message #1060409] Sat, 25 May 2013 04:13 Go to previous messageGo to next message
4040 4040 is currently offline 4040 4040Friend
Messages: 78
Registered: February 2013
Member
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 13:03 Go to previous messageGo to next message
4040 4040 is currently offline 4040 4040Friend
Messages: 78
Registered: February 2013
Member

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 16:28 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Previous Topic:Designer plugin classloader exception
Next Topic:Printing labels horizontally
Goto Forum:
  


Current Time: Sun Aug 18 03:41:00 GMT 2019

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

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

Back to the top