TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Christine Droll <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 6 Feb 2015 15:14:52 +0000
Content-Type:
multipart/mixed
Parts/Attachments:
text/plain (1790 bytes) , Capture.JPG (74 kB) , Capture1.JPG (22 kB)
When you create a new Crystal Report, you must set the connection to your TMS museum database. Once you set that connection, create your report with specified fields from the Tables and Views, and then set the parameters. Once that's done, click F5 for the prompt to either use the current parameter or set a new one.

Christine

Christine Droll
Registrar, Database & Collections
The Nelson-Atkins Museum of Art
4525 Oak Street | Kansas City, MO 64111
p 816.751.1333 | f 816.751.0499
[log in to unmask]





-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Williams, Scott
Sent: Thursday, February 05, 2015 8:36 AM
To: [log in to unmask]
Subject: Using CR to query for objects


Hi all — 

Is there a way to write a Crystal Report such that it includes objects which are not in the current TMS object result set? I would like to write a report so that users can simply refresh the crystal report, enter new parameters and get a new set of objects. Currently, they have to 1) search TMS, 2) run the report 3) save and close all windows 4) re-query TMS 5) re-run the report and export. 

I feel like I have seen this in the past but can’t track down just how to do it. 

Many thanks — 
Scott





To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2