Recent content by Cores

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