Search results for query: *

I am using sub-reports because the user wants to add to existing report an ability to select multiple programs and regions. In original report, the user could select only data for one program and one region or "All" regions option. Selecting multiple programs and regions, they want to display...

Thank you very much for your quick response and your help. But two problems still exist. First, running the report takes a much longer time to run - maybe because I added a second sub-report. With the formula you suggested, the report was summarizing data for all regions (if "ALL" regions is...

Hi Dear Experts, I am using Crystal Reports for Enterprise. Is it possible to change grouping depending on selected parameter? There are two Multi-select Parameters: 1)Programs 2)Regions or "ALL". Main Report has two groups - Programs and Regions. Main report has no data, only grouping...

Hi kray, yes, the first sub-report that declared shared variables is in the group header of main report and the second sub is in report footer of the main report. I can see that the second sub-report displays only the last group value from first sub-report. The second sub contains the...

Crystal Reports for Enterprise Hi Experts, In order to display percentage previous records in group footer of main report, I placed a sub-report in the group header of main report. The sub-report calculates running totals that are placed into shared variables. The main report retrieves the...

Crystal Reports for Enterprise Dear Experts, I would appreciate if you can help! How to create Percentage of Previous Record for FY group? Here's a sample of data. The entries with stars are latest in FY. Selection Group Filter: Activity Date= Maximum(Activity_Date, Fiscal Year). Region1...

Thank you once again for your time. I have accomplished the report by creating the query for users with secondary assignments (Converted rows to columns). Then joined it with the query for users with primary assignments. The following is the query for converting the rows to columns: SELECT...

Thank you very much to both of you! Sorry, (It is my fault!)I did not mention that the users want a report in Excel.They want data for secondary assignments to be displayed in a separate column.

CR 2008 Hi dear specialists, please help me with the idea how to CONVERT ROWS TO COLUMNS. We have data in the following way: User_ID Assignment Type COTESYL EMSS Primary COTESYL NSSS Secondary COTESYL NCSS Secondary COTESYL MANAGER Secondary ELBAFA NSSS Primary ELBAFA NCSS Secondary...

Thank you very much for your response, Dell.

Thank you lbass.

CRXI There is a subreport in the report. The subreport contains two fields - project_id as a link to the main report and allocate_amt in Details section. But I am using Group Footer to display the last record of the report always with the summaries. So I need to put another subreport with the...

Thank you once again - the report works.

Hi Ties Blom, Thank you for your response and so detailed explanation. I am working. But, honestly, I am so new to Cognos (having only Crystal experience)so that i have more questions. I have created value prompt and used statis choices dialog. You are saying "create 2 dataqueries, identical"...

I am new in Cognos. Please give me an idea what kind of prompt to use and how to create query calculation to filter. I need to create a parameter Report Status. (2 choices: Due within 30 days or Overdue). If "Due within 30 days" is chosen, then the report will return records where Due_Date...

Interesting formula..., but unfortunately, there are a few tasks that do not have NULL values, so I can't use this formula. Thank you LB

Thanks lbass for your time. The Null values are from the view and this row with null values was created intentionally to meet other requirements as I understood. Thanks again for suggestions lbass.

Thanks Lbass for your reply. I was trying inserting the formula you suggested. But the results are not as expected. I have found that the report originally was not as I showed in previous message. Each task has at least two rows and the last row per project has NULL values and they were already...

Hi, I am using CRXI Currently report shows: Task number Permitted Rewarded Balance 1 1200 150 1050 1 1050 350 700 2 200 150 50 3 300 150 150 3 150 100 50 3 50 50 0 The user...

Thank you lbass. I will try to suppress a group footer if summary amounts are zeros.