Search results for query: *

Hi, I am doing a report with a main report and sub reports; there is two drop down parameters box: one parameter shows 4 Fiscal Quarters and another parameter shows 6 Fiscal Years. Is there any good idea to convert date consistently and how to SQL programing in the command for parameters...

Hi hilfy, I do not have access to update the universe. But I already fixed the issue. I found there are build in Functions such as Week, LastDayOfWeek, etc. from Variable Editor. Thank you so much for your help! Nice99

Hi hilfy, I think I can fix the Monday, Sunday, but the number of weeks of the Year, such as Week 1...Week 52, please let me know if you have experience. Thanks for your help! Nice99

Hi Hilfy, Thank you so much for your help, yes, the report should start on Monday to Sunday, but the formula did not convert any day to the Monday of the week, example: I using Qualification: Dimension Type: Date Formula: =RelativeDate([Order Date]; -(7-DayNumberOfWeek([Order Date])-1))...

Hi, I am a new to design WEBi report, is there anyone have experience to create the report Count by week based on order date for months? example: Group name product order date ..... ...... 03/22/2011 ..... ...... 03/12/2011 ..... ...... 03/08/2011...

LB, The formulas work great! Thank you so much for your help!!! Nice99

LB, Thank you so much for your help, the report looks much better, the Page Header b and Page Header c show up correctly for Report Footer a and Report Footer b BUT only one issue: Page Header a show up all time for other two sub reports, any way to suppress? Nice99

LB, Thanks for your response! I have tried, but all page titles contain a SQL statement with calculations; it cannot add those SQL together and run the report, and the sub report cannot insert another sub report in side of the sub report that is why I have different sub reports inserted into...

Hi all, I am using Crystal Reports 2008 against Oracle database 10g: There are 5 sub reports in the report, one sub report inserted in the Group Footer, two sub reports inserted in the Page Header b (sub1_title) and Page Header c (sub2_title), two sub reports inserted in the Report Footer...

Hi kray4660, The issues have been fixed. Thanks for your help! Nice99

I am using Crystal 2008 and Oracle database 10g I have an employee data report; there are main report which display general information about the employee and several sub reports which select multi records about the employee training, education, awarding, work assignments etc. The report group...

Hi lbass, Thank you much for your help! May I know which category select to export after follow the format? Microsoft Excel 97-2000(xls) or Microsoft Excel 97-2000-Data only (xls)? It will apply to report header too? Thanks again! Nice99

Hi all, I am using Crystal Report 2008 and Oracel 10G database. Is there anyone having good experience how to export from Crystal to Excel without row and column merged? Customer required no merged row and column for Excel files, they need clear know the each fields from which row and...

ibass, The formulas work great, thank you so much for your help! Nice99

Update, Sorry, the subject posted was wrong, it should be "Group header did not show on second page" I will deleted and post again. Thanks, Nice99

Hi lbass, Thank you very much for your help! I have sub reports placed in Report foot b and Report foot c, yes I did checked "new page before" on these two sections. Report foot a have grand totals for main report. Thanks again! Nice99

Hello All, I have report that contain two sub reports. Using Crystal Reports 2008, Oracle 10G database The mail report and two sub reports all have multiple groups and calculations for all category totals, summaries, they have different titles, the link between them only for the record ID...