Hi. I'm using the basic version of Business Objects. I cannot alter any code. I can only create queries by using the graphical interface to drag selected fields into the Results Object window and the Query Filters window. Here's the issue: Let's say I have a table (MyTable) with two fields. The field names are FromNumber and ToNumber. They each contain data such as the following:
FromNumber ToNumber
101 200
201 500
501 549
550 700
Notice that in a given row, the FromNumber and ToNumber fields contain a numerical series (the series for the first row is 101 thru 200, the series for the second row is 201 thru 500, etc). Now let's say for example that I'm interested in retrieving the row (and only that row) that a selected number falls between. Let's say the number I want to query on is 525. The SQL for such a query (if I was using some other application where I could actually write the SQL myself) would be something like the following:
Select * from MyTable Where (525 > FromNumber) And (525 < ToNumber)
The above SQL would properly return only one row, that being the 501 thru 549 row.
The problem I'm having in Business Objects is that no matter how I structure the query using their graphic interface, I'm getting back multiple rows. It seems to be grabbing all data it finds in the FromNumber columns that is less than 525 and all data in the ToNumber column that is greater than 525 resulting in multiple rows. Anyone know how to structure a Business Objects query to get it to return only one row of data. Remember.... I CANNOT alter the code. I can only use the graphic interface. Thanks.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
ast2550,
I assume he's using the BO report writer, which is quite different from CR. The version number would probably help confirm that. Unfortunately, I haven't used BO enough to be able to answer his question, and don't have it installed on this computer. Plus, the answer might be different depending on which version he's using.
James
Business Accounts
Answer for Membership
by: ast2550Posted on 2007-11-09 at 13:05:14ID: 20253051
What?
This should be a piece of cake.
New Report
Add Table (MyTable)
Report | Select Expert
Choose either the FromNumber or ToNumber
Then click 'Show Formula' and then 'Formula Expert'
Enter (pick them from the window above versus typing the field names)
525 > {MyTable.FromNumber} And 525 < {MyTable.ToNumber}
Click OK
Then, when you want to get fancy, create a parameter field for the input of the 525 and then alter your Select Expert formula to be:
{?Parameter} > {MyTable.FromNumber} And {?Parameter} < {MyTable.ToNumber}