Recent content by Dominican1979

Hi LB, I added the invoice to the the subreport links and now i'm getting the correct info, thanks again for the help.

Hi lbass, I think I spoke too soon. I had a limited data set using a HERE clause on the view that feeds my report in which I was only selecting one invoice. I have now removed that selection criteria and instead added a parameter field on my report. Now my problem is that my sub-report...

Hi lbass, Thanks a lot for your help. I created the same {@Country} formula on the subreport and linked them together and that did the trick. I didn't have to create a {@country} group on the subreport.

Hello everyone, Thanks in advance for reading my post. So here is what I'm trying to do. I have a customs invoice that has two groups: 1 - Grouped by Country (coming from product order lines) 2 - Within the country grouped by manufacturer (also coming from the order lines) There is a twist...

Hello, thanks a lot Mike and LB for your valuable input, they both work great, you guys are awesome :-)

Hi again Mike, I did what you suggested and the report looks great. I just have a question, is there a way to arrange the months in order? using the month name. Right now its sorting them alphabetically. I expanded the formula you gave me to show the month name like this...

Hi Mike, Thanks a lot for your prompt response, I'm still setting up my query that will feed the report and as soon as I try what you suggested I will let you know, thank you so much again.

Hello Everyone, Thanks a lot in advance for reading my post. So I have a new report I started to work on, but I'm having trouble figuring out how to put it together. Basically this is the deal. I need to be able to see how customers are doing in terms of sales given a date range last year...

Hi LB, Just made the changes and works perfect, I don't mind displaying the months as numbers, thanks a lot again.

I think it may be because its sorted as text and not dates

Hi again LB. I was just doing some more testing and realized that when I choose summarize by week, the order of the columns isn't right. For example: If I do a date range of 07/01/11 to 08/31/11 I get them in this order: 2011-Jul Week 5 | 2011-Aug Week 02 | 2011-Aug Week 01 In crosstab...

Hey LB thank you so much this works like a charm :-)

Hello everyone, Thanks in advance for reading my post. So I have a report with a crosstab on the report header and thats all I have in there. This report is to keep track of customer service reps and the count of return authorization numbers they give out. This is how my data is arranged on...

Hi lbass, Thanks a lot for your help that works great

hello lbass, Sorry for the confusion. Here is what I mean. Currently I have the following parameter: OrdNo When the users run the report, they are prompted to enter an order number to look up then the report displays the sales records like below: OrdNo ItemNo Descr Qty...