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

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

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

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

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]

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

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

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

I am trying to create a report which will tie together three subreports, each subreport using one table. The tables are: Bookings, Invoices, and Backlog. Each of these tables contains three fields: Area, Group, and Buyer, as well as Item_Number, etc. The sub reports will all be grouped the...

I am trying to create a parameter that allows the user to filter items displayed based on a minimum variance percent. My variance formula is: if {Inventory_Status.Last_PO_Cost}= 0 then 0 else {Inventory_Status.Last_PO_Cost}/{Inventory_Status.Total_Standard_Cost}-1 So, for example, if the...

Main report is grouped as follows. G1 - ProgDesc from Program table Displays only the ProgDesc G2 - OrgName from Profile table Displays OrgName and Address G3 - Voucher# from ApLinesHis table (contains SubReport1) SubReport1 G1 - Voucher#...

I am runiing Crystal Reports XI against an SQL view of a Progress database. My reports are installed at several client sites. For some reason, when I go to populate the parameter dropdown list via the List of Values (select field) Actions Append all database values instead of populating the...

We have a CR XI report that uses a table called Fund in both the main report and the subreports. The table's primary index is FundID. Some Funds are connected to other Funds via a field called Master_FundID. So, in the Fund table the fields would be populated like this: FundID...

I am runiing Crystal Reports XI against an SQL view of a Progress database. My reports are installed at several client sites. For some reason, when I go to populate the parameter dropdown list via the List of Values (select field) Actions Append all database values instead of populating the...

I have a report with several sections. Evertime I run the report, when there Grants but no Gifts, it creates a proper page 1, a proper page 2, and then creates a page 3 with no information on it which contains my "this page intentionally left blank" conditional statement. I want to display a...

I recently installed the mentioned drive on my Dell PC. I am using Crystal Reports XI. When I installed the drive, I no longer had access to the ODBC tables associated with my main Database. I am using Windows XP Pro, SP2 Anyone have any ideas on how to overcome this?

My client recently implemented a new database server and transferred their database to it. When we try to run Crystal reports, it appears there is no centralized way of getting all of the reports to acknowledge the new server name. It's acting like I need to Set Datasource Location in every...