Search results for query: *

Hi guys, Using CR XIR2 with Enterprise Repository. I think I have a simple question. I am creating a report with multiple groups. Each group can be drilled down to addition details. When I finally get down to the Details section, I show a bunch of fields. I want the field names for those...

Hi Guys, Using Oracle 10g and CR XI 11.5 I have a simple crosstab report that shows sales across product groups, for specific products, and across the provinces/states. Here is what I mean: Columns - Provinces/States Rows - product_group, and then product_id itself So, my results get nicely...

Hi there, Using CR 11.5 Have a really simple question to ask that I can't solve. In a formula, I try to get the year of current date like this: year(currentdate) it returns 2,010.00 I need to turn this whole number into text using cstr but when I do that, I get "2,011.00" How can I get...

Hi guys, I have an easy question: I am using a Running Total but I want it to reset on the change of not one group but multiple groups (Product_Type, Year, and Month). How do I show in the x-2 (Use a formula) option of the Running Totals window, that it should reset when 3 groups change...

Hi there, Using CR 8.5 and Oracle db 10g. I have a variable that maps provinces/states in a certain way. Some times the province field (from db) can be empty or null. And whenever that happens, I want that province to be mapped to the province called "Other". I obviously use a formula with...

Hi there, Using: CR 11.5 with Oracle 10g db I have a cross tab with multiple rows and multiple summarized fields. I need to add a formula as a summarized field. I create the formula but when I go to the Crosstab expert I do not see it the 'Available Fields' tab, even though I see it in the...

Hi folks, Using Crystal Reports 11.5 I needed to pull data from different data sources - one is the Enterprise repository and the other is a local Oracle database. The purpose of the report I am trying to create is pretty simple - Product category sales by province/state and compared to...

Hi there, I have created a report in CR 11.5 with date prompts. When I preview the report within CR, the prompt shows up, no problem. However, when I publish it to Enterprise Infoview portal (for end user access) the prompt does not get published. It publishes with the data that I refreshed...

Hi folks, Using: CR 11.5 Data Source is a data warehouse universe I am trying to create a huge report part of which looks like a cross tab report. I pull from the universe: PROD_ID, NET_UNITS, YEAR When I pull all three fields into the the Details section I get this: PROD_ID YEAR...

Hello everyone, Not sure if you can help but I am stuck with this query. I have a view that looks like below. I hope you can read this table. ITEM_ID|STAGE |COUNT|TRIM_SIZE|BINDING 2083109|BUDGET |512 |8 X 10|| 2083109|P.N. |464 |8 X 10|Perf Bnd| 2083109|R.T. |432 |8 X 10||...

Hi, Using: PowerCenter 7.1.5 Database : Oracle 8i Source table has a column (SOURCE_COL) with string data type but has date values in it, in this format '09-MAR-2007' Target table has a column (TARGET_COL) with date data type. The date format in this database is 'MM/DD/YYYY' So, I use an...

Hi everyone, I am using Informatica 7.1.5 with Oracle 8g database. Ok here is my situation Our current ETL tool is DataStage and we bought Informatica and we are in the middle of converting all of our existing ETL jobs. So what I do is, redesign an existing ETL job in Informatica to do...

Hi folks, I am new to this forum and to Informatica, and looking for your help ... I have a SQL and related PC Designer question Running PC 7.1.5, pulling from Oracle 8i and pushing to Oracle 8i Ok here is the thing: In Oracle when I create a join between two tables and the join columns...

Folks, I researched how to do running totals in Oracle, and found that Oracle has analytical functions like OVER . However, when I tried this simple query it keeps giving me an error message ORA-00923, that a FROM keyword is expected right somewhere around the keyword "ORDER". Please see...

Hi, Using: CR XI R2 and Oracle 8i I am trying to create a high-level dashboard using CR, that shows the following information in a bar chart. YTD SALES ACTUAL VS YTD SALES BUDGET YTD RETURNS ACTUAL VS YTD RETURNS BUDGET YTD NET ACTUAL VS YTD NET BUDGET Now I have created one sub-report to...

Dear Folks, I am using Oracle 8i and CR XI R2 (11.5) I have a simple summary report which gives me a summary view of YTD and LastYearYTD Sales. Range of data that I am pulling: {SALE.INVOICE_DATE} IN YTD OR {SALES.INVOICE_DATE} IN LastYearYTD I then group by the year field {SALES.YEAR}...

Folks, I have a very simple query. Using: Oracle 8i and CR XI R2 ------------------------------- I am pulling data with the following record selection: {TABLE.INVOICE_DATE} in YearToDate however, I don't exactly want YTD which pulls until today, I want to pull ONLY until yesterday I tried...

Hi, Platform: BO CR XI R2 (Version 11.5) and Oracle 8i I am trying to create a MTD report. I can't use CR's "MonthToDate" feature because our fiscal Calendar Year is set up differently than the "normal" calendar year. For example, our months don't begin at the 1st of every month but rather the...

Hi, Using: BO CR XI-R2 (ver. 11.5) I have a list of 30 items displayed in a report. Is there a way of displaying this list in 3 columns, lets say each column showing 10 items? Thanks, Mirogak

Dear All, USING: BO Crystal Reports XI-R2 11.5 and Oracle 8i ------ I have been asked for a dashboard to show Sales Reps performance in a YTD and MTD "view" compared against Budget. Here is the Desired Output: --------------------------- SALES_REP_X YTD_NET_SALES YTD_BUDGET (and the...