Query creation

Viewing 6 posts - 1 through 6 (of 6 total)

Good Morning experts,

i need advice on how to create a query that will give me the production of various products on a month to month basis. like below:

Variety
LENGTH
JANUARY
FEBRUARY
MARCH

Vitality.
35 cm

 40 cm
8,790
9,800
9,710

 50cm
15,570
25,830
18,680

60cm
4,240
7,500
4,690

70 cm
930
2,926
3,291

80cm

140
150

90cm

Total harvest
31,406
47,260
37,796

Export
29,530
46,056
36,371

Reject quantity.
1,876
1,204
1,425

Prod/M²
#REF!
#REF!
#REF!

Reject %
6%
3%
4%

LENGTH
JANUARY
FEBRUARY
MARCH

35 cm
0%
0%
0%

 40 cm
28%
21%
26%

 50cm
50%
55%
49%

60cm
14%
16%
12%

70 cm
3%
6%
9%

80cm
0%
0%
0%

90cm
0%
0%
0%

any ideas please….

thanking you,

Shaz

 

 

Interaction Design Expert
SAP SE

Hello Shazmin,

Could you let us know where you want to define this query, for example what SAP product or tool you are using? That would be a big help.

Thanks and regards, Clare

Hello Clare,

we are using SAP B1 9.1 and we are populating the report using crystal. i hope that helps.

Shazmin

 

Interaction Design Expert
SAP SE

Hello Shazmin,

I think the SAP Community may be a better place for you since it is all about development and implementation. The SAP User Experience Community, where we are here, focuses on interaction design, visual design and related topics. I did a quick search on the SAP Community for “business one crystal reports query definition” and got 112 hits. A search for “crystal reports query definition” yielded 125. Please take a look and, if you have time, let me know how it’s going. Good luck!

Regards, Clare

Dear Clare,

Thank you for your assistance, will update you on the same.

Shaz

 

 

Interaction Design Expert
SAP SE

Sounds good. I hope you find the information you need.

Viewing 6 posts - 1 through 6 (of 6 total)
 

You must be logged in to reply to this topic.