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 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...
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...
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...
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...
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...
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...
Hi,
I am using CRXI Developer, SQL Server and delivering reports on Crystal Reports Server. I have charts that use Year in the legend. Year is a formula: Year({datefield}) which displays as a 4 digit year in Developer (i.e. 2004). On CR Server, they show up as 2004.00. Is there a setting I'm...
Hello,
Using CR Developer XI and SQL 2005, I have created a stacked bar chart with data labels. The stacks in each bar are based on 6 different formulas that return a value if certain criteria are met (if criteria=true then table.field). So my Show Values in the Chart Expert has 6 formulas...
Hi,
I'm using CRXI Developer and SQL Exp 2005. I need to have a line chart overlay a bar chart. I can set the line chart background to transparent and remove borders, but how do I get it to line up accurately with the bar chart underneath? Everytime we run it with new data, the alignment...
Using CRXI Developer and SQL 2005 Express, I am developing a chart. The ‘On change of’ is by time period. I have a set of events for each time period and each event has an event type. Event type can be one of 6 known values. I need to create a formula that will sum data by time period, by...
Using CRXI Developer and SQL 2005 Express, I am developing a chart. The ‘On change of’ is by time period. I have a set of events for each time period and each event has an event type. Event type can be one of 6 known values. I need to create a formula that will sum data by time period, by...
In CRXI Developer, I am developing reports to deliver on CR Server using an ODBC connection to SQL 2005 Express. I have a table with a date field and want to create cascading(dependent) parameters where the user can filter which data to show in a chart by a chosen time period. The desire is to...
In CRXI bar charts with parameter prompts with multiple values, how can the order of the bars in the chart be set by based on the order the parameter values were chosen by the user? Reports are delivered in CR Server.
Thanks for any help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.