Oracle Reports Builder

5 pts.
Tags:
Oracle development
Oracle Reports
Oracle Reports 6i
Oracle Reports Builder
SQL Query
Hi, i have one query plz help me on the same.... I am creating the report in oracle report builder 6i,  i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. of same customer name in a month which i want only one name or customer and total for this month of invoice amount. and total invoices in this month just figure suppose 2 or 5, 100 anything related with this customer. Plz send me the proper solution on it as earliest. Thanks Swapnil

Software/Hardware used:
oracle

Answer Wiki

Thanks. We'll let you know when a new response is added.

I understand what you are saying. You are gettign multiple identical records returned from your query. A way to get around this prblem is : Lets say your Query is as follows:

SELECT …… group by …..

What you coudl do is to do it like this:

Select …… from (your original query)
group by……

This will eliminate the duplicate records.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Ss6601, your question is not clear enough. If you are asking for help on modifying your SQL query, please post your current query. Also, it would be easier to understand if you post some example data, and the results you would want to get from such data. You might just need to incude an additional column in your GROUP BY clause, but we really need to see your query, and understand your requirement first.
    69,835 pointsBadges:
    report
  • TerryHammer
    why not just delete the duplicate entries?
    210 pointsBadges:
    report
  • carlosdl
    You cannot just 'delete the duplicate entries'. This is not related to an excel sheet or similar.
    69,835 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following