Search results for query: *

Oh, sorry. We are on SQL Server 2005. The ODBC connection is set up the same.

I have a Crystal Report that is returning an Error in File Warehouse Item Invoice: The table could not be found when ran in CMC or InfoView. However, it runs correctly in Crystal Reports XI. I verified the stored procedure was running correctly. I checked the ODBC connection and the Datasource...

In Crystal Reports XI in the Repository Explore when I right click and select Manage Objects and Preview I receive an "Unable to retrieve objects: Automation server can't create object" error message. It was working correctly yesterday. To my knowledge nothing has changed over night. I am not...

The stored procedure takes to long to run without the parameter.

I added a command prompt to select the appropriate table and then changed my parameter (in CR) to select a dynamic list from the command. When I run the report I am prompted 2X's. The first parameter is still an empty field. The 2nd time it prompts me I get a list. ????

Thanks for the reply. I do not fully understand what I need to do. Are you saying I should copy and paste my stored procedure into the command line and run it as a command?

I have a stored procedure that is selecting a sore number as a parameter. When I run the report in Crystal the parameter appears as an empty field instead of a list. I would like to be able to select the value for the parameter from a list as opposed to trying to memorizing every store number...

Thanks for your help. To solve this I created a query that was selecting the appropriate records (as you stated). I selected the query as my primary table in my form. I set the properties to not allow edits to the data in this form. I then imported my data entry table via a subreport and...

Thank you very much. This worked perfectly!!! Kelly

Hi, I just read the message posted by georgesone and I have a very similar question. I also have a database with linked tables. The difference is I want my database to prompt for the ODBC login and password. It is doing that now but it is prompting only when I try to access one of the linked...

does anyone know how to get the switchboard to open in full screen? Kelly

I am attempting to create a database which I have both imported tables (via ODBC connection) as well as new tables that I have created in Access. The new tables currently have no data in them. I want to enter ID # and view the existing data from the linked tables. If any information is not...

I have a report that is generating one label per constituent in my list. I would like it to generate 6 labels for every constituent in my list. Does anyone know how to do this in Crystal 10.0?

I have a crosstab line chart that I created in Crystal 8.5. I just upgraded last week to Crystal 10 and now the graph is not working correctly. It should display a line for every FY but it's not. In Crystal 10 it only displays one line for one FY. The funny thing is the crosstab didn't...

I am on Crystal 8.5.

I have a cross tab report that looks like this: Corporation Foundation Group Urban $5000.00 $4500.00 $300.00 5 1 2 Rural $4000.00 0 $50.00 5 0 2 I want to find out the percent for each urban...

The section I want supressed is in Group Header #1e. The subreport is in Group Header #2e. The shared variable is in Group Footer #1b.

I have the subreport in my Group Header and @Total (my shared variable formula) in the Group Footer.

I passed a shared variable from a subreport to the main report. The shared varialbe is working correctly but I am not having success in getting my row to supress based on the value of the shared variable. I am using Crystal 8.5.