Recent content by bessebo

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...