Search results for query: *

Let us know how it comes out. Good luck... Cheers, Bessebo (website: www.datagonewild.com)

Hopefully that helped. We all were newbies at one time. Don't hesitate to ask. There are a lot of real experienced people on tek-tips that have helped me immensely in the past.. Cheers, Bessebo (website: www.datagonewild.com)

Hi, Where it says Format in properties you want to put in N0, where it says N followed by the number 0, not O. Just N0 and nothing else. If you wanted to have one decimal place showing just put in N1. You could just use a d for the format for the date without the time. Hope this helps...

When you are using a function in the Expression editor there is Intellisense (I think that is what it is called) that shows the various options after you enter the function. You can also utilize the Help function in Visual Studio and limit the "Filtered by:" to SQL Server Reporting Services...

Hi hpost, I thought about this a bit and one thing you could do is to create 3 different sizes of the chart and overlay them and hide or show a particular chart based on the amount of data that you are trying to look at. I think that is one of the only option you have of "dynamically" changing...

Hi pk400, I always like to do this by clicking on the cell and in Properties under the Format attribute, just set it to N0. Another way to do this would be to use the Expression editor and the FormatNumber function and enter something like this where 0 is the amount of decimal places you...

Hi hpost, To be honest, the generic Chart object with SSRS 2005, the version I am using, has very limited capabilities. We use the Dundas chart object which allows you to utilize Visual Basic.NET or Visual C# to affect data displayed on a chart. There are a lot of inherent attributes with...

I assume you are talking specifically about the axes showing too many labels? Is this where it is becomgin unreadable? Cheers, Bessebo (website: www.datagonewild.com)

Hi hpost, Could you let us know if you are using Dundas or the Chart that comes with SSRS? Cheers, Bessebo (website: www.datagonewild.com)

I am not sure what you are asking. If you want all of the tables you should perform a full backup. If you are saying that you want only a few of the tables you could do this. You could create a new database in Access, export the tables from SQLServer that you want into Access. You could then...

Hi pk400i, 1) You have to ensure that the parameter is identified as a DateTime Data type under Report Parameters. One bug that I have found is that when you have a runtime error in the development environment (in my case Visual Studio) the date time report parameter sometimes switches to...

Sarah, If you are only running for one theatre, if this theatre does not have a particular column then it will not show. But, if you are running the report for all theatres and somewhere in the dataset there is at least one occurrence of each column, then all columns should show up. What I...

Hi meumax, I had a similar error with a report and resolved it in this manner. I attached the URL. Just click on it. I am not sure if it will resolve your error but my error was similar. Let me know if this helps at all. Cheers, Bessebo (website...

Hi pk400i, You say: 1. I have 2 paramters, a start and end date, that are used in Crystal to calculate months periods, going three months back. (these are called Formulas in CR. An example: {@Start Date 1} - 1 which gives a month prior. We typically pre-populate our start and end dates with...

Hi Geoff, You ended up giving me the proper solution although, in addition to what you mentioned, I also needed to add a line of code into the Dundas chart. ser.EmptyPointStyle.Color = Color.Transparent It essentially hides the NULL points. Without this line it still tries to draw a line...

This is a trip graph which simply shows temperature on the Y axis and date/time on the X axis. I am excluding a portion of the trip in the SQL statement so there is actually a break in the data. So for that portion of time there is no data (no time data or temperature data). So the data looks...

Hi xlbo, Thanks for the post but could you elaborate on what you are saying here? Where am I checking whether I am returning a NULL value rather than a 0 value? Thanks, Bessebo

Hi, I am using Dundas charts with SSRS and I have a line graph. I have an issue where I want the graph to show a break in the data if there is no data. What it is doing now is actually connecting the dots by drawing a line from one point to another regardless of where there are actually data...

OK thanks Geoff. I use Reporting Services every day to create reports for customers. I was forced, in this case, to perform all calculations in the SQL, particularly the stdev. I have even looked out there for bugs in 2005 but cannot find anything. This is a really strange phenomenon. I want to...

Have you seen this phenomenon in your reports? It still makes no sense to me...