Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Report series customize
404040
<p>Hi,i have doing a one report with Report parameter 1) ALL as Radio button ii) Country as listbox iii)year</p><p>so if i have click i) <strong>All</strong> it have display all value of Before Lastyear sale,last year sale,current sale by grouping only but ii) if i have select a <strong>country parameter</strong> for example: if i select USA chart and then i will compare a series with check-box for Before Last-year sale,last year sale,current sale </p><p>so i have attached a report for u r reference kindly go through it and correct the report and provide solution for this .....</p><p> </p><p> </p><p> </p><p>thank in advance</p>
Find more posts tagged with
Comments
kclark
<p>Do you need all as a parameter by itself or would it work for your requirements to have an all option in your country drop down?</p>
404040
<p>thank u for reply ..sir .<strong>A</strong>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]<strong>ll</strong> as a parameter by itself[/color] and <strong>Country</strong> as separate drop down like that it have ....</p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]so if i have click i) [/color]<strong>All</strong>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] it have display all value of Before Lastyear sale,last year sale,current sale by grouping only but ii) if i have select a [/color]<strong>country parameter</strong>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] for example: if i select USA chart and then i will compare a series with check-box for All, Before Last-year sale,last year sale,current sale [/color]</p><p>kindly provide sampledb</p><p> </p><p> </p><p>[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]thank in advance [/color]</p><p> </p>
404040
<p>kindly reply for this post....</p><p> </p><p>thank u in advance</p>
kclark
<p>I didn't include the year in this but it should be easy enough to add that to the checkParams() function in the javascript of the parameters page. I created a custom parameter page that checks to see if "All" is selected. If it is then the "Countries" parameter is disabled and moved back to the default selection if it has been changed. If the country is changed then the All parameter is changed to unchecked but it left enabled which will allow the user to select this and clear out the country selection. In the report there are two data sets. The first one is used for the parameter page and the second is used for the chart. The second data set checks to see if "All" is selected, if it is then all of the data is pulled in and displayed on a line chart. If it is not selected then I modified the query based on the users selection and just that country is displayed in the chart. I'm having troubles trying to attach right now, can you email me so I can send you my example?</p>
404040
<p>thank u sir for reply <span style="font-size:12px;">i dono have u r mail address so kindly send me to my Email.id====>psk4040@gmail.com</span></p><p> </p><p> </p><p><span style="font-size:12px;">thank u .....</span></p>
kclark
<p>I've emailed you an example report. Let me know if you have any questions!
</p>
404040
<p>[font="arial, sans-serif;font-size:13px;"]Thank u for reply ,i have run the example its working prefectly and that is i needed...but i have another [/font]requirement[font="arial, sans-serif;font-size:13px;"] in that report...so i had attached a screenshot for u r reference and i sent to u r mailed ...[/font]</p><p>kindly provide solution for this report......by sample db</p><p> </p><p> </p><p>thank in advance..</p>