Search results matching tag 'Crystal Reports'

Upgrading from MS Server 2000 to MS Server 2008 and RE 7.71-7.85

0a3802b3-2d5a-4e3d-9b4f-8aed74fae16d — Fri, 20 Nov 2009 17:09:40 GMT

Are any of you Upgrading from MS Server 2000 to MS Server 2008 and RE 7.71-7.85? We are doing this at Wycliffe, and I actually built the server in the Summer, but due to issues with our Serenic NAV upgrade to NAV 5.02, RE was sent to the back burner.

We have reprioritized the RE upgrade now, and it is back at the top of the list...though NAV is still working through the bugs and issues.

Have any of you completed this upgrade, or are any of you doing this now, or are contemplating doing this soon?

I would like to touch base with you and see what you dealt with and maybe get some good tips. :-) Also, how did it all work with your existing Crystal Reports?

Thanks,

In His Service,Franklin KingApplications AdministratorWycliffe Bible Translators407-852-3623 (Office)407-883-8562 (Wireless)407-852-3601 (Fax)franklin_king@wycliffe.org

Can you expand the details section based on the size of a field

34a14d94-74d3-43d2-96d7-f3aecc1ed2c4 — Thu, 19 Nov 2009 23:19:20 GMT

I am creating a Crytal Report that will show write-off activity for a particular period of time. One of the fields we want to include is write-off notes. In a couple of cases the write-off notes are quite long. I know how to make the details section larger by dragging down the bottom edge of the section, but then I end up with a lot of white space where the notes are not as long. Is there a way to have the row size vary from line to line based on the number of characters in a field?

Re: Past Due/Custom Report Questions

34a14d94-74d3-43d2-96d7-f3aecc1ed2c4 — Wed, 11 Nov 2009 17:07:32 GMT

Unfortunately, none of the alternate report suggestions that forum member offered are going to work for the report my boss would like to see. So it looks like it will have to be a custom report using a gift output query that is created when I run RE' Past Due Report.

Among the columns my boss wants to see on the report are total pledge amount, pledge balance, and the delinquency amount. The delinquency amount is where it gets a little tricky since there is no "delinquency" or "past due field" available in the field list of the export. There is, however, a field called Number of Consecutive Missed Payments that I could use in writing an equation to figure out the delinquent amount. The problem is that when I did the export nothing exported into that column.

Does anyone know how to ge tthe Number of Consecutive Missed Payments field to populate in an export? Or does anyone one have a better way to due a custom "delinquency report"?

Package Performance results

fa58ed38-1e89-4e57-93e4-6768fcca6132 — Thu, 29 Oct 2009 20:19:37 GMT

Greetings,

I've made a report in CR that shows the package description, number of gifts and total gift amount. I have them grouped in specific orders and have them subtotaled by group (which is why the canned appeal analysis report doesn't work for me).

Anyway, now I need to include number solicited for each package, but how do I link the package number solicited to each package? I keep getting the same number for all packages.

Thanks,

Josh

Re: Multiple Gifts cause other fields to repeat in Crystal

1CECEF9D-36BD-4E18-BDA3-F91C35DD023E — Fri, 23 Oct 2009 12:49:56 GMT

Thanks. That worked great. The only problem I have now is that I want to add the notes field and there are multiple notes. Where do I put that field in order to ensure that the gifts all don't split between the notes? What is the rule of thumb for inserting fields with multiple values?

Multiple Gifts cause other fields to repeat in Crystal

1CECEF9D-36BD-4E18-BDA3-F91C35DD023E — Thu, 22 Oct 2009 20:46:35 GMT

I am trying to create a new crystal that includes the last 12 gifts (along with date, type, appeal). The report is grouped by the Constituent's sort key and I have included address information in the details section. I am trying to enter the gift information in the detail section. It has been a long time since I have worked on a report of this type and I don't claim to have Crystal mastered but I can't seem to understand why if a donor has more than one gift, the gifts are listed separately (instead of lining up one after the other) and the address fields repeat. I suspect that this is probably something simple, but as I mentioned, my Crystal skills are somewhat limited.

I thought I had Left Outer Joins figured out....

B053647D-4A55-4EDD-B341-58F2F04C6D2F — Thu, 08 Oct 2009 14:30:48 GMT

Here is the situation:

I have exported the following tables from RE:

CnBio CnGf_1 CnGf_1_Attr_Cat1 CnGf_1_Attr_Cat2

Joe 20 4 1

Steve 10 1 5

Kate 30 6 3

The sitatuon is that Joe only bought 4 adult tickets (did not have data in CnGf_1_Attr_Cat2), so Crystal XI pulled Steve's adult ticket purchase (CnGf_1_Attr_Cat1) into the "child ticket" field (CnGf_1_Attr_Cat2)

I have played around with several join options, but can't get it to look like it should which is:

CnBio CnGf_1 CnGf_1_Attr_Cat1 CnGf_1_Attr_Cat2

Joe 20 4

Steve 10 1 1

Kate 30 6

Thanks for your help. I need to find a good/affordable on-line training for stuff like this. Any suggestions?

Bryce

Countif

B053647D-4A55-4EDD-B341-58F2F04C6D2F — Tue, 06 Oct 2009 19:55:05 GMT

I have a column {@IF} that is based on a formula. It produces the following

CnBiosName (formula created column)

John Not Paid

Paul Paid

Ringo Paid

Ben Rothlisberger Paid

George Paid

I would like a count of how many "Paids" and "Not Paids"

Thanks so very much!

Bryce

If {field} contains

B053647D-4A55-4EDD-B341-58F2F04C6D2F — Tue, 06 Oct 2009 18:50:42 GMT

Greetings All,

It is easy enough to use IF in this manner:

If {CnGf_1Note_1.CnGf_1Note_1_Actual_Notes} = "Host Committee 2008 - Gala" Then

"Host"

Else

" "

But what function could be used to see if the field contatins "Host" rather than equals? I need this to be more flexible than looking for "Host Committee 2008 - Gala".

The LEFT function works okay for this, but I think contains would be better.

Thanks!

Bryce

CR XI not showing all relationships

B053647D-4A55-4EDD-B341-58F2F04C6D2F — Tue, 06 Oct 2009 15:41:31 GMT

I am doing some testing and here is what is occuring:

I export First/Last Name of the constituents and the name of individuals that are one kind of individual relationship.

When I open the .mdb file CR XI only sees CnRelind_1_01_Name, but not CnRelind_1_02_Name, etc...

Instead it puts the names from CnRelind_1_02_Name, etc. into the CnRelind_1_01_Name field for any records that DO NOT have any names in these relationships.

I have tried playing around with the linking, but being Crystal Reports does not see CnRelind_1_02_Name etc.. I think there is a more central issue.

Any help would be greatly appreciated.

Thanks

Bryce