Search results for query: *

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

Hi, I am trying to resolve an issue I am having with performing a STDEV in sql code vs putting the STDEV(...) function in a text box in a group footer in SSRS. For very large data sets (let's called large over 100,000 data points) I can at times get back high standard deviations when I use the...

Hi, I just finished up a course at a university using a book entitled "Programming in Visual Basic.NET" by Bradley and Millspaugh. It is an introductory course in Visual Basic.NET 2005 edition. There is not an advanced course offered at this university so I am wondering if someone out there...

I like to put in the header of each report the value of the parameter(s) that are chosen or ALL. Using a multi-value parameter I am not sure how to put an All products in the header if the Select All value is chosen for a parameter called Product. If you choose the Select All value I obviously...

Hi, I am fairly sure that with Crystal Enterprise 9 there was some tool that would show you in a crosstab-type format each folder (I think along the Y axis) and each group (along the top) and there would be an X (or something like an X) at the intersection if that group had access to the...

Hi, We would like to create a report which contains a map and on that map we would like to have a symbol at every location where we have a store. This seems like a fairly straighforward chart to me. My question is does Crystal Reports XI have a chart which includes a map and I assume that the...

Hi, I am transitioning from a job where I do a lot of Crystal Report development to a job that only uses Microsoft's Reporting Services. I have been looking up courses on Reporting Services and am looking specifically for a course on building reports, rather than on the architecture, etc. It...

We are undergoing an audit and I am looking for a 3rd party software package that will track any changes made to our ERP database by the "sa" account (or any chosen logon for that matter). We are running SQL2000 and we do not want to turn on c2 level auditing because that will track all changes...

We have a need to implement c2 auditing with SQLServer 2000. This is part of an audit that we are undergoing and our parent company has deemed that we need to do this. I am concerned that the disk space that it will consume will be large. It also, by default, writes to our data drive. Is there...

I was just wondering what typical users do to promote a report from their test environment to their production environment? What I do is test the report, then save it off to my memory stick and then open it in Crystal Reports and then save to Enterprise. I was wondering if anyone out there uses...

Hi, We upgraded to BOXI Release 2 about a year ago (from CE9) and there is one thing that is bothering me a bit. Every morning I go into Instance Manager and look for any failed instances and I always get some from users who don't click the OK button after entering a parameter. So, in effect...

(We are running SQLServer 2000, service pack 3) We recently had some Sarbanes-Oxley auditors in to check out our systems. It was suggested that we never routinely use the sa account when not needed. So what I did was set up a login called "Admin" and gave that user the System Administrator...

Is there an easy way that I can get a file of all of our existing users and which groups they belong to? I need this list for a Sarbanes-Oxley audit and I don't have an easy way to get this information. Any help would be appreciated. Regards, Bessebo

Hi, We are currently using BOXI Release 2 and oftentimes we have users say to us "Please just make sure this user receives the same reports as I do". I have no easy way of knowing which reports this particular user receives other than having to hunt and peck. I also would just like a...

We are currently undergoing a change due to Sarbanes-Oxley. What I have been asked to do is to not automatically log onto Enterprise Manager as 'sa'. So I have created a user called 'dbreader' that has database addess of db_datareader. The thing is that if I set up the user this way I cannot see...

I may be transitioning from a Crystal Report development environment to the Microsoft Reporting Services environment. I am wondering if the above class listed in the subject is a worthwhile course to take? Any help would be appreciated. Regards, Bessebo

I have noticed something rather peculiar yesterday and today. We perform transaction log backups every 15 minutes. We also perform full backups every night. In the morning I also perform a transaction log backup with init to clean out the old transaction log backup file and start with the new...

This has happened on more than one occasion and I cannot figure out why it is happening. We create our invoices using Crystal Reports XI. We run invoices every day from Business Objects XI InfoView. When we run the invoices we then print them to a printer with letterhead inserted that we...

I am testing trying to restore a transaction log backup in our test environment. When I attempt to perform the restore of the transaction log backup I get the following message: "The backup set in file "filename" was created by BACKUP LOG and cannot be used for this restore operation." I think...

Just from perusing the IT job ads out there it appears that there are a multitude of jobs out there specifically related to reporting (this obviously includes data warehousing, etc). I am wondering, due to the increased specialization in IT, if there is a specific department within your company...