Search results for query: *

Hello: Years ago, I composed SQL reports for a client and placed them on a tab in Business Portal 4.0 (SharePoint). They all worked fine. The reports pull from views that contain simple select statements with "UNION ALL" clauses delineating the data for each of the three company databases...

Hello: I added a Document Library, as a web part in the header section of a SharePoint 2007/Microsoft Dynamics GP Business Portal 4.0 (32-bit) page. I do not get any issues with actually adding this Document Library web part. But, depending on how I use this web part, I get the "Server Error...

Hello: I have Crystal XI running on Windows 7 with SQL 2005. In SQL, I created a login in the "Security" folder. Subsequently, in the Data Sources section of Administrative Tools in Control Panel, I created a SQL Native Client ODBC connection with this login. This DSN Name is the one that I...

The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a click of a button in the Add-Ins tab. On one monitor, we see the Excel spreadsheet containing this data that we "push" with this Add-In. When...

I have a Crystal XI report containing inventory items. These items come from a SQL 2005 table. In this report, I also have a subreport that pulls the item quantities from an Excel spreadsheet. These items and quantities are in a group footer. When I generate this report, the data in both the...

Hello: My main Crystal XI report has inventory items in it. I have a column to the right of these inventory item IDs that contains the quantities of those items, and those quantities are pulled from a subreport. (This subreport pulls from an Excel spreadsheet, while the main report pulls from...

In a Crystal XI report, I have a subtotal report that shows inventory quantities for each inventory item on the main report. I have placed this subreport onto the main report as a column. I want to have the main report display a grand total for each amount in this subreport. In order to try...

My main report is an inventory report that prints data based on fiscal periods where "PERIOD 1" = March, "PERIOD 2" = April, "PERIOD 3" = May, etc. The main report shows this fiscal data, based on a parameter chosen by the end user when the report is refreshed. So, if the user choose "PERIOD...

Hello: I have a Crystal XI report that is made up of database tables from SQL 2005. I need to add a column to this report from an Excel spreadsheet. As far as I know, the only field (column) from that spreadsheet that matches any of the fields on the Crystal report (for linking purposes) is a...

Hello: I downloaded and installed the software and drivers for my Deskjet F340 on my new Vista Home Basic laptop. As I see from trying to scan and from reading numerous posts from similar users out on the internet, I see that the printer cannot scan in Vista like it could in XP. Specifically...

We are running Crystal XI. The one XP workstation that runs these reports that are shared on a Windows Server 2008 is suffering from very slow performance when trying to run these reports. It does not matter if these reports are subsequently placed local on the workstation or kept shared on...

Hello: I installed Crystal XI on a Windows Server 2008 machine. WHen I try to launch it, I get the message saying "Crystal Reports has stopped working". Any ideas on how to fix? Thanks! The Big 1980s

Hello: In Crystal XI, my details section is hidden and allows for drill-down. Upon drilling-down on a handful of records, we are seeing duplicate data. I have the Database menu selection "Select Distinct Records" checked. But, "stray" duplicate records are still appearing. Usually, when I...

In Crystal XI, I want to suppress sections of the main report when either of the two subreports that I have on my main report are blank. Specifically, each of these two subreports does not always show data. That's because I have configured the one and only field in each subreport to suppress...

Hello: I have a report that pulls in a figure onto the main report from a subreport within the main report. I would like to add this figure to a figure that I have in the main report. Is this possible to do in Crystal XI? If so, how? The Formula Editor does not seem to have access to fields...

Hello: I use Crystal to extract data from Dynamics GP--an accounting application, in layman's terms. Apparently, there is only one table in GP's Manufacturing series that shows a manufacturing order’s status: “2” = open and “8” = closed for the status field. (“MO” in my e-mail here means...

I'm using Crystal XI that shows inventory items in one column, along with this month's sales dollar figures in another column. I need another column that shows last year's sales figures from this month (i.e. sales at this same time last year). I have been unable to make use of shared variables...

Hello: In the Set Data Source Location window of Crystal 9.0, you map the GP tables of one ODBC connection to another. In order to see the GP tables of the ODBC connection that you want to map to, you right-click on the connection, click the "Options" button, and then you make sure that only...

In group footer #1 of a Crystal 9.0 report, I have the following formula: if {#SumNetCost} < 5000 then {#SumNetCost} * .075 else (5000 * .075) + ({#SumNetCost} * .06) It calculates correctly in the group footer, but not in the report footer. When I research this issue on the net, I am finding...

Hello: How do you get past the "The database object crdb_odbc.dll cannot be loaded" when refreshing a Crystal 9.0 report? TheBig1980s