my parameter problem [message #1059951] |
Wed, 22 May 2013 10:30 |
4040 4040 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 271 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 |
|
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 |
4040 4040 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 354 times)
|
|
|
Re: my parameter problem [message #1060277 is a reply to message #1059951] |
Thu, 23 May 2013 19:50 |
|
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 |
4040 4040 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 #1061047 is a reply to message #1060646] |
Wed, 29 May 2013 16:28 |
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.04429 seconds