Search results

Ok, I've figured out my own problem so I'm going to post my findings now that it is done. The issue that I was having wasn't so much knowing what to do, but knowing the proper syntax to get it to fly. In the report's Open event, you just set the OrderBy property to the SQL "Order By" but the...

How would you do a sort on this report? I don't see it in the code. If you could answer this question for me, it would solve a big problem for me in that I am passing an SQL string to the report for the report's record source and the sorted field can change each time it is run.

I suppose that I could do that, but there are 12 different sortable fields, both ascending and descending and the client wants to add a second sort. If, by duplicating and creating an instance for every combination, I'd end up with a lot of reports. I may not add the second sort to the form...

Well, it's a good question but the reason that I can't use it is because the field that is sorted on is decided upon by the user. They have a combo box with the various fields to sort on (default is Item_ID) and they also get to choose from another list, which direction they want the sort to...

Well, thanks. I'd gotten that far. What I don't know is how to code it and I was hoping that someone knew. I've tried using the OrderBy property but I can't seem to get that to work. I've tried to hard code it to one of the field names, but I keep getting errors and I'm unable to find a...

I have a dynamic report that is generated from a search form. It gives the user the ability to set their criteria on many fields and sort the report according to the field they wish to see it sorted on. At the moment, it populates the grid on the form just fine in the correct sorting order...

Go to View-Sorting and Grouping and you should be able to choose which fields to sort and group on if they are contained in the detail line of the report. Just click on the left side, scroll to it, then click on the right side and choose the direction.

Ok, I need some help here. I have a situation where I want to print a secondary report based on the same parameters as the first report. I have a form where I can select fiscal/calendar year and the year itself from drop down lists. From here I have both a print and a preview button...