So, here is a situation I am mulling over involving sequential entities. I can think of one or two solutions for it, but I suspect it is a fairly standard design pattern and I don't want to re-invent the wheel!:
For an airline ticketing company, I am modeling these entities:
Trips
Routings...
Aha, my question exactly!
I am trying to query a linked table (linked to a SQL*Server table) and I'd like to filter by a date literal.
The Access syntax (#) doesn't work:
SELECT [fields]
FROM [linked table]
WHERE myDate > #2003-01-01#
(understandable since query is sent directly to...
Thanks for the tip K. It turns out that when I prepared my respective queries in Crystal SQL Designer and saved the data there, then used these independent .qry files as my data sources (as opposed to creating command objects in Crystal Reports), performance went from 6 hours to 6 minutes...
Using Crystal Reports 9, I am attempting to integrate data which originates in both SQL*Server tables and Oracle tables into a single report. I am able to perform a join on the client-side (by creating two SQL commands and linking them), but performance is impossibly slow, even when I reduce...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.