Duplicate item in report

[dikidushi]

Hi all,

I am creating a report to show sales qty, the report need to show the item that i selected ( equal to 800000 ) however on the sales there were more items but i only need one. when the report generated it shows the qty and total sales of the other items as well,
how can i set it to show only the item that i am selecting and not all items.

any help ????

thanx,

 

[briangriffin]

Create a parameter titled {?ItemNumber}. Make sure the datatype (number, string) is consistent with the datatype of that field in your database.

Then in the Select Expert, the logic will be:

{YourDatabaseItemNumberField} = {?ItemNumber}

Each time you refresh the report it will prompt you to enter the item number you want.

 

[BettyJ]

If you want to see only the Sales of the item, 800000, then in the Record Selection you can give the condition
[tt]{databasefield item}=800000[/tt]

If you want to select the item at run time, then you need to create a parameter. If the parameter is named Item, then in the Record Selection, the condition will be
[tt]{databasefield item}={?Item}[/tt]

I am not exactly sure, if this is what you are looking for, because the title of your post says duplicate item in report. If you are getting duplicates, sometimes it may be a problem with the report links.

If you can post sample data, it will be easier to understand the exact issue you are having.

 

[dikidushi]

Ok, i have the parameter to select only that item number. however it is picking up the other item thats on the order, lets say if the qty is sales 5, the report will repeat 5 row for that item and the other item as well. i need the report to show only one item and the qty. maybe im not explaining correct,

any help will be gr8

 

[briangriffin]

Did you link the database field to the parameter in the Select Expert?

If so please provide more detail as to the tables and joins in the report, any grouping, and under the Database menu paste in the results of Show SQL Query.