Search results for query: *

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...

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...

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...

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

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

Hi, I have a crosstab with Media and Terrotory rows where Media has multiple values to a corresponding Territory. we have to print Media values in a single row for each territoy. Pls advice. Thanks, JN.

Hi , I'm trying to concatenate a field into single row nad was also suppressing the duplicate rows but the format that I desired is different. Can you pls help if suppressed a row then I dont want to show a empty row. I tried with concatenation from this forum and was able to print But I do...

Hi, I have a Crosstab with Fiscal year as column , Bex structure as row and Amount as Summary. I'm trying to do a cumulative calculation for specific rows in a crosstab. Pls guide. Thanks JN

Hi, Tried with the search and didn;t found a solution and posting the code to see if someone can help me out. Below is the code I'm trying and it is a string.I'm getting a String is Non-numeric error. Pls advice if isnull({ZGCB_M01_ZBOBJ_ZGCB_M01_QFIN_ANLSIS1_V7.[0FISCYEAR]-[20FISCYEAR]}) or...

Hi, I'm new to this forum and found very informative solutions in the site. Coming to my question: I have designed a Crosstab report in Crystal reports 2008 with SAP BW data source and trying to print Total of countries. Problem i'm faving here is: I want to print Present + previous years...