Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dspitzle
  • Order by date
  1. dspitzle

    Repeated Parameter Requests

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

    Repeated Parameter Requests

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

    Repeated Parameter Requests

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

    Repeated Parameter Requests

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

    Repeated Parameter Requests

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

    Cascading Parameters: How Do It Know?

    Ah! I believe I have achieved enlightnment :)
  7. dspitzle

    Cascading Parameters: How Do It Know?

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

    Cascading Parameters: How Do It Know?

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

    Mismatched Parameter Help Page

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

    A VERY weird form value parsing bug

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

    A VERY weird form value parsing bug

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

    A VERY weird form value parsing bug

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

    Why is identica query returning different results for different 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...
  14. dspitzle

    Why is identica query returning different results for different users?

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

    Why is identica query returning different results for different users?

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

    Why is identica query returning different results for different users?

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

    A VERY weird form value parsing bug

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

    Why is identica query returning different results for different users?

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

    A VERY weird form value parsing bug

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

    Why is identica query returning different results for different users?

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

Part and Inventory Search

Back
Top