Search results for query: *

I'll take a look. Perhaps it will work after all, though I don't need a Union as such.

Sorry, the basic problem is that it seems like I can't create a Command that includes both "owner1"."doc" and "owner2"."student". The Commands are themselves associated explicitly with "owner1" or "owner2" in the user interface. If anybody can point me to documentation on the Command feature...

I hesitate in saying they work with different "drivers", as they're both linked via ODBC using the SQL Server driver, but they have separate names on the server, and as such must be linked separately for OCBC purposes.

Thanks for the reply. I'm not using a subreport, but given the somewhat screwy ways (to my eye at least) that Crystal Reports handles SQL, I wouldn't be surprised if it uses the same process. As I said, though, this only happens on the server, not while running it locally in CR XI. The two...

I've got a slightly messy situation I'm trying to debug. I'm using CR XI to generate reports which are displayed by another application which runs on a server. I do the development on my local machine, using a VPN to connect to the server for data access. The data is broken into two separate...

Ah! I believe I have achieved enlightnment :)

2) A seperate table, or SQL command not joined to the other tables used in the report. Very important to NOT use fields from this in your report. ----------------------------- This is the area where I get hesitant: in my prior experience with MS Access, is you have tables in the query...

I'm trying to figure out HOW CR cascades parameter choices. Does it take the join information from the Links tab and use that to determine that "SCHOOL"."district" links to "DISTRICT"."id", or is it pulling foreign key information from the source database, or what? The reason I'm asking is...

I'm using Crystal Reports XI, Professional Edition, and I've got a conundrum. I'm trying to work with Cascading Parameters, but the Help page shows columns in the Parameters interface that I don't see. Specifically, when I click on the Dynamic radio button, I see three columns: Value...

That's where it is failing. The query is able to resolve the form field reference when I run it, but for my users the query fails to resolve it, and returns a 0 for evaluation in the query. Visual Basic, however, is able to return the value in the field, so my guess is that something isn't...

OK, more guesswork... Is the form returning the same number of records for your user as for you? Is your db split into a FE and a BE? If so, where is the FE stored? Same location as the BE? ---------------------- Yes, we see the same number of records on the form, and no, for this particular...

I suspect that's unlikely, as the data file itself is stored on a different server than the one that's been virtualized, so Citrix would have to be storing an out of date copy of one particular network-accessed file, only displaying it to certain users.

Well, I just had one of my users log into a machine with MS Access installed locally, and the query ran correctly. So we've got this problem narrowed down to something user-specific that is only occurring in Citrix. It's also something that occurred between July 9 and July 15. I've still got...

lameid: There is another possibility... That the server somehow supports differenct installs of programs. Maybe one version is patched but antother isn't. I just don't know enough about citrix. Citrix is essentially just a virtual server tool. Since I and my users have been logged into the...

Hmm, good point. Since all of the personal settings should apply to a local machine the same as to a Citrix login, that shouldn't make a difference, so if it does then Citrix seems to be the responsible party. Unfortunately none of the affected users have Office installed locally (since they...

Sadly, I can't look at the patches, as I don't manage the server :( In any case, there's still a problem of why some users would get valid results and others wouldn't when running on utterly identical patches.

I'm not having any luck finding a similar problem in the posts here. More to the point, it can't specifically be Citrix that's at fault, as I can get the correct results over Citrix. It's the fact that different users are getting different results that's the problem; the fact that Citrix is...

I'm not sure what effect that would have, but there has only been one user logged into the database each time I've been testing this, so it doesn't seem to be a conflict over accessing the data or anything similar.

I've got a very weird and confusing bug here. Stripping it down to the core problem I've isolated, I have a database accessible by several users, including myself. There is a form containing several records, and one of the fields on the form is the record ID. I build a query which reports the...

Here's some even further weirdness. I had a brainstorm that I could use the Filter property of the report to achieve the effect I'm looking for. So, I removed the parameter from the query and filtered the report so the record ID = the value from the form. And of course, it works for me, but...