Search results for query: *

That's right; yet as the original data does not necessarily comes from an Oracle database, but might as well be SAP, we aren't able to rebuild the crystal report in oracle. In fact, an advantage of the SP-solution in the report would have been that this way we would have been able to transfer...

The reason for this kludgy construction is this: A report (based on SAP or Oracle data) regularly runs and returns data, let's say on a daily basis. Now we'd like to store some of this data (e.g. group summaries and key figures) in our oracle database each time the report runs. The SP is meant...

synapsevampire, I want the subreport to be linked to the main report. Thus I'd have to link a table field of the main report to the subreport's parameter (which originates from the stored procedure). Yet I have to specify it's value when running the main report. If I enter a value, it is...

Hi, I'd like to know if there's a solution for the following problem I'm dealing with since quite some time without success: I have an ordinary report that's retrieving data from a table. I've written an oracle stored procedure / function with two parameters that inserts the values of its...

Hi, using CE8.5 is it possible to change a scheduled report's attributes? To be more precise, we are in need to replace the unmanaged disk's path specification in a bunch of more than hundred reports. As this attribute seems to be 'hidden' within the CE-database's BLOB-field, we're looking for...

I'm just guessing but I suppose using the 'currency symbol' will result in the report using the system's default currency symbol (which might not be identical on your client and your CE server). As there's one subreport that doesn't change its symbol, you could check by comparing this field's...

okay, so this seems to be a new feature in CR9. We're actually using CR8.5 :-( So the only guess I can make would be that it depends on the syntax you're using. WinSQL might implicitely convert your syntax while CR might not. As you're using an ODBC driver, there might also be (other)...

Have you checked if it is really possible to directly manipulate data via an sql command? As far as I know, sql commands are only designed to retrieve data and therefore can only contain select clauses. The only way to write back data to a database I could imagine is to write a function (i.e. a...

If you do not need to work with wildcards and just want to make sure that your text field contains the string *HIC*, you might try something like: if instr({textfield},'*HIC*')>0 then // found ... else // not found ... end if; That way, you would find *HIC* while you wouldn't find...

I don't know if I got you right: You have a formula @ToDate that returns a date (alsways a Saturday) and are looking for a way to calculate the @FromDate (which is supposed to be always the Sunday before @ToDate) ? You could try to use {@ToDate}-6; as calculation in your @FromDate formula -...

After having installed Crystal Enterprise, you should see "ePortfolio", "Crystal Management Console" and "Crystal Offline Viewer" in the Crystal Enterprise Launchpad. From there you'll be able to download and install the crystal offline-viewer (windows version only). At least, this is the case...

I think CR always executes formulas on client-side if they contain variables or that's what we experienced. In fact, we had to make use of this behaviour in order to troubleshoot another bug ;-)

You could also use: totext({table.number},replicatestring('0',8)) or even replace '8' with a global variable in order to be able to easily change the format but altering the variable's value, especially when using various formula fields that contain this expression.

Hi, we have a similar situation due to the fact that we were adviced to set up our CE server in english, so you might check the language-specific settings that have been applied to your operating system (maybe date format is switched to US there). To make sure that date fields within the reports...

Hi, just being curious: is there anybody out there who happens to have already succeeded in scheduling reports on Crystal Enterprise that use SAP tables or infosets as datasource and have them running successfully in SAP in batch mode ? Regards

Hi! Just being curious: we`re using CR8.5/CE8.5. Is there any possibility to create multi-language-report? The only solution we know about would be creating a language-parameter, replacing all textfields by formula fields and displaying text dependant from the parameter's value. But this way...

how exactly does your formula (using CDate) look like ? CDate is supposed to be able to deal with numbers, dates and strings (at least in CR8.5).

Thanks for your replies! (I have to admit, that I should have thought of this myselft, but somehow I missed it...) Showing the sql-string and changing it according to our needs worked :-) (Those '_' and '$' attached to the tablename prevented my former efforts from being successfull.

Hi, does anybody happen to have expierence using sql commands in CR10 in combination with accessing data that is stored in an excel sheet? What I'd like to do is to create an sql command that not only selects certain columns from the excel sheet but also does some initial conversion (i.e...

Do you mean you want to check "allow multiple values" and then choose "discrete and range values" from the radio buttons? If so, this might get a little bit tricky. You could try something like the following: local numbervar i; local stringvar s; for i:=1 to ubound({?P1}) do if...