Forum Replies Created

Viewing 15 posts - 181 through 195 (of 284 total)

  • RE: Problem in Report Parameter for Passing Values

    Hi friend,

    Here what you have to do is your WHERE condition is to be written as

    WHERE Series_Name IN (select * from SplitList(@Series))

    Here SplitList is a function which will return you...

    Thanks & Regards,
    MC

  • RE: Report Server Setup

    Hi Friend,

    Can you have a look into the below post. The error might be slightly different but what I would suggest is there in this post which I have suggested...

    Thanks & Regards,
    MC

  • RE: SSRS - Can I see the SQL statement from the Preview tab?

    Hi,

    Will you be able to use Profiler? , If so please.

    Thanks & Regards,
    MC

  • RE: link to Display columns

    Hi ,

    That means you want to control the visibility of the two columns of the report right?

    But clicking on a link and controlling the visibility I don't think it is...

    Thanks & Regards,
    MC

  • RE: Date format

    Hi,

    Try this, there can be other method also.

    =Day(Fields!dt.Value)& "-" & Month(Fields!dt.Value)&"-"&Year(Fields!dt.Value)

    Thanks & Regards,
    MC

  • RE: SSIS Package is not getting refreshed

    Friends...

    Its done, along with refreshing the OLEDB source , now I refreshed the Connection Manager, the it was reflecting.

    Thanks & Regards,
    MC

  • RE: SSIS Package is not getting refreshed

    Hi Friend,

    There was no luck with the above solution. (SELECT a = 1)

    Thanks & Regards,
    MC

  • RE: SSRS error

    Hi,

    When you delete these virtual directories, the already deployed reports will no be there, you might have to configure it again and then redeploy the reports.

    Unfortunately I don't have any...

    Thanks & Regards,
    MC

  • RE: SSRS error

    Hi,

    This the first time Im seeing such an error.

    I would suggest you to try this:

    In inetmgr, select the Reports folder, brows the Homepage.aspx which is appearing at the right side....

    Thanks & Regards,
    MC

  • RE: can't get images to show on my report when i deploy to prod

    Hi,

    Can you just try to see whether you are able to see the Image by browsing the link directly from the Production server.

    Login to the production server, from there...

    Thanks & Regards,
    MC

  • RE: Can we export Sub reports to excel?

    Hi,

    I think it is possible , provided you are using the Subreport object from the Tool set rather than using the Jump to Report option in the report main report.

    Thanks & Regards,
    MC

  • RE: Using SSIS : Data from excel to sql server

    Hi,

    Can you try placing a Data Conversion task after the Source and convert the required fields.

    Thanks & Regards,
    MC

  • RE: CASE function within WHERE

    Hi,

    Try this:

    SELECT *

    FROM #EMPLOYEES

    WHERE

    empid in (

    select

    CASE

    WHEN (@empid IS NOT NULL AND LEN(LTRIM(RTRIM(@empid)))>0)

    THEN iEmpid end

    from @tblEmpid )

    --ELSE

    --empid = empid

    Also Im sorry to tell you that I...

    Thanks & Regards,
    MC

  • RE: ssrs

    You have posted the same question in other section also.. I have replied there.

    Thanks & Regards,
    MC

  • RE: how to create dayanamic reprts in ssrs

    Hi,

    Your question is not complete.... You want to make oyur report name dynamically, based on what?

    In the header you can give the expression as = "My reort name : "...

    Thanks & Regards,
    MC

Viewing 15 posts - 181 through 195 (of 284 total)