Search results for query: *

I have a report that summarizes a count by a region over a period of time. within the report i want to summarize the counts by week for the duration over time with a line chart. I want the label to read "Wk ending MM/DD" and the formula is written thus "Wk Ending...

({currentdate}+ 60)-date(1/1/1900)

Hi, CR 2008 and Universe data source I have a similar issue to this thread i found http://www.tek-tips.com/viewthread.cfm?qid=687354 but it does not solve my issue. I have a report that groups by Region. within the Region GHa I have a XTab that shows the Countries as Rows, the Months as...

Hi.. i actually just say Ian and your suggestion. Yep. It's the great idea. but because the report contains 3 sub reports I can't imbed them into a frame report as sub reports themselves.

Hi LB, thank you for your reply. the report parameter is actually used to perform the grouping by dimension, not select it. the BW query will limit data to 15 month. the CR Parameter will simply sum up and measure by the specific parameter. if for example the total sum of measure for the...

Hi, I have CR2008. I currently have one report that based on a parameter selection will produce five different result sets. The report will run on a schedule for each parameter to produce 5 separate instances exported as txt files. Is there a way to have all five combined into 1 txt file for...

[wiggle] I got it! i took the orginal report and first grouped asc by fiscal period so my earliest fiscal period would be first. then 2nd group by Account showing the top 10 accounts by month. Then with a sub report showing only the detail the fiscal period, account name, measure placed this...

You can say that again! Can't do stored procs with SAP. OMG [hairpull3]

Within that tab the only things not checked under Data Explorer were System Tables and Synonyms. I check both of those but did not see SQL Expression become avaialable afterwards. Or any changes for that matter. Any other options?

Hi Ian, thanks so much for your response. My source is SAP and I don't see SQL expression as an option. Is it available for SAP data source?

Hi... still trying to get to this... to recap I have 3 fields in my report. FiscalPeriod, Account, Measure. the requirement is to determine the top 10 accounts for the first fiscal period based on measure and then return ONLY those accounts for each FiscalPeriod a summary of their measure...

sub reports wont be an option because i already have multiple sub reports in the report and this would require each subreport have embedded within them. I found a work around in Excel by concentating values and doing a vlookup. However now i am running into too many rows issue. So back to...

Hi Dell, Yea. I thought of that. Datasource is SAP so I don't have add command option. Boo.

Hi Dell, Thanks for your response. That is correct. There are no parameters, nor start / end date. the query is simple fed the data and it will change weekly.

CR 2008 I have a report with Fiscaldate/Year, Account Name and Measure. the report will contain multiple fiscalmonths at a time. I need to sort the report first by fiscal month -ascending them by measure decending only for the first or earliest fiscal date. for all dates afterwards, i need...

thank you both! I really appreciate your time and help.

Thanks Hilfy for your response... I have applied this but am getting an error message in syntax where it's not recognizing dim_detail. I don't have any DIM tables in my database. I have only one or the other FACT table. is the "dim_detail.Name, decode({?Week/Month}, 'Week', week_fact.value...

Hi, Oracle, CR2008 I would like to set up a parameter "Week/Month" where it would prompt the user to select the value of either "Week" or "Month" and based on his selection, the report will return data from either the Week Fact Table or the Month Fact Table. There are no other tables involved...

I just learned that the database used for many Crystal report (XI R2) will be changing from SQL Server to Oracle. What is the impact of the crystal reports? do they merely need to be repointed to the new database and remapped? or will they need to be rebuilt? Any advice is appreciated. thanks!

Hi, Why wouldn't you just write a formula for meeting id and meeting date? For example @meeting_id If [EVALUATION_CASE].[CASE_CLAS] = "B" then [BOARD_MEETING].[MEETING_ID] ELSE If [EVALUATION_CASE].[CASE_CLAS] = "C" then [COMMITTEE_MEETING].[MEETING_ID] @meeting_date If...