Search results for query: *

I occasionally open up a crystal report and run it and the parameters are asked for a couple times. If I do a show SQL Query, I see no Where statement limiting my report. If I try enough times to run this report, eventually it will run fine with the WHERE limitation pushed down in the SQL. If...

Hi, there are occasions when I want to create a specific re-usable command object that can be joined to another view. I tried this in a very simple case, and when I show the SQL actually generated, it is not joined at all. Can this be done? Thanks, Sean

Hi, I have been writing Crystal reports XI reports against Outlook for a few years. I have developed a very sophisticated workflows using Outlook Tasks. I have developed nice tools that pull metrics from milestones, etc from the tasks. Unfortunately, I have run into a size limit on the tasks...

Hi: I have written a really nice Crystal Report in XI that looks at my Outlook tasks. It works so well, that I am now pushing it out to the enterprise. What I have been requested to do is to report on other's tasks (Shared). In going to the Database Expert Outlook/Exchange Default Profile, I...

Does anyone know a solution for Crystal Reports XI 11.0.0.2812 crashing when you drag any field off of a primary monitor onto a secondary monitor. I use a Dell Lattitude D630 using an Intel Graphics Media for Mobile Driver, and my whole team has the same issue.

I am using Outlook 2003 and am trying to write a report from the data using Crystal Reports XI. The appointment "starttime" associated with a recurring appointment is not always correct. If in Outlook I override one of the recurring appointment's "starttime", the start time for the overridden...

I am having difficulty in SSIS to be able to take two tables in a one to many relationship, and flatten the resulting joined rows into one wow with a comma separated field representing the repeating data. I am creating a flat file for 100s of records. Each record may point to several items in...

I have a solution to a problem that I am considering that requires me to design around using possibly 100s of Shared variables in a subreport that gets included for every report I write. I am concerned before I go too far that this could effect performance/memory considerably. These variables...

I am seeing these .RPX files showing up occasionally. Is this a Crystal Report 8.5 related file? A temp file?

I have a file that I use embedded objects as a summary for details later in the same document. Unfortunately, when I move the file to a different folder the links remain to the original location. I can restore the links manually, but I need to distribute this file to several people, and the...

I am using an Oracle SQL Driver, working remotely. When I try to add a stored procedure (we have 800 of them), Crystal takes hours to bring up dialog box (data explorer) to add a stored procedure. If I do this operation locally at work (high speed access), operation takes very little time... I...

On a daily basis I need to support some crystal reports in 8.0 version and others in 8.5. Is there a way to maintain both versions with one PC? I suppose I could try to load both Crystal 8.0 and 8.5 on my hard drive. I expect that there may be problems with that. Any ideas?

We have the same report used in both SQL-Server and Oracle. Current implementation has 2 reports, one for Oracle, one for SQL-Server. From a maintenance standpoint, this is unacceptable (we have hundreds). We would like to have one report that could work for both. Is there a way to have one...

I am currently working on a report that needs to use a function to parse a memo field. I just found out that this cannot be done in Crystal since functions cannot work with Memo fields. I need all the data, so casting is out of the question. Any ideas? Any plans to update this limitation in...

I have Excel 97 and have a long description (up to 1000 or more characters). I have linked Excel to access, and the field gets picked up as a text field... not a memo. Therefore I get only 512 chars. Any fix for this?

I have a report that uses boxes around test blocks and subreports. When I export to Word, they do not get sent. I really need also to export this same report to PDF. I don't see how to do this, although I have seen others do this.

I have a report that needs to get data from an access table and join up with an Oracle table using a field "Code". I get a warning that the fields are of different types from the visual link expert (but cannot see any diff String 10), but this appears not to cause problems. As When...