Search results for query: *

I'm trying to Sum a conditional count in Analysis Services. This is how I'd do it in SQL; Sum(case when dbo.Dim_TaskResult.SpeciesName is not null and dbo.Dim_TaskResult.SpeciesName <>'Unknown' then 1 else 0 end) as Measure. I've created a Named Calculation in the dsv; case when...

I have a task table that I need to derive for each task which of the previous tasks was the parent. The parents are found by ranking the tasks by various criteria then joining the task table to the previous task and comparing them. Depending on a series of business rules (compared with the...

I have a refreshable spreadsheet which populates a data tab from MS Query. I've based a Pivot table on this refreshable data, because I don't know how many rows I will get I've selected the entire columns as my Pivot table dataset. The Pivot table lumps all the empty rows into a row headed...

I have reports based on an operational data store / data warehouse type database. I'm trying to find some solutions to help with our performance issues, many reports are highly parameterised and also need to return detailed data so scheduling, caching, and aggregate tables don't really suit...

I have a drill down report that has column headings for group 1 data in the report header. When the user drills down to the details I would like to change the column headings so that they correspond to the details group. I've tried to create to column heading rows and toggle their visibility...

We are in the process of migrating our SSRS 2005 reports onto a new SSRS 2008 server. We are seeing execution times of the same reports on each server considerably slower on the new server. A sample large report I've used for benchmarking by scheduling it to run hourly over a day typically...

I'm not an MS Access developer but I need to troubleshoot some connection issues with a database. This is an MS Access database with data in linked tables that are in an SQL Server back end. Currently users can read data into the forms but can't edit data in the form, if they overtype a value...

I came across some code recently constructed with lookup subqueries nested inside the select statement. I haven't seen this approach before and it strikes me as an odd way of doing it, is it common? is it efficient? Why would you choose this approach over joining the tables in the FROM...

Our BOXI environment has Dev, Test, and UAT on the same server. We have developed Crystal reports on the Universe pointing to the Dev database server. When we go to Test and UAT we will want the developers testers and UATers to be using each a different Universe each pointing to a different...

We have a Universe where parameters have been defined, for example; eqa_qa.dbo.PROVIDER_STATUS.provider_status_desc in (@Prompt('Select the provider status(s) required','a','Lov Status\Provider Status Desc [LOV]','multi',)) When I add it to the query the following is added to the where...

I have a Crystal report with Parameters that come from a Universe. The parameters are set to constrained and when I set them up in Crystal I change Allow Custom values=False. It seems like whenever I change one of thes parameters in Crystal they all change back to Allow Custom values=True...

I have an On demand report that has two Detail sections, one section is formatted for printing and on screen display, the other for an Excel export. The user chooses which option they want with a parameter at runtime. Is there a way for me to set it up so that if the users selects "Export to...

The performance of Report Manager on the site I'm working on is slow, sometimes very slow, I'm not sure where to start looking to try and solve the problem. Note it's not the reports themselves that are slow, most of the queries run quite fast, the reports a little slower than the queries when...

I need to connect to a SQLServerCE sdf file to write some reports using the data inside, is this possible? If so how? thanks Bruce

I have a requirement to do a chart that has two series which are at different levels of aggregation. They want the Y axis on the left hand side to show measures for one series and a different measure on the right hand side for the other series. As far as I can tell Reporting Services 2005...

I'm inserting the following into a column that is data type float (Datediff(dd,Date_Of_Start,isnull(DATE_OF_LEAVING,getdate()))/365) AS Length_of_Service What I'm after is w decimal to several levels of precision that measures the years between start and finish but instead I'm getting an...

I have a problem installing SQL Server 2005 Service Pack 2 on our test server, every componant except Reporting Services installs ok. The error message I get is below, the log file it refers to is huge so i'm not sure what to look for; Product: Microsoft SQL Server 2005 Reporting Services -...

I have a dynamic sql statement that when executed returns a list of columns, I want to insert the results of this into a second dynamic sql statement as a list of columns that the second statement will return. The first statement returns something like; column1, column2, column3, The second...

I asked this a while ago but didn't get the answer. A year later at a different employee the issue is still a problem. When exporting or rendering a report to Excel I get extra borders that are not there in the report definition. I've tested this by removing all borders from every part of the...

I have a report that passes start date and end date parameters to another report through the navigation settings. It works fine in BI Studio. However when I deploy on Report Manager I get the following error; The value provided for the report parameter 'StartDate' is not valid for its type...