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 Rhinorhino 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: *

  • Users: JaC74
  • Content: Threads
  • Order by date
  1. JaC74

    SQL-92 Join Type

    Does anyone know why Oracle can not support the following join? select a12.COLUMN_1 COLUMN1, (a11.COLUMN_1|| a11.COLUMN_2) COLUMN2, a12.COLUMN_3 COLUMN3, a12.COLUMN_4 COLUMN4 from L_TABLE a11 join F_TABLE a12 on (a11.COLUMN_1||a11.COLUMN_2) =...
  2. JaC74

    3-Tier MS Access Connection Issue

    I am in the process of creating a quick prototype from a MS Access database stored in a network folder. Here is what I have done so far. I haved made sure that the logon used by the MSTR machine has access to the folder and the MSTR server instances is started with the same login. From the...
  3. JaC74

    Max(Date) as custom attribute

    There was a similar issue posted last year but I don't think there was a solution to it. Here is the issue: We have an attribute qualification filter that uses custom between statement with an embedded value prompt: ApplySimple("year(date(#0) - 2 MONTHS)*100+month(date(#0) - 2 MONTHS)"...
  4. JaC74

    Report Filter Option In Web

    Here is the issue, any help will be appreciated. I have a report with a secondary prompt. Once the report is returned, I go to menu option View / Report Filter. The Report Filter options does not display what was selected in the secondary prompt. Is there a way to expose this through a...
  5. JaC74

    Dynamic Date Range Prompts

    Any insight on this issue will be appreciated. I am trying to create a report where the metrics will be calculated based on date range(two prompts). Here is the tricky part. The prompts have to be attribute element list prompts. The second prompt must be populated using the first prompt...
  6. JaC74

    Relationship filter ignoring VLDB setting

    VLDB was set at report level to use look up table as the where clause driving tables. However, my relationship filters ignore this setting. For example: Report filters on Location and Time. All passes without relationship filter has where clause such as "WHERE LU.Location = 5 and...
  7. JaC74

    Hierarchy Prompt Min / Max

    The min/max qualification for hierarcy prompt does not work. For example, create a new prompt and choose 'Choose from all attributes in the hierarchy' option. Select a hierarchy, then check the box 'Choose default prompt answers'. On the next screen, check Minimum qualifications, and Maximum...
  8. JaC74

    Dynamic Dating Based On User Input

    Is there a way to use dynamic dating based off of user inputed date instead of the 4 choices provided (Today, This Week, This Month, This Year)? I have a client who wish to create a report to track marketing campaign. Here is how the report should run. Upon execution, the user enters a...

Part and Inventory Search

Back
Top