Search results for query: *

I just answered my own question! For anyone else who is interested here's how to do it: Open the report and from the menu, choose File > Export > Export Report. Choose Report Definition (TXT) from the drop down and either save it to a file or open in an Application. A text file is created...

Hi, I am working with a client in restructuring their reporting system. We would like to be able to export the formulas to compare them with similar reports for streamlining and possibly moving some of the logic into Stored Procedures. Is there a way to export the formulas into a text file or...

Hi lb, Thanks for the suggestion. The only stumbling block is that I also have a line in the chart showing volume so I'm limited to only 1 OnChgOf field. I'll probably set the values a and b to something meaningful and have them appear in the labels. Have a great day! -pb

Hi lb, My Chart has bars that read: 2006-a, 2006-b, 2007-a, 2007-b. The 'a' bars are yellow and the 'b' bars are blue and represent the national(a) or regional(b) sales values. My custom graphic legend indicates that yellow = National Sales and blue = Regional Sales. My customer just wants to...

Hi lb, In my chart, I have stacked bars and lines (1 OnChgOf and 2 ShowValues). The OnChgOf is by Year-a or Year-b and then bars for ShowValue1 and a line for ShowValue2. Year-a and Year-b are different colors and appear as separate bars even though they are stacked(another great workaround I...

Hi lb, The axis label formula is a string: totext(year(date),"#"). The sort value formula is also a string: If isnull(field1) then "a" else "b". I would like the a and b part of the labels to be "invisible". Thanks for your help! -pb

Hi all, I am using CRXI and SQL. I have charts where the On Chg Of formula is a concatenated string of 2 formula values. Is there a way to set the color of the second value to white (so it does not appear in the axis label). My formula looks something like this: {@axis label}&" " &{@sort...

LBass, that's it! Wow, thank you so much! I spent way too much time on this, should have written in sooner...!

Hi all, I am using CRXI with SQL. I have implemented the instructions from the Charting on Print-Time Formulas white paper and am getting the error "A subscript must be between 1 and the size of the array". I was able to reproduce the example from the white paper and the chart worked but...

Thank you both for the great tips! It did save some time to use currentfieldvalue!

Hi all, Using Crystal XI, is there a more efficient way to apply formulas to format fields? I have table style reports with 3-4 groups whose fields are the result of formulas. I overlay those fields with an 'N/A' text field and set the format to suppress if certain conditions are met on the...

Thought I would post this tip as I figured out the answer by trying different options after reading through several posts. I could not find a straightforward answer so hopefully putting it here will help someone else. I use CRXI and SQL 2005 and had a report with a text field description of...

Using CR XI with SQL, I have stacked bar charts where the stack is the sum of a formula. The result of that formula can represent one of 8 choices chosen by the user as a parameter (i.e. Type A, Method 1, Category 123). How can I customize the legend to show the dynamic value of what that...

Hi, Thank you for responding! Yes, the .bat file works on the same machine that CE is on when launched directly. In CE, I get the error regarding operating system credentials. The default Windows login on that machine is the administrator. Any ideas? Thanks so much for your help!!

We develop reports in CRXI Developer use CR Server to deliver them to the end user. We are now trying to launch a Program in CR Server which is a .bat file. The .bat file works great when launched within Windows but fails within Crystal Server with the error message "No operating system...

Thank you, makes sense, but I still am not getting all the names to show in the report. I am only getting names for which there is data. If there is no data, I still want to show the names with blanks instead of data. What else can I do? So glad to have all this help out there!!

Hi, help! I am running CRXI with SQL Server 2005 and use multi-value parameters for the user to select Names to include in the report. The Names table is related to other tables that have the data I need in my report. The report needs to output data for all the names selected, even if there is...

I've come back to this issue and still have not been able to resolve getting rid of the zero data labels. I tried using a formula outside of my chart: if distinctcount({fieldname}) = 0 then tonumber(@null) else distinctcount({fieldname}), then setting the Chart Expert to "Don't Summarize" but...

Using CRXI Developer and SQL 2005, I have data with records that include an event date and an event name. I want to display the dates in columns by month for each event name. Group 1 = event name and Group 2 = dates. Event name shows up in the Group 1 header. The dates show up in Group 2...

Hello, I am using CRXI Developer and delivering reports on CR Server 11 with SQL Server Express 2005. The reports include dynamic cascading parameters. After loading the report object in CR Server, I go to Process > Parameters and click on the Parmeter value to change the settings to prompt...