Viewing 15 posts - 31 through 45 (of 114 total)
I don't know if it works or not. But you can try to create a calculated field with the 'iif' expression.
And include sum(new calculated field) into the textbox...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 16, 2012 at 2:27 am
For 2nd table, what is the expression for showing year where error occurred ?
I mean there are 3 years from 2009 to 2011. So which of them are you trying...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 15, 2012 at 8:00 am
Which parameter did you remove ?
The best thing to do here is, Run SQL Server Profiler to get the exact query with parameters being passed to the database engine.
And run...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 15, 2012 at 7:51 am
Yeah. That's the only way to overcome this performance issue.
Thanks
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 15, 2012 at 7:46 am
Hi,
I think 93.33% maybe the right answer because the average is being calculated in the scope of the whole year or whatever months (Jan-June) included.
While your expectation of the answer...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 14, 2012 at 7:55 am
You can check this
And also this
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 12, 2012 at 5:26 am
i have done that on OLAP database. Don't know if that is possible in relational db.
Maybe some kind of sorting trick will get the data in a sequence as you...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 12, 2012 at 5:14 am
davdam8 (10/12/2012)
Basically what i want is to dynamically populate a parameter based on the selection of a previous parameter.Solutions?
create dataset for 1st parameter (i.e., chapter) containing distinct chapters.
For Example: select...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 12, 2012 at 3:03 am
Under which section is the 'top' property located for a textbox in SSRS ?
I am not getting it.
Is it under Location section which is not editable ?
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 12, 2012 at 12:33 am
By concept, Multi select parameters can't be auto submitted.
So you need to select what ever chapters you need, and those values must be passed to the capacity parameter so that...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 11, 2012 at 12:47 pm
Multi select Cascading parameters...
Never tried on SSRS... worked easily in Cognos...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 11, 2012 at 12:34 pm
Does replacing the IN with inner join with temp table handles multi valued values also?
Can you please explain with an example?
You can join your selected values together...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 11, 2012 at 6:09 am
davdam8 (10/8/2012)
=Lookup(Fields!ProjectGUID.Value, Fields!PROJ_UID.Value, Fields!STAGE_NAME.Value, "DataSet2")
I'm not getting the right data.
BIDS gives me a warning that says:
The Value expression for the textrun ‘Textbox21.Paragraphs[0].TextRuns[0]’ uses a lookup function with an expression that...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 6:04 am
Maybe try using LookUpSet function for one-many relationship...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 5:08 am
Thank you for this Information.:-D
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 9, 2012 at 5:04 am
Viewing 15 posts - 31 through 45 (of 114 total)