| my parameter problem [message #1059951] |
Wed, 22 May 2013 06:30  |
 4040 4040
Messages: 25
Registered: February 2013 |
Junior 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 4 times)
[Updated on: Wed, 22 May 2013 06:48] Report message to a moderator |
|
|
| Re: my parameter problem [message #1060089 is a reply to message #1059951] |
Thu, 23 May 2013 00:54  |
|
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?
Regards,
Michael Williams
BIRT Exchange
Michael's BIRT Blog
|
|
|
| Re: my parameter problem [message #1060188 is a reply to message #1060089] |
Thu, 23 May 2013 08:41 |
4040 4040
Messages: 25
Registered: February 2013 |
Junior 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 3 times)
|
|
|
|
| Re: my parameter problem [message #1060409 is a reply to message #1060277] |
Fri, 24 May 2013 10:09 |
4040 4040
Messages: 25
Registered: February 2013 |
Junior 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 10:10] Report message to a moderator |
|
|
|
|
Powered by
FUDForum. Page generated in 0.03209 seconds
] 
Search
Help
Register
Login
Home
