Forum Replies Created

Viewing 15 posts - 76 through 90 (of 114 total)

  • RE: SSRS environments

    SSRS can be installed locally but if they have access to the report server, they can deploy the reports themselves and you are out of the picture.

    If only you have...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    August 24, 2012 at 12:14 am

    #1529564

  • RE: How to Handle a column with Length more than 8000 characters

    I think you should try to deploy your report on the report server and then run it on the server itself. if it fails there then there is a problem....

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    August 23, 2012 at 6:36 am

    #1529212

  • RE: dynamic reports at the time of prview reports in ssrs

    Does you table or matrix show data (of course when not hidden) ?

    And i think instead of the logic you applied, you can try this :

    in table

    =iif(Parameters!abc.Value= 1 or Parameters!abc.Value=3,...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    August 23, 2012 at 5:44 am

    #1529189

  • RE: Report Server (MSSQLSERVER) cannot load the SQLPDW extension

    Check this Link:

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/34b2f6c4-a6a2-43bd-a349-ebab5b8d92f0

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    August 23, 2012 at 5:17 am

    #1529177

  • RE: Get the oldest date in SSRS

    The min and max should be working.

    Please show us your query.

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    August 23, 2012 at 5:07 am

    #1529174

  • RE: How to Handle a column with Length more than 8000 characters

    Have you tried to divide this column into multiple columns ?

    For Example: 10 columns each of length 800 maybe ?

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    August 20, 2012 at 12:06 am

    #1527443

  • RE: MDX Question

    vineet_dubey1975 (5/31/2011)

    1) SELECT Measures.MEMBERS ON COLUMNS,

    HEAD(ORDER({[Store].[Store City].MEMBERS},

    Measures.[Sales Count], BDESC), 12) ON ROWS

    FROM [Sales]

    2) TAIL

    3) SELECT Measures.MEMBERS ON COLUMNS,

    TOPCOUNT({[Store].[Store City].MEMBERS}, 12,

    Measures.[Sales Count]) ON ROWS

    FROM [Sales]

    4) TOPCOUNT

    Are some of The functions...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    May 31, 2011 at 5:59 am

    #1331909

  • RE: Repeat rows on every page

    Ninja's_RGR'us (5/13/2011)

    Any way to copy or move the first subreport to the 2nd report?

    That's how it was before. the 1st report was in the 2nd report itself i.e., there was...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    May 13, 2011 at 9:50 am

    #1324423

  • RE: Repeat rows on every page

    Daniel Bowlin (5/13/2011)

    I have never tried this, and something in the back of my mind is telling me this won't work...but...Try to move the section you want to repeat on...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    May 13, 2011 at 9:38 am

    #1324408

  • RE: Passed 70-448!

    hi,

    Congratulations to everybody who passed in this exam.

    i also passed this exam with 905 marks.

    Can anybody have any info on the next exam 70-452 ?? it will be much appreciated.

    Thanks...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    November 21, 2010 at 9:51 pm

    #1253575

  • RE: is it really possible to convert 2008 RDL to 2005 version ??

    i created this software and i have already gave him the software

    Amar Sale

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    November 11, 2010 at 12:05 am

    #1249269

  • RE: Its possible convert SSRS report developed from VS2008 to VS2005

    its possible to convert 2008 RDL to 2005 version with a tool....Check this out...

    http://stackoverflow.com/questions/1097690/converting-sql2008-rdl-file-to-sql2005

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    November 6, 2010 at 12:51 am

    #1247393

  • RE: is it possible in SSRS ?

    thanks 4 the reply daniel.

    but i wanted to ask if i have to render 10 different reports (no subreport) in excel format there would be 10 excel files. but i...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    October 7, 2010 at 11:00 am

    #1233777

  • RE: Lookups with huge datasets

    cmbrooks08 (9/30/2010)

    Hi everybody-

    I have a package trying to load a fact table in my DW, and the dataset from one of the dimensions is too large for my computer/the lookup....

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    October 6, 2010 at 11:21 am

    #1232851

  • RE: rows to columns in a report

    then a simple mid function as shown below in SSRS can do this

    if and only if the number doesn't contain 1 as well as 2 digit no.

    =mid(Fields!SrNo.Value,rownumber(nothing),1)

    i.e., 1234567891011121314 can...

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

    October 3, 2010 at 6:24 am

    #1230767

Viewing 15 posts - 76 through 90 (of 114 total)