Viewing 15 posts - 16 through 30 (of 114 total)
When creating a group you have a option of selecting, whether you need a header and footer for that group.
If the groups are already created then select any textbox in...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
January 25, 2013 at 12:23 am
Here, I need to import Employee table from server S1 to S2. Difference is that Employee table on S2 wont allow Null values in EmpName column. (There are other constraints...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
December 17, 2012 at 2:55 am
It's not possible in SSRS.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 30, 2012 at 11:08 am
I think "0.00" did provide some part of the solution but you need to look for NULL's and handle them which is giving you the error, i guess.
Use the function...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 30, 2012 at 4:15 am
You can set the parameter properties to 'Allow NULL' and also handle it accordingly on the query side. For example:
Where (customer = @customer or @customer is NULL)
OR
Where (customer IN (@Customer)...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 25, 2012 at 12:46 am
You may need to convert the values into numbers before adding them up.
=SUM(CAST(ReportItems!Textbox15.Value AS INT) )
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 24, 2012 at 6:03 am
It is possible. For more information about the tool to convert SSRS 2008 report to 2005 version, please visit (downloads section) : http://www.applybi.com
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 22, 2012 at 7:46 am
It is possible. For more information about the tool to convert SSRS 2008 report to 2005 version, please visit : http://www.applybi.com
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 22, 2012 at 7:38 am
good to hear that. 🙂
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 19, 2012 at 11:35 am
Never heard of this kind of problem.
Maybe problem with the installation of SSRS
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 19, 2012 at 12:02 am
you can a where clause in the sql query like:
where location like '%LK%'
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 18, 2012 at 11:48 pm
PLEASE REFER TO MY PREVIOUS POST...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 17, 2012 at 6:11 am
Set the CanGrow value to true in the properties section of the textbox.
By default, it is true.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 17, 2012 at 2:56 am
You can use the following expression to get the sum of percentages:
=REPORTITEMS!Textbox15.Value
where 'Textbox15' is the textbox in which you are showing the percentage.
you have to get the value of '5'...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 17, 2012 at 12:45 am
ReportItems!Textbox21.Value="4.2.PP" or "4.3.PE" or "4.4.S" and ReportItems!Textbox23.Value="",1
You got to change the above line to :
(ReportItems!Textbox21.Value="4.2.PP" or ReportItems!Textbox21.Value="4.3.PE" or ReportItems!Textbox21.Value="4.4.S") and ReportItems!Textbox23.Value="",1
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 4:06 am
Viewing 15 posts - 16 through 30 (of 114 total)