Blackbaud User Society - Forum

Subject: New Fund not showing up in CR - by: jas.

Thu, 16 May 2013 19:32:36 +0000

First of all, do you have CR set to save data with report? If you do it won't refresh things until you tell it to.

Second, did you tell CR to verify the database? That makes it look and make sure everything is up to date.

Also, the query the report is based on includes all funds and appeals, but does the export have any filtering in it? That could cause a problem.

Subject: "contains" - by: jas.

Thu, 16 May 2013 19:29:45 +0000

I usually use InStr.

InStr({field}, 'text')

evaluates to the position of the start of the string in the field, or 0 if it's not there.

If InStr({field}, 'text') <> 0
then 'true'
else 'false'

Peter's way is easier. I don't know why I've always used InStr.

Subject: Event Table Layout - by: Melissa Siobhan

Thu, 25 Apr 2013 21:06:17 +0000

Have any of you been able to take the seating assignments in the events module and create a report which is a visual representation of the table layout with the names of the folks on it. They do not necessarily need to be at each seat - a list inside of a round table visual would be enough. Is this best done using export and crystal? Word merge? I am just not sure how I could do this so that changes to table assignments in RE can in the quick running/refreshing of a report reflect the new table layout map.

Currently there is exporting and cutting and pasting going on which is never efficient. I expect there will need to be a new one for each event since table layouts are different at different events but that is at least only one time vs the number of times people re-create the layout and update RE as more people RSVP and needs change.

Thanks for any suggestions you can make.

Melissa

Subject: ODBC Datasource in Custom Report - by: lowcountrygenius

Thu, 25 Apr 2013 15:11:31 +0000

OP asked specifically about using Crystal with ODBC connections to work with their own stored procs.

Moving to a new reporting or BI tool means learning a new skillset and potentially buying more software and training. If readers want recommendations of other BI tools, JasperServer is also web-based, has a powerful free/open source edition, and has a much larger user base with more documentation and free video tutorials.