Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CrystalLion

    Cognos 8.4 Report Studio cast character as number

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

    Cognos 8 - reports studio - Display on GROUPED rows

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

    Cognos 8 - idenfity descrepancies between two tables

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

    Cognos 8.4 starts with syntax

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

    Cognos Report Studio 8.4 - data from multiple periods in columns

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

    Select data from three tables - how to join SQL Srvr 05 Mgr Studio 9.

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

    Cognos 8.4 Report Studio Filter [field] does not start with

    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]
  8. CrystalLion

    BO Enterprise XI R2 drill/section suppression

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

    Unwanted VB Project in Excel Workbook

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

    CR XI - display text box on right side of every page

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

    If paramater 1 = Complete then enter parameter 2 - date range

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

    Subreport with Drilldowns

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

    Variable &amp; as a parameter - CRXI

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

    CR XI - Totaling a Shared NumberVar from a SubReport

    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#...
  15. CrystalLion

    CR XI - Parameters (populate list from db)

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

    CR XI - Main Report to Sub Report links

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

    CR XI - Parameter - Static List of Values - can't connect to db

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

    &quot;This page intentially left blank if page is even&quot;

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

    Maxtor OneTouch4 external backup Hard Drive

    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?
  20. CrystalLion

    Crystal 10 - Client changed db file server location

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

Part and Inventory Search

Back
Top