Recent content by vtisgreat

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

OK, I have been able to access a PST datasource. In theory, I should be able to create a UNION as LB suggests. Unfortunately, the Outlook datasource types do not support SQL Expressions. Any other thoughts? Thanks!

Thanks for your quick response, Linda. The problem is not so much the mechanism (Union would work fine), but the access to the Outlook data source. I can see only active tasks available. Not sure how to "point" to the PST file.

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.

Hi: This could be because of a few things. If you are using Crystal XI, and using to monitors, Crystal can "lose" your field explorer. To fix try using one monitor, or have crystal run on the primary. Have you tried the Field Explorer Icon? Perhaps you have set the field explorer to...

Hi: Yes, you can look for a string in a memo field in Crystal XI... for example you can look for: {table.note} like "*Microsoft*" should evaluate to TRUE. Hope this helps.

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...

Hi Steve: The items that I am passing from Subreport to report typically are not stored in a database, so a stored proc or a view would not help, nor would the logistics work for this solution in the environment that it is to be used. I am not too concerned about the overhead of one call to a...

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...

Any thoughts as to what app might use this extension?

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