ABCHello,Somebody please help,Above here is a caption of my report details for SO. These are details of only 1 SO. In A and B, you could see that I have fields with redundant data- the same gross amt, total/item, invoice nbr, and unit price. But the [net sales] in A shows that they’re not the same inventory item, which is also shown in C, they are two totally different item. But why is my report using only the first inventory item details (except net sales)? Anyone who has an idea, please?If this would be needed, please kindly see my report file to view tables and relationships. I appreciate the big help!
Hello,Initially, I found the Status and Customer columns narrow in width, so I just dragged the sides to stretch them. The Status content adjusted, but the customer content would not. I didn’t specify width in the GI creation, and even if I do, still no changes. Where should I make a change? Thanks!
Hi all,I am trying to make generic inquiries for the first time, but I got troubles.Can somebody please take a look at my set up?My result is, after specifying the SO Nbr and SO Type, the results grid still gives all and doesn’t filter based upon my parameter. Can someone point me to where I set it wrong? Thanks a lot!
Hello,can somebody please let me know why I can’t open a report in my report designer. the name is correct. Thanks!
Hello there,Help pls. I can’t see here where this huge space after groupheader1 is coming from. I’ve tried coloring all the group to see which displays this but none of them.
Hello,I need to display the address in Shipments ([SOShipmentAddress.AddressLine1]) because I have many shipments that I’ll give different addresses under one SO (pic4). I keep getting an address that isn’t even related to the customer in the SO, then the item was redundant below (pic3). I provided my schema builder’s relationship here (pic1). (pic2) is still the address in the shipment, I haven’t made override yet so that should still be the result. Please help me get the result I want.Thank you for the help!
Hello,Please help, I’m new to making these reports.I need to display the summary of (1) Sales Agents (I mean despite of ARCANGEL being in the list multiple times, I need only 1 entry of his name now) in the list and their own total sales, and (2) Item Category with their total of sales too. How can I do that? I appreciate your help, thanks in advance!
Hello everyone!Can anyone please help me with this? I have multiple set of column headers. Adding another set of columns in another ‘Groupheader’ results to (1st line) COLUMN1, followed with (2nd line) DETAILS1, then (3rd line) COLUMN2, followed with (4th line) DETAILS2. I want it that COLUMN1 list down all DETAILS1 before COLUMN2 and DETAILS2 follows (just like in the picture, here, I have them in separate reports). Please help me out! Thank you!
Hi all, can somebody please kindly help me?I have to make a generation of monthly sales report. But here’s what happens, the list of those SOs are incomplete, just take a look at the total net sales and it’s too far. So I checked this first SO, and yes it has three inventory items, two of which are not listed here. I have filter for “released” but yes, three of them are all shipped and invoiced. It may be in my groupings? Could someone please kindly check my report file for me. I would appreciate any help, thanks a lot! Regards,Paula
Hi All,I am displaying SO with items related to them. Some are displayed correctly, like in this case, SOHO000403 has 2 items so it was displayed twice. But SOHO000371 also has 2 items inside, but only displays one. What could be the problem? Can someone please kindly take a look at my report schema? I appreciate any help, thank you so much!Sometimes too when I would open the SO, it’d lead me to a different SO. Paula
Hello,I need to add in this conditional statement ‘if ARTran.SalespersonID is null’. What statement do I need? Thanks a lot!
ABHi there,When I export the report to excel, the column field for the column field results to merging into one cell. Example is in the picture. Where do I format it so that my SO number would only fill column C instead of columns C and D?And why is my ColumnHeader not shown when my excel ‘visible’ is already ‘true’?Thanks a lot!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.