ali yeganeh.m
ali yeganeh.m

Reputation: 51

how to make a report in stimul soft with dynamic columns

I have a few warehouses with some columns like name, location and other stuff and I have products that the user can add to the database. Each warehouse has some quantity of each product.

I want to add columns from products and to count the quantity of each product in each warehouse, like this:

WareHouse Column B Product A Product B Product C
WH1 A 50 30 60
WH2 B 70 12 25
WH3 C 35 0 12
WH4 D 0 0 10

How can I obtain this result, especially when a user adds new columns ?

I got some results with cross data but I don't know what format of data need to be and what filters I need to set. I found this but I don't know the steps to get the result I want.

Upvotes: 5

Views: 500

Answers (0)

Related Questions