Viewing 15 posts - 1 through 15 (of 114 total)
Thank you for replying.
@Jeffrey Williams -
So the datetime data in transactional DB system is always stored in UTC. This datetime data is then converted in whatever timezone the user wants...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
May 5, 2021 at 12:12 am
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
August 2, 2018 at 1:29 pm
In SSIS, the data type for this column is DT_NUMERIC is that causing the problem?
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
August 2, 2018 at 6:12 am
Need to check 2 things here: BI Developer
1) If there consists variables(SchoolName) with same name but in different scope
2) If the query to get school name bringing any NULLs.
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
July 30, 2018 at 12:24 pm
does opening the script and compiling and saving it resolve this issue for may be a single package ?
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
July 28, 2018 at 5:30 am
Solved that by MultiLookUp ssrs function. Thanks
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
October 11, 2013 at 5:47 pm
Daniel Bowlin (10/11/2013)
I think you need to filter the values you are passing to the subreport to make sure you are not passing any invalid values.
How can i do 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, 2013 at 5:30 pm
To add to the 1st reply above :
1) You should know the syntax of MDX also how does it work.
2) What are the functions in MDX ?
3) You should also...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
April 30, 2013 at 11:59 pm
Does anyone have suggestions on how to handle the grouping, parameters, datasets, really anything so that I can list multiple properties in this table, but each row only references the...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
February 22, 2013 at 3:25 am
First of all, you have make this "WHERE RMPROPID = @PROPERTIES"
to this "WHERE RMPROPID in (@PROPERTIES)".
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
February 22, 2013 at 3:19 am
what is the datatype of the column 'ID' in the database table ?
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
February 18, 2013 at 3:51 am
Check this out : http://stackoverflow.com/questions/5388398/format-number-in-ssrs-report
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
February 14, 2013 at 3:54 am
it can't be achieved, as i had face a similar situation.
The user has to deselect the 'All' when choosing other values.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
February 14, 2013 at 3:21 am
When you create a group, select 'Add group header' to add a header to the group.
Now a header is added as well as a column.
Delete the column by...
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
January 28, 2013 at 6:39 am
What is the sql query to get the data ?
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 1:52 am
Viewing 15 posts - 1 through 15 (of 114 total)