Search results for query: *

Hi, using Crystal XI release 2 on a SQL database. I have two tables in a subreport that look like this: Table: Carry Investor Inv Short Name Year Distr Inv1 Inv1 2002 100 Inv1 Inv1 2003 100 Inv1 Inv1 2004 100 Inv1...

Hi, using Crystal XI release 2 on a SQL database. My data looks like this: Investor Inv Short Name Entity Year Deal Date Amount Inv1 Inv1 Fund 4 2011 ABC 2/4/11 100 Inv1 Inv1 Fund 4 2011 DEF 2/4/11 50 Inv1 trust Inv1...

Hi, I'm using CR XI release 2 on a SQL server. I have a subreport that is being grouped by Investor, Type and Entity. The data also types of transactions (Cash, Loan, Fees, etc.), their amounts and the date of the transaction. Is it possible to show the details (by date) for 1 transaction...

Hi, Using CR XI release 2 on a SQL database. I have a textbox with text in my page header that is filled in grey with white text. How can I make a white line appear on top of it? Sort of like a custom underline. I tried to 'move' the line to the front and the textbox to the back, but it...

Hi, using CR XI on a SQL database I've got an investor statement type report, grouped by investor, fund type and fund. In the details section, I have deal level detail. I'm pulling 2 amounts in there. So for each deal if those 2 amounts are 0, I have an asterisk to indicate there is a...

hi, using CR XI release 2 on a SQL DB i have the following data set: Date Cash Received Date Cash Distributed 1/1/09 500 1/10/09 200 2/21/09 1000 2/21/09 1500 3/31/09 5000 4/1/09...

Using CR XI sp2 on a SQL DB. Hi all, The Suppress Blank Subreport doesn't seem to be working properly for me. Does anyone know how it really works? Like what is CR looking for when the box is checked off? I've got a report with multiple subreports and when there is a blank section, I want...

Hi, i'm using CR XI on a SQL db. my data looks like this: Investor Date Tax 1 1/1/07 20% 1 1/1/08 25% I need the details sections to return just the most recent tax rate of 25%. There should not be a scenario where there are two tax rates on the same date. any help...

Hi, I'm using CR XI release 2 on a SQL database. Here is a sample of my data: Investor Combined Name Capital A 100 B 200 B1 B Combined 100 B2 B Combined 300 C1 C...

Hi, working with CRXI release 2 on a SQL database. i have a report that is grouped by 'investor name' the problem is that in my report i need to consolidate the report for some investors. but their names are different so i created a formula to group by: if {Main.Combined Investor Checkbox}=...

i'm using crxi release 2 on a sql database. verify database should look at my table for changes that i've made to it. sometimes when i delete or add a field, it says that the database is up to date when it is not because a deleted field will still appear and new fields will not be available...

Hi, i'm running CRXI Release 2 on a SQL DB. This is what my data looks like. for every investor there are multiple contacts. using either the full name or the cc name field, i would like to display all of the contacts names like this 'C1, C2, C3 and C4'. i no i have to use variables and...

hi, i'm using CR XI release 2 on a SQL DB i'm trying to get a page footer to return the 'legal entity' where the PCAP column number = 1. this report is grouped on type, investor and a contact. when i try to just bring in 'legal entity' it will change depending on where i place the field GH...

Hi, running CR XI release 2 on a SQL DB i have a formula that is based on a true/false parameter. this is how it reads: if {?1st Year of Fund} = true then "CAPITAL COMMITMENT" ELSE "UNFUNDED COMMITMENT " & {Fund.Start Date} if my 'start date' is 1/1/2007, the format of {Fund.Start Date} is...

I'm using CR XI on a SQL database i have a report where it should generate multiple reports per investor. For example, an investment report for 1 investor who will have multiple contacts i need to build the report for. When i print this report out, i would like for only 1 copy of the report...

I'm running CR XI release 2 on a SQL DB. I have a text box that is composed of 3 fields. Shares, Security Type and Company Interest Field Datatype Shares number Security Type string Company Interest number My issue is that the data that shares is being pulled is goes...

i'm using CR XI release 2 on a SQL DB. for a field 'termination date', if the field is null, then i would like crystal to say "N/A" else 'termination date' so my formula is this: if isnull({Position.Termination Date}) then "N/A" else {Position.Termination Date} but i get an error saying that...

Hi, I'm using CR XI release 2 on a SQL server. I'm building a report that is grouped by employee, type, subtype and year The issue I am having is that the sections are not 'kept together' even though at every group, the 'keep together' box is checked off. I would like to know if its...

hi, i would say i'm an intermediate crystal user. the report i need to build seems very simple, but i am having trouble designing it correctly. i am using CRXI release 2 with a SQL server DB. any thoughts/tips would be greatly appreciated. its basically a compensation report for all...

I'm using CR XI. I can connecting via OLEDB (ADO) command to a SQL table. My command looks like this: folder.reportname "Legal Entity={?Legal Entity}" FLAGS[/SILENT] I would like for this parameter "Legal Entity" to be passed through so that I do not need to change any of the filters on the...