Search results for query: *

V.10 xml data with ADO.Net ~I have a report that uses a subreport linked on: Subreport Param = ?PM-AssetYear.Value Select Data in Sub = True Linked on AssetYear.Value ~When Crystal uses these settings the report works correctly. ~The problem is that Crystal is changing the Select Data in...

V.10 xml data with ADO.NET driver ~I have some bar charts that disply % on the vertical axis. ~Chart is calculate on change of @AssetClass Sum of@GetValuePct ~@GetValuePct = whileprintingrecords; {@GetValue}/{#AssetValueTotals} ~@GetValue is a complex formula that gathers asset values...

V.10 XML data using ADO.NET driver I have some chart where colors are conditionally set based on a formula. For example: Formula Value = All Cap Equity then Green Formula Value = Cash and Equivalents then Red etc. User can dynamically affect Formula Value such that I can't set all...

V.10 xml data using ADO.NET driver I have a report that uses a subreport inserted in Group Header 1 to obtain a value that would not otherwise be available. Although the report works when I change my datasource and hit update for both the main and subreports, the old subreport value still...

V.10 XML data using ADO.NET (xml) driver Account Asset Table joined to SubAccounts Table in a 1 to many relationship. Two columns in my report look like this: Net Equity % of Net Equity Group 1 10,000 Net Equity/Total Net Equity Details 5,000...

V.10 xml data using ADO.Net driver Assume I have tables structured as follows: -Asset Table inner join on AssetYear Table -Asset Table left outer join on SubAsset Table -SubAsset Table left outer join on SubAssetYear Table My problem is that in certain conditions I want to pull records from...

Version 10 XML Data using ADO.net driver I would like to build a report that allows users via parameter to select columns for display, and shrink up when not in use. Has anyone every figured out a way to do that with Crystal? Thanks, Ebutter

Crystal V.10 XML Data using ADO.Net driver I have a difficult chart coloring requirement to satisfy. I'm wondering if anyone can think of a workaround. Assume: 1. Pie Chart Report 2. Segments show Asset Values grouped by "Asset Class". 3. Pie Segment Example: Global Equity--$124,000. 3. Asset...

Crystal v.10 XML data using ADO.Net driver I have a four column report like this: Asset Name Beginning Value Growth% Income% There is also two grouping levels based on good sized formulas. This simple report is taking over 1 min to load--I assume because of all the complexity in...

V.10 xml data file accessed with ADO.net driver I have a number of bar chart reports that have $ on the vertical axis and something called Asset Class on the horizontal. Asset Classes are a property of an Asset. They are also a property of SubAsset. Assets may have 0 to many SubAssets. In...

V10 xml date with ADO.net driver I have several bar chart that have Year on the horizontal access. This is a parameterized chart that responds to how many years the user wants modeled. I've used Chart Options/Grid/Group Axis tab/Labels/Show Labels to create the year labels. The Year field is...

V.10 Does anyone know a way to control a text object border's line weight? I can't find a property to access this. Thanks!

v.10 I need to conditionally change the font size of some text objects in the Details Section. On the Font Tab I can access a formula editor for the field, but I can't figure out the syntax for making the change. Pseudo Code: If Field1 = X then Font Size = 11 else Font Size = 12 Thanks!

V.10 xml data with ADO.net driver Bar Charts allow me to resize and thereby reformat legends to multi-columns. My Pie Charts do not. They snap back to single column. Is there anyway around this? Thanks!

V.10 xml with ADO.net driver This is related to the previous question. Is there anyway to control how many columns appear in a Pie Chart Legend? I have up to 19 fields which makes for a long legend chart. Thanks!

V.10 xml with ADO.net driver I have some pie charts that can have anywhere from 1-19 wedges. It is driving me crazy trying to find a way to stop overlapping values when very small slices end up next to each other. Any thoughts? This must be a common problem. Thanks!

V10 xml data with ADO.NET driver I am using Crosstab objects to build some reports. I need to be able to conditionally suppress rows. The following doesn't work: Year1 Year2 Year3 Row Label 1 20,000 21,000 22,000 Row Label 2 0...

V10 XML data with ADO.NET driver I have to build a cross-tab style report like the following: 2005 2006 2007 etc. for 30 years Asset1 value value value Asset2 value value value The report will also be grouped in various ways. I have...

Crystal V.10 XML using ADO.net driver I'm having trouble trying to make a record selection formula work. I've stripped it back to the essential stuff so as to make it understandable. This is a huge question-- if anyone dares wade in I thank you! The report selects asset records based on...

V10 XML file with ADO.NET driver I have the following record selection formula in a report that groups and lists assets: {Asset.ObjectType} <> "Disablility Insurance" and {AssetYear.Value} = {Revision.planyear} and ({Asset.ObjectType} = "Stock Option" and {ReportOptions.rptbsinvestablechkbox}...