Forum Replies Created

Viewing 15 posts - 211 through 225 (of 541 total)

  • RE: Create Endpoint Error

    Hi Lynn. I shall take a look.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 26, 2009 at 2:16 pm

    #1070920

  • RE: Jump to URL

    The resolution was as follows:

    ="http://server-name/ReportServer/Pages/ReportViewer.aspx?%2fTopLevelFolder%2fSubFolder%2fSubFolder%2fReport+Name&rs:Command=Render&ProductId=" & Fields!ProductId.Value

    Thanks to all those who took time to review this post and I hope the resolution helps others.

    Kind Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 20, 2009 at 9:04 am

    #1068271

  • RE: Jump to URL

    Still searching.....

    I have:

    ="void(window.open('" & Globals!ReportServerUrl & "?%2fTopLevelFolder%2fSubFolder%2fMy+Folder+Report+Name&rc:ToolBar=False&rc:Parameters=False&ProductId=" & Fields!ProductId.Value & "', 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"

    The above does nothing when the ProductId field is clicked in the report so my sysntax is wrong.

    I an...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 20, 2009 at 8:00 am

    #1068211

  • RE: Jump to URL

    I amended code as follows:

    ="http://MyPath/Pages/Folder.aspx?ItemPath=%2fMyFolder%2fReports%2My+Subfolder/Folder Name&rs:Command=Render"

    I also tried

    ="http://MyPath/Pages/Folder.aspx?ItemPath=%2fMyFolder%2fReports%2My+Subfolder/Folder Name&rs:Command=Render&ProductId=@ProductId"

    When I select the link reporting services returned error:

    [Quote]

    The operation you are attempting on item "/MyFolder/Reports/Sub Folder/Folder" is not allowed...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 20, 2009 at 6:31 am

    #1068123

  • RE: ROW NUMBER

    I have found the solution:

    RowNumber("grpSupplierName")

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 7, 2009 at 2:24 pm

    #1063072

  • RE: Date Filter

    Thanks Lynn. This worked:

    [Code]

    SELECT

    i.CreatedDate,

    i.EffectiveDate

    FROM

    Inventory AS i

    WHERE

    i.InventoryReasonCode = 173

    AND i.EffectiveDate...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 7, 2009 at 1:10 pm

    #1063029

  • RE: Date Filter

    0 rows......

    Thanks Lynn.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 7, 2009 at 12:00 pm

    #1062977

  • RE: Return TOP 5 Suppliers based on Invoice Volume

    Told you it was brain freeze!

    You were correct (as was I!!).

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 7, 2009 at 10:00 am

    #1062911

  • RE: Query Performance

    Thanks guys.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 7, 2009 at 9:14 am

    #1062858

  • RE: Query Performance

    Hi Piotr. You were correct when run as a batch option 1 was 46%, option 2 54%, run individually each were 100% (which I suppose makes sense!). Not really looked...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 6, 2009 at 3:31 pm

    #1062513

  • RE: Stored Procedure used for Wild Card Search on Web Form

    Hello again. I have been asked to include an additional field that users can search on.

    I have attached a script that will create the required tables + add some sample...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    October 6, 2009 at 9:25 am

    #1062341

  • RE: User Permissions to Email Report Subscriptions

    Content Manager worked.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 27, 2009 at 3:24 am

    #1045390

  • RE: SP3

    Thanks guys.

    I used SELECT @@VERSION originally.

    select serverproperty('productlevel') returns 'SP2'.

    So stick with the service packs then. I can apply to a test instance and see if anything breaks.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 24, 2009 at 1:04 am

    #1043475

  • RE: SP3

    Ha! Ha! Thanks for the link.

    We have just signed 2 new players that should slot in nicely, a Japanese lad and an Italian.

    Nick-a-motor and Rob-A-Telly.....

    Back to the link. Looks like...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 23, 2009 at 1:18 am

    #1043324

  • RE: Cumulative Update Package 9 SQL Server 2005 SP2

    Hi Justin. Yes I read that post, there did not appear to be a definitive answer (but then again when is there!).

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    August 11, 2009 at 7:54 am

    #1037421

Viewing 15 posts - 211 through 225 (of 541 total)