Recent content by kristal9

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