Search results for query: *

What I mean is, when you use a list box to, for example, select products, can you produce a list box which interrogates the data to list, for example all your products, rather then those chosen when you first set up the parameter. The only other solution I can see to this is to update the list...

That looks perfect. Now, to be cheeky, is there a way of doing this with memo fields way over 254 characters. We're version 8.5? James

Thanks But the problem isn't really pulling out all the cars of a particular colour, it is poulling them out as a continuous string. ie: "MBW, MG and Ford" (exactly like that.) Believe me I have a good reason for doing this which is nothing to do with cars or colours, but which...

In Access I can use a produce a recordset in a function using either a preexisting query or by wrinting the SQL and then go through this recordset and concatinate one or more fields from each record into one field. This might be used, for example, to go through all the products you have...

Thanks for that. The problem is we're looking into whether using crystal to interrogate our call handling system would be better then Access, and I personally don't see the point of using it if we're going to go through Access anyway. I've managed to build the Union query in SQL designer, but...

Is it possible to use more then one Seagate query on a report or in a data dictionary through Crystal. The only way I can get it to do anything like that is to build the queries in Access and interrogate them from there, where they are treated like tables. James

I am fairly new to Crystal reports, being more au fait with Access, and am trying to create a report on our customers complete with their addresses. To cut a long story short, our addresses are held in five different tables according to the type of organisation, and as such a Union query is...

Thanks But you can't build a Union Query from two different Data sources in Crystal, which is what I need to do. James

I am fairly new to Crystal. I am trying to set up a report with a crosstab based on data from two different data sources. They cann't be linked. In Access I got around this by putting all the data I needed into one Union Query and performing all the necessary calculations using this data...