Search results for query: *

I thought about that but I would prefer to refrain from using an array? I'll have to do some more thinking. I could create a shared variable in a subreport but this report is already a little slow.

Yes, that will work but unfortunately the user wants it sorted by date placed and not account. I know that i could easily do this in sql but it would require me to rebuild the report and write the query. Just trying to find an easier solution.

I inherited a report which I need to make a revision and would like to do so without having to rewrite it. The report is currently grouped by customer segment and within segment each customer can have multiple orders. Here is an example of what the data may look like...

Thanks for the reply Mike. That is what I was thinking as well but have yet to determine a solution. -Tim

I was able to find this formula when searching through the threads. It seems to work but only if all of the columns have a value. My problem is that some columns have null values. I don't want to just convert them to a 0 but exclude them entirely. Any help would be greatly appreciated...

I had to tweak your formulas slightly in order to make it a datetimevar but it worked like a charm. Thanks for your help LB.

Actually I just realized that this isn't working 100% correctly. My data returns multiple rows for some orders in that it returns a row for each item placed. I need it to return the second date rather than the second row. Customer OrderDate xxx 01/01/11 12:15am xxx 01/01/11 12:15am...

Thanks, worked perfectly...

I'll try my best to explain what i'm trying to do. I have a report that returns several rows of data for each customer. My data is grouped by customer and I have been asked to display the minimum order date and the second order date. For example a customer that placed 4 orders but i only want...

I dont believe the last part is getting cut off but is probably being displayed on the next page. If you click on file -> page setup -> under orientation select the box for landscape. If you are still unable to view all of your data you can try making the text in the cross tab smaller in order...

create a formula: totext({your field}) and use this in your formula.

We're you able to create a running total? Running totals must be inserted into footers to work properly. After inserting it in the footer you could just create a formula which references that running total and you can insert it into the group header. i.e.. create a formula and in the formula...

You could always follow njahnavi's advice then insert a formula in the header which references the running total which you inserted into the footer. You could then suppress the running total in the footer.

I receive the following error when I hit the preview button Error in File DID Inventory: Failed to load database information. Unable to retrieve Object. Error in File DID Inventory: Failed to load database information. by the machine i'm using to distribute the reports do you mean the server?

Pat, thanks for the reply but I cant seem to get this to work. Am I doing this wrong? I'm going into the current connections-> create new connection -> Aceess/excel (DAO) -> insert unc path in the database name \\Fileserver003\Reporting\DID\DID_Inventory.mdb -> database type access and this...

That was the problem. I was using my original formula which I posted but was allowing multiple values. Formula works great when I don't allow multiple values. Thanks,

That works if you only enter one email address but when you enter multiple it does not work. I want the user to be able to paste something similar to the following in the parameter prompt and it to return any individual orders which a customer placed using any of the email addresses from their...

I want the user to be able to enter a list of emails separated by commas.

I'm trying to insert a parameter which allows the user to input a list of email addresses for a certain date range and it will return a list of orders for those customers. I've looked at several other similar posts however have been unable to come up with a solution for the problem that I'm...

Sorry for such a long post but i'm trying to be as thorough as possible. Thanks for any help in advance. I have a very simple report which I need to create and am having trouble doing so. Heres what I need to do... Our Technology department has an excel spreadsheet which it maintains as new...