Search results for query: *

Thanks LB! This worked perfectly.

We have been using been using VisualCut by Millet Software for quite some time. It works well for us.

Hey all, I have a report used for determining whether or not a task was completed within service level agreements. Basically I am calculating the date diff to make this determination. However, holidays are giving me some heartburn. I need a way to determine whether or not a holiday fell...

Never mind. I think I've got it working now. Thanks for your input lbass! Much apprecaited!!

From what I can see, my only option in the On Change Of drop list is "@Field.Date and @Field.Date". Is this because I am using two groups in the report? One for Year and one for Month?

Yes, there are 12 bars to the far left, a large gap and 5 bars to the far right. This is a bar chart. I inserted it and this is what it gave me by default. The only change I have made was to made the bars 3D. On Change Of fieldsa are Year and Month. Summary field is Count of CallID. Show...

That's my question. All 12 months of 2010 are represented on the left side of the graph. The first 5 months of 2011 are represented in the right side. There is a blank space between the two that is about half the width of the entire graph. Looking at detail records, I don't see a gap in the...

I have a report that shows the total number of help desk calls taken by my team. There are two groups; First a date field for the Year, and the second group a date field for the Month. The Month group displays the count of calls taken by the team. I inserted a graph so I could do a year over...

Thank you for your response. I have never used a UFL. Do you know where I could get some additional information on the creation of a custom function? Thanks again, PG

I have a report that counts occurrences of trouble tickets. It uses two groups. The first being the product family and second the issue Category. I have a sum field showing the total number of issues in each category. I have a group sort on the category summary field to display only the top...

Thanks for the assist John. I would agree completely with regards to formatting the data in the database itself. Unfortunately, this database requires the phone number to be formatted correctly when imported. If not, the number is completely jacked up when it's displayed in the application...

I have a spreadsheet with a list of clients that I need to import to my database. The Phone and Fax numbers in this sheet are 10 straight digits with no formatting. They need to be in standard Phone format before they are loaded to the db. I can change the cell format in excel, but it only...

Bump. I had to abandon this as I wasn't able to get it to work. I ended up importing the entire client list into the parameter field. However, updating this list manually is getting to be too much as the client list has grown substantially. I really need to get this dynamic parameter...

That worked like a charm. Thanks for your assistance lbass!

I am creating a report that needs to show a chart and it's corresponding detail. Is there a way to have the chart show across the full width of the page but place the detail into the multiple column format? When I attempt to do this, the detail that shows in the second column is going to the...

Please disregard the post. I was able to determine the appropriate method. Thanks!

I have an Excel spreadsheet that is being used to graph an average Year To Date value based on 12 individual monthly values. Obviously, as you move through the year there will be later monthly values that are zero because you don't yet have data for them. This causes the AVERAGE formula to be...

The ODBC connection uses Windows Authentication. It does not require an explicit database login and password.

Same ODBC connection for both.

You could also create a formula that states (I'm making up a field name here as I don't know what your data looks like) If AvailMonth > 0 Then AvailMonth else "Default Value". Replace the AvailMonth field in the report with the new formula field. It should evaluate the value and if it is zero...