Search results for query: *

Thanks! The idea given with the SQL above was enough for me to figure it out! I format about doing the kind of grouping that you have laid out for me.

Hi dhookom, I already have the crosstab created except for the total count of weeks that the items were sold. The intial data looks as follows: Item ID Total Sold TranDate 1 3 1/1/07 2 1 1/2/07 3 2 1/9/07...

Hello All, I am using Access 2007. I have created a crosstab that does unit sells per week for a specified date range (Over 20 weeks). The crosstab looks as such (The last column is what I am trying to create): Week 1 Week 2 Week 3 Week 4 Total Weeks Item A 1 2...

A lot. I was looking at how I could create a manual cross tab to do this type of thing but for 52 weeks, it would be pretty daunting.

Hi, Sorry for being vague: Here is a general schematic: Week 1 | Week 2 | Week 3 | Calculation Item 1 Qty Sold Qty Sold Qty Sold countif(qty>10) Item 2 Item 3 Let me know if that is clear or if you need additional information.

I currently have a cross tab report in XI that gives me 52 weeks of sales data for my items. I want to run a calculation that will look through the cross tab and tell me the number of weeks that there were sales more than a certain amount. Is this possible?

Hello All, I am using CRXI. I have done a left outer join to join two tables and one of the fields in the results will have a null value. I want to create a formula that does (FldA - FldB) but in the cases where FldB is null the formula does not produce an answer. I would like for the...

I also forgot to add I am using Crystal Reports 11.

It is actually one field. Sorry about that. Will we also be able to somehow have a parameter affect a sql command? In the command itself there is a date check, that says what dates spans to use. I want to have the parameter update the command itself as well.

Hello All, I am looking to recreate a income statement in Netsuite, and am creating this via multiple subreports within a report. I want to create two parameter fields that will indicate the start date and end date of the report. How can I specify the parameter at the report level and have it...

Just finished it up thanks. It's funny that you have create this item grouping though just so you can create the formula fields correctly.

What should the item group look like? Should I just group by item id? Thanks for keeping up with my questions.

I'm still unsure what you mean by creating a subreport with an item group. What item group are you referring to in this scenerio. You then tell me to add a crosstab report on the same subreport? How would this work? And then what do I do in the main report to put this all together. Sorry I...

What I'm trying to create is a sales report for the last 9 weeks. So far for the rows I have the item information. For the columns I have the dates grouped by week. I have filtered everything so that it only gives me sales data for the last 9 weeks. For the summarized total I am using the...

Also, I am using cross tabs so I don't know if the grouping option will work out for me.

Would the group function be sum(item_count) > 50 If you group in this way it will filter out those that are less than 50?

Forgot to mention that I'm working on CR XI and using cross tabs.

Hello All, I'm trying to figure out how to filter rows out of a report where the sum of a field is less than 50. Thanks.

The only problem is all the additional total rows that are created. Is there a way to hide that row?

Forget it, I got it. Thanks! How about adding additional item information and not having the cross tab group it together?