Search results for query: *

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?

Thanks Ian. That worked perfectly. I have another question. Do you know how to set Crystal to always print 3 copies of a specific report without it printing 3 copies of every report. Further, is there a way to get "Copy1", "Copy2", "Copy3" on the bottom of each page? Thanks L

I am trying to create a Bill of Lading which displays the following detail lines along with a block to text which does not change, and which prints on the right side of every page of the BOL. The detail lines are a subreport in GH2. Example Page 1 Line, Qty, Item, Descrip, Gross Weight | I...

Thanks LBass. I will try it tomorrow morning when I get to work.

LBass - you solution works. the issue was that I was trying to make variable drilldown versions for each group and Crystal did not like this.

How do I set up parameter to do the following If the user wants to see "Completed" WIP then ask for a date range. If the user wants to see "Incomplete" WIP, don't ask for a date range. Any help is appreciated. Thanks