Search results for query: *

Hello! Thank you so very much! That was it! Now it shows the 3/5/2022 - 5/28/2022 And the Prompt is to enter the EndDate I hope they are good with it too!

Same results replacing it with the Formula StarDate

Ok that's one thing I got confused on with the Start Date I can change that to use the Formula no problem

Yes thank you See attachedhttps://files.engineering.com/getfile.aspx?folder=05958ee0-18dc-4a1c-952b-06226608d56c&file=IM_QtySoldbyWkVend_Custom_-_Copy.RPT

Yes I noticed that part and updated to use the formula {@StarDate} (misspelled it) but still the same result it seems and weeks are showing from March?

@pmax9999 Did I miss something? I added this to the Report Selection {IM_ItemTransactionHistory.TransactionDate} > {@Start Date} and {IM_ItemTransactionHistory.TransactionDate} <= {@Week12} Where {@Start Date} {@Week01} - 7

@pmax9999, I think I'm confused? I have a new {?EndDate} parameter

@MenuItem, Thank you I did try the built-in Crosstab, however I couldn't figure out to get all the rows into one line as shown in the report.

Hello, Thank you so much! Got the formulas and such updated Please see attached updated report. The Column headers do not match the date range https://files.engineering.com/getfile.aspx?folder=3bdc24f9-99c4-4774-a390-3208eee7c505&file=IM_QtySoldbyWkVend_Custom.RPT

Can you have it from the Start Date and 12 weeks from the Start Date instead? or provide both just in case

Hello, Yes that default is fine. Thank you so much!

Hello, Yes that makes a lot more sense! Thank you How do I achieve that? Yes, also agree. How?

The date is based on the week of the transactions that occured. The Week## is the representation of the Formulas Week01 through Week12 The Week number of the week of the TransactionDate Still repeating the data in other weeks. Depending on the date range the user enters the max weeks it'll...

Not sure if I understand the use of Start or End Date since ... If the user wants to see each week's total quantity for a time period, the saved data it's 4/1/2022 - 5/31/2022 The labels is displaying the week number based on the date range So since the label formulas are producing the correct...

Ok thank you https://files.engineering.com/getfile.aspx?folder=d314847b-f6fa-42c1-9bd3-162afbc20c5a&file=IM_QtySoldbyWkVend_Custom.RPThttps://files.engineering.com/getfile.aspx?folder=d314847b-f6fa-42c1-9bd3-162afbc20c5a&file=IM_QtySoldbyWkVend_Custom.RPT

The {?DateRange} prompts the user for a date range. From that data set the formulas are deriving the weeks the 2nd formula is what I'm having issue with as it looks like it's producing the same quantities for each week the data range selected

Hello, Yes, it is a range. Trying to produce the weekly data based on the date range prompt. I made a change since I have formulas for the column labels It's kind of working I think but it's repeating the values for all the weeks??

Oops, the CODE part got messed up. Fixed the CODE insert so that the formula can be seen this time The DateRange prompt is set to Date. Not sure what's wrong and how to fix it.

Hello, Report is to show data for each week based on a date range prompt I have this formula but it errors saying the {?DateRange} prompt I get an error "A date is required here." with the {?DateRange} highlighted If DataPart("ww", ({TransactionDate}) = DatePart("ww",{?DateRange}) then...

I understand relational databases and primary keys however it doesn't work here from what I can tell Thank you for your help! As noted in my last post, the query shared works! :D