Search results for query: *

That didn't work lbass. I wrote the formula and it didn't work with or without the Suppress check box selected. mirogak,

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

LB, That worked. Thanks my dear. I am so happy we have women in our company. Ciao. Miro Thank you Ian too but I rather have the columns separate.

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

Yes, mr griffin, that worked. ty

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

Thank you bass ... that worked.

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

Thank you. That worked.

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

Not sure what you have suggested up there but I followed it. Here is what happened: - the formulation does work - the formula now appears in Crosstab's Available Fields When I drag that new formula into the detail or group header sections of the report it works great BUT when I pull it in the...

I thought the running total made sense for this requirement, since I have monthly net sales and they need to be added up for a YTD net sale and reset when the product type changes. Here is how the Running Total is set up for the YTD Net Sale: Summarize : Query1.Net Sales Evaluate : for each...

Sure. The report itself is sales report showing previous monthly sales and comparing them to monthly budgets. It also shows YTD sales (adding up the monthly sales including current YTD) and compares them to monthly budgets (adding up the monthly budgets). It groups the sales by product...

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

Thank you Bass and chelsea ... this worked like a charm.

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

Another thing to add would be to make sure that in CR the option "Save Data with Report" is unchecked under the "File" menu.

Yes, thank you Mr. Turk. Just clicking "Next" without touching the prompt values solved my dilemma. Thanks, Mirogak

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

Thanks lbass. It worked like a charm. Earlier my problem was that I was grouping on the Year and it didn't work but grouping on the Product worked. Cheers, Miro