Search results for query: *

I'd like to use two separate screens during my presenation. I am familiar with Dual monitor capabilities in Windows and have 2 video cards in my machine. Does anyone know how I can show two different presenations at the same time so that I only need to click once to get both screens to...

I'm trying to program my macro to know whether a query is already open before it attempts to re-run the query. Anyone know the easiest way to do this?

I'm trying to set the default value for a control to be a value from a query. The query is filtered based on the key field therefore there will always be just one record. My coding currently is as follows: Default Value = [QrySel_User_Preferences]![Show_Rejected] Unfortunately this is not...

I'd like to schedule Access to create a report and send to it a specific email address. Using the SendObject command I can get Access to create the email with the attachment but it doesn't populate the TO: field and it doesn't attempt to send. Does anyone have experience commanding Lotus note...

How do I get Access to automatically execute a macro when the database is opened or closed?

I have a table [Categories] with a list of categories and their corresponding maximum income. CATEGORY MAX_INCOME Category 1 $20,000 Category 2 $30,000 Category 3 $40,000 I have another table [Incomes] with an Income value. I'd like to be able to go...

I'm trying to connect Crystal to an MS Access database. The Access DB has tables within it that are linked to a secured AS400 ODBC DSN. When attempting to connect to the Access database Crystal says that I do not have permissions for the linked AS400 table. Anybody know why Crystal isn't...

I have 24 fields in my database. One for each month for 2 yrs with numeric values. JAN03 FEB03 MAR03 .... NOV04 DEC04 It was necessary to setup the database this way to minimize the record volume. I'd like the report to display the last 12 months depending on a selection that the user makes...

I produced a Report using Crystal v8.5 connected to a ODBC MSAccess datasource. The connected query is a Access Crosstab which has several subqueries and 2 parameters (Yr & Mo). Recently our company purchased HammerLaunch v2.2 (A Crystal report viewer developed by Hammerman Associates) which I...

I have a few Crystal Reports linked to an Access database that I would like to distribute. I'd like to retain the dynamic abilities of the report. The Access database is on a shared company network drive that everyone has access to and the reports are linked through a ODBC connection. Our IT...

I'm looking for a guide or documentation related to writing formulas in SAP BW Business Explorer Analyzer. I've been looking for something like this for several months now with no luck. I even bought an expensive book and it only scratches the surface. I've searched websites include SAP.com...

I have a Lotus Domino table linked to my Access database through an ODBC driver. (LotusNotes SQL Driver.nsf). The table views fine and I can build basic queries from the table. However if I do anything in the query at all such as add a filter or enter a formula I get a call failer error...

I'm just beginning to introduce myself to SQL coding. I have a simple Crosstab query that produces just 2 columns when executed. [FY'02]& [FY'03] I'd like to add a third column that will provide the difference between the two which would represent the yearly growth. I didn't think this should...

I'm looking for some documentation on Advanced B/W query building. I've purchased the book SAP B/W Reporting made easy but it doesn't get too advanced in formula writing etc. Anyone know of any good BW Query Writing documentation?

Seems like a simple issue but I haven't been unable to find a solution anywhere. I'd like to allow my users to choose which parameters to filter by. If a value is not given for a specific parameter I'd like to report to include all values for that field. For example, using three fields...

Looking for a BW Reporting Forum or resources to learn more about Business Explorer. Can anyone point me in the right direction?

Does anyone know what types of values can be used to create a maps in Crystal? Specifically, can Crystal recognize ZIP Codes as geographic areas?

I'm trying to apply a filter using the Select Expert to a chart within my report but I don't want to apply it to the whole report. Just the Chart. I see where you can use "Top N" separately in a chart but how do you filter a chart separately? Anyone know?

I have a chart (as a subreport) in Group Header 1 and I have Subtotals and Grand Totals in Group Footers 1 & 2 respectively. When I format Group Header 1 to "Underlay Following Sections" it underlays Group Footer 1 but Group Footer 2 is unfortunately displayed beneath the chart. All...

I'm connecting Crystal to an Access Union Query. Everything is working fine and my data is displaying correctly. However the SQL coding is adding unwanted Parameter fields to my Crystal Report. I'm not sure why... Here is a portion of the SQL code from the Union Query...