Viewing 15 posts - 166 through 180 (of 340 total)
But how many rows are being returned and it sounds like the aggregation is being performed in the table with grouping, so that will add some overhead. Look at...
April 17, 2009 at 11:56 am
The big difference would be that everything is running on the single server and you are going through IIS with the Report Server. I would monitor the resources on...
April 17, 2009 at 5:14 am
If everything is on the same server then most likely not a network related issue. How large is the dataset? Does the report generate quickly in BIDS, but...
April 17, 2009 at 4:40 am
Probably need some more information in regards to this to offer more advice. Are you using all SQL Server 2005 components? What version (build) are all of the...
April 16, 2009 at 3:22 pm
Removing Report Models from Report Manager is no different from other objects like Reports and Data Sources. You can click on the Report Model and then Delete it or...
April 14, 2009 at 5:23 am
Instead of using ISNULL I would recommend using COALESCE instead. This is an ANSI standard. You might need to verify that the values are actually NULL and not...
April 13, 2009 at 10:12 am
Ok, you are entitled to your opinion and I looked at the product and I don't expect everyone to agree with everyone else. This is a potentially quick startup...
April 13, 2009 at 6:07 am
From what I have heard it is a quick startup solution to implement analysis for business that do not have OLAP (like with Business Objects), but it is not a...
April 13, 2009 at 5:37 am
Would need more information as to how your parameter is configured and what it is returning. If it is returning the customer key (unique identifier) then this is not...
April 13, 2009 at 5:30 am
What is the data source accessing and where is it located in regards to the SSRS server? If you are using Windows Integrated security and the information you are...
April 1, 2009 at 11:06 am
You will simply need to make sure you have the 64bit Oracle drivers installed on the server and on your workstation where you are doing your development the 32bit Oracle...
April 1, 2009 at 4:11 am
If you simply want to reload the existing cube run a full process on the database to reload the entire thing or you can do a full process on the...
March 30, 2009 at 3:43 pm
You definitely need to use Format=Tabular in the connection string with the OLE DB source going against an SSAS source. I would highly recommend installing the latest service pack,...
March 30, 2009 at 3:38 pm
Can you provide some more information in regards to the error that you are seeing? At what point in the package are you getting the error? If you...
March 28, 2009 at 6:27 am
Viewing 15 posts - 166 through 180 (of 340 total)