Search results for query: *

Any suggestions pls??? Thanks, Jothi

Hi Gurus, I have requirement to create filters/prompts for the user to select Top N/Bottom N records on the selected measures from drop down. Scenario: I have 13 measures, Client Name and Employee Name in crosstab User will enter values for Fiscal Year/Period. Requirement is: 1. User wanted...

ANy help is appreciated.

Here is the image links.. <a href="http://www.mediafire.com/imageview.php?thumb=5&quickkey=a63ds4seh9stwe9" target="_blank"><img src="http://www.mediafire.com/conv/b25636ce2ebe920c06df47d08cb7368d7b8b60e15a13f6eab5bcc84e8358eef74g.jpg" border="0" alt="Unlimited Free Image and File Hosting at...

Any help on this will be appreciated :(

Hi, I have a manual crosstab with 20-25 fields in detail section, Would like to horizantally display lines. scenario is: Each Deal can have multiple Media/territories....etc.. and someitme only one. I tried with mutiple detail section suppressing details as per Deal for the lines but it is...

Thank you but I have more than 50 fields that need to show on report that is one the reason the user want to know if they can customize the fields. Do you suggest still to create the detail section of all the combination of the fields .. Pls advice Thanks JN

Hi, I have a requirement similar to thread149-655589 but would like to get the fields in one parameter and User can select fields they want to display on report. ?{Praram} should have list of values Deal IP Territory Media Language How to get these values into Parameter and user select...

how about keep the subreport data to export and just dont let the user see it. :( I know it might be crazy but the designing decision depnds on the scenario Pls help. Thanks JN

Thank you, Tried this but what if they don't want to see the details of a subreport at all and only the link but still able to export the main & Subreport?. Is there a possibility?. Pls advice Thanks, JN

this is user requirement: Usre want a main report report with summary and link to another report in detail. They may or may not click on the link to view the details but if they export the report it should export to excel in 1 sheet. I have started designing yet. Pls advice accordingly...

Can you explain in brief how can I achieve it pls? Thanks, JN

Hi, I have a main report with a On Demand Subreport and would like to export to excel. While trying I see only the main report data and Subreport as a link and not the data of the subreport. Can you please shd some light if I'm missing anything?.. Thanks, JN

Grouping on just deal and not media. Using a Hierarchical Grouping option under the "Report" Tab. I'm able to display the Deal as drill down hierarchy. Is it possible to display the number as we did it for 2 groups.

Thanks Lbass, What if I have just one group?. What would be the formula though?. Sorry to bug you like this but your formula always works out for me.. Thanks again, JN

I don't understand what field lvl1 and lvl2 are coming from. Are these instances of a group? ---> LVL1 nad LVL2 are comming from Deals which is a group You say you have a group #1 on Media and a group #2 on deal number. Please show some sample data that shows media, deal number and whatever...

Here are the links for the report http://www.mediafire.com/?zajjcp92yj98l0v or <a href="http://www.mediafire.com/?zajjcp92yj98l0v" target="_blank">http://www.mediafire.com/?zajjcp92yj98l0v</a> I want to display number onlastrecord and as well as 1 level before onlastrecord. Thanks, JN

Not exactly the same number I'm using a group on Media and Deal Number. printing this number in Media Grpfooter. I'm also doing a hierarchy on Media. so drilling down the Media and would like to print this number on last level and before the end of last level. Media lvl1...

HI lbass, I'm using the below formula to print the number on last record if onlastrecord then "1234" Also tried with if onlastrecord and previous(dealfield) then "1234" but i'm getting an error on previous function. Pls advice, thanks, JN

Hi, I trying to print last record using onlastrecord function and it is working fine but I would also like to print lastbeforerecord. pls help, thanks JN