Search results for query: *

My report is coming from multiple data sources, each being displayed in a separate subreport and in different detail sections. Is there a way I can report dynamically on what source is being used? Obviously I can hard code the names, but that will be a hassle once I send a report to somebody...

I need to put together a report that has one main detail section, then 7 subreports X 3 data sources that all refer to the main detail section. 1. Putting subreports in the same detail section has text from the the second subreport overwriting the text of the first, etc., since I couldn't see...

I am trying to run a crystal report (CR 11 pro) through another application that offers a command line prompt. No problem with that. I need to be able to pass parameters via the command line. Is this possible?

Using CR 9 Pro connected via ODBC to Oracle. For some reason some fields are getting rounded to the nearest dollar. This is not happening in other applications using the ODBC connection. Formatting the field shows it is formatted to use a setting with 2 decimal places. thanks

I'm trying to link a field in the subreport called "udf1" to a field in the container report called "item number". I can't seem to get it to do this. On the subreport links I marked the item_number as the field to link to (since this is what I want in the container report), but it wouldn't...

Is there a way to save a report (8.5, 9 or 11) to an executable file, so I can deliver a report to somebody that does not have Crystal reports? Would there be a way to modify the target database in such a way?

I am trying to output a query that has some numbers to a CSV file. All the text fields get enclosed with double quotes and when I hit finish on the export wizard, I get an "invalid argument" error message, which is consistent with what I found on Microsoft...

I have a dynamic parameter that should be showing all "companies" from a database, so that the user can select a specific company to report on. 1. Not all the companies are showing up on this list. Is it limited to a given number? Can I change it? 2. Is there a way to filter companies on this...

Is there a way (CR 9, 10 or 11) to get a list of possible values for the user to select that are a database field's values, and have that be dynamic (refresh on every run). Meaning, I want to be able to have a drop down list of possible values that gets updated if extra values are added to the...

I have a spreadsheet that at some point began displaying =SUM(E140) instead of calculating the actual formula. This is happening for a large number of cells in the spreadsheet (not one in particular). I have also seen this on other spreadsheets and cannot figure out how to get my sums back...

I need to report on a count of records on an Oracle DB using CR9 and/or CR11. This is to be a subreport as part of a report that is reporting on other things as well. First I tried using Crystal SQL Designer and attach that qry file as a subreport, but it didn't like that. Then I tried...

I am grouping the details by a field called tax_code. All the tax codes are 2 letters (alphanumeric) and uppercase, except for one. There are two groups for New York: NY and ny. I am grouping (and sorting) by this code. I have a parameter for the tax code, where the user can enter a (string)...

I have two subreports, each pulling a max date from a data set. They are on the detail level of the main report and I have a formula on the detail which I need to show the max date of the two max dates. I am able to get the information from the subreports via shared datetimevar, but the...

Hi, using CR 9 and also 8.5. Need to refresh data in report every so many minutes. Don't have enterprise. Is this possible? I suspect not... if anyone can suggest some utilities on the web that can do this, I would be grateful. Thanks

I need to link separately to the same table. For example: sales detail has link to part number table via primary PN link. It also has a link to the part number table via alternate PN link. When linking sales detail to part number table, I get the right PN. When I add another alias (part...

I ran windows update and installed the upgrades (not SP2) and now the icon is in the tray. Can't click or right click on it and the tooltip says "Downloading updates: 0%". Restarting computer does not make it disappear. How do I get it off my tray?

I need to create an excel spreadsheet with an embedded query, built using MS Query. When building the query, it asks which database to point at. If I need to send the excel spreadsheet to somebody when I'm done to use the spreadsheet and query on their own database (thus changing the database...

I have a report that has two tables linking to a third. Example: header record links to the status table and detail record links to the status table. Each can have a separate status. I need to show the current detail status and the current header status. My report is grouped by the header...

Is there a way I can synch up my home outlook xp calendar with my work office 2000 calendar, hopefully automatically? So any addition on one will show on the other?

When creating an email message (reply/forward/new) with outlook XP and using Word as the editor, can I insert a pre-existing signature on to a single message (not create a signature to include on all message)? There used to be a button for inserting one of the signatures, but I can't seem to...