About littlered

littlered

Hi, I am using Crystal Reports 2016 for Sage to pull data for itemcodes which have may have one or more binlocations using the COMMAND feature. The subquery needs to pull a certain number of itemcodes. The outer query then selects additional data (re...

littlered

Hey Jamie,I did start out using LIMIT and it wouldn't run. That's how I wound up with TOP which is happy unless it is in a subquery...Thanks!Lori

littlered

Hi,I think both of you are correct in that the DB we are using is balking at my wishes. We use Providex, so we don't have the Sage version with SQL. I unfortunately do not have any other means to send my query to the DB. I will try the TopN and se...

littlered

Hi Jamie,No other commands or tables are used. Since the subquery runs ok without the outer query, I figure I am violating a rule I don't know about regarding SQL when using COMMAND.Thanks!Lori

littlered

Hi Jamie,Adding the ORDER BY to the subquery works only if I remove the outer query. ie the subquery runs fine on its own with both the ORDER BY and the TOP. Thanks for the thoughts! Lori

User Statistics

User Activity

subquery doesn't work with TOP if multiple rows returned using command feature of Crystal Reports

Re: subquery doesn't work with TOP if multiple rows returned using command feature of Crystal Reports

Re: subquery doesn't work with TOP if multiple rows returned using command feature of Crystal Reports

Re: subquery doesn't work with TOP if multiple rows returned using command feature of Crystal Reports

Re: subquery doesn't work with TOP if multiple rows returned using command feature of Crystal Reports