Recent content by CrystalLion

In Report Studio, I have created a data item that equals only the digits found in a Character field, such as If([Additional Information] contains '4') then ('04') else (...etc. I would like to cast this result as an integer, and compare it to the dd portion of a DATE_TIME field. What would the...

Nice Ties Blom. I will try this.

Can someone provide specific guidance on how to display only the Group Rows and Total Row Report Column 1 is Grouped. It is Variance indicator (Y or N) if Total Balance 1<>Total Balance 2. Column 2 is Loan ID with Count of Loan ID grouped by Var Column 3-5 are dollar amounts I want to...

yes - they are

The Package contains View_A and View_B. View_A contains Table_A and View_B contains Table_B. the tables are properly linked. The tables have common data objects like: View_A,Table_A View_B, Table_B Loan_ID Loan_Number Principal_Amt Prin_Amt I want to compare...

doesn't work. No matter what I try I get a parsing error. Your suggestion generates: QE-DEF-0459 CCLException QE-DEF-0260 Parsing error before or near position: 18of "if[database..etc..... QE-DEF-0261 QFWP - Parsing text: if[Database View...etc... I've been at this all day to no avail. Could...

what is wrong with this statement? If([Database View].[A_HISTORY_VW].[DIM_ACCT_NAME] STARTS WITH 'AL_HE_ARM') then 'HELOANS' Thanks [morning]

Thanks. I am giving it a try now. I'd like to add another data item to the crosstab. I'd like to see Value and Count. However, the count is not based on the Product level, it's based on the individual Accounts that belong to the Product. something like: Product | Curr Mo Bal | Curr...

Ideally I would like to have one report with data from two reporting periods, which would be user prompted. Something like: Product | Curr Mo Bal | Prior Mo Bal | Change Pernsup | 300 | 500 | 200 Widget | 100 | 200 | -100 All...

I am new to SQL Server Management Studio. Using SQL Server 5, version 9.00.1399 -------------------------------- select TOP 100 PERCENT dbo.A_DIM_TIME.DIM_YR_MO,dbo.A_DIM_TIME.DIM_YR,dbo.A_DIM_TIME.DIM_MO, dbo.A_ALM_HISTORY.DIM_SOURCE_SYSTEM_ID, dbo.A_DIM_SOURCE_SYSTEM.DIM_SOURCE_SYSTEM_NM...

I am new to Cognos Report Studio. I am trying to create a filter something like the following. ([Database View].[A_ALM_HISTORY_VW].[DIM_FILED_NAME] does not start with('Auto','Con','Other') what is the correct syntax for this. Thanks[bigears]

The current hierarchies do not support my desired drills. Am I correct in deducing that I need to ask for a change in the hierarchies in the universe?

Old Crystal user, new to BOXI Web Intelligence. Trying to supress sections. Report SECTION on Town Name: Barrington Warren Bristol etc. Next SECTION on Street Name Arnold Ave...

I have an Excel workbook with many sheets. Everytime I try to save it, it starts a "file conversion in progress" and then tells me I can't save the VB Project functions it appears to be finding. I do not recall creating any VB functions, nor have I created any macros, but for some reason it...

If I don't want them collated, do I place the subs in two separate report footers? If I DO want them collated, where do I place them?