Forum Replies Created

Viewing 15 posts - 436 through 450 (of 541 total)

  • RE: Report Delivery Options

    Thanks to all that posted. I have configured SSRS as suggested, now I need to have aplay. I will check out that link and have a read up.

    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 6, 2008 at 8:28 am

    #853850

  • RE: Report Delivery Options

    I will take a look.

    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

    August 5, 2008 at 6:31 am

    #853133

  • RE: Format Part of an Expression?

    Resolved. My last post resolved the issue, I just needed to modify the report!

    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

    June 3, 2008 at 8:59 am

    #823679

  • RE: Format Part of an Expression?

    Update

    The following workin when I execute the SQL query but returns an error when I run the report?

    '£' + CONVERT(varchar(12), CAST (CVCustomsValue.CustomFieldValueDecimal as money),1) AS CustomsValue

    -------------------------------------------------------------------------------------
    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

    June 3, 2008 at 8:52 am

    #823672

  • RE: Format Part of an Expression?

    Hi Christopher. I do not know why I tried that as the data type is decimal so no conversion required!

    I simply want to format to 2 decimal places.

    '£' + CONVERT(varchar(12),CVCustomsValue.CustomFieldValueDecimal

    The...

    -------------------------------------------------------------------------------------
    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

    June 3, 2008 at 7:52 am

    #823616

  • RE: Format Part of an Expression?

    I have now modified the query as follows:

    '£' + CONVERT(varchar(12),CVCustomsValue.CustomFieldValueDecimal,1)

    How do I get it to display to 2 decimal places?

    I tried:

    '£' + CONVERT(varchar(12),CONVERT(decimal(5,2),CVCustomsValue.CustomFieldValueDecimal))

    That returned error: Arithmetic overflow error converting...

    -------------------------------------------------------------------------------------
    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

    June 3, 2008 at 7:16 am

    #823587

  • RE: Add Parameter to enable user to input value GETDATE + 'Parameter' value

    Thanks Steve.

    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

    June 2, 2008 at 2:37 pm

    #823309

  • RE: Advice on Query 'Expiry Date' GETDATE() + 5 Days?

    Thanks for your feedback 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

    May 30, 2008 at 12:48 pm

    #822511

  • RE: Add Parameter to enable user to input value GETDATE + 'Parameter' value

    Hi Matt. Gave that a whirl. The report failed to return any records when I entered number of days as integer.

    Is this due to the field being of data type...

    -------------------------------------------------------------------------------------
    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

    May 30, 2008 at 12:53 am

    #822123

  • RE: Add Parameter to enable user to input value GETDATE + 'Parameter' value

    Hi Matt. Missed your post. Thanks, will give that a whirl back at the office. The report runs as expected from within the application, just not within visual studio?

    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

    May 29, 2008 at 11:27 am

    #821893

  • RE: Add Parameter to enable user to input value GETDATE + 'Parameter' value

    Update. OK. If iI execute the query via the Dataset then enter value for @Expiry as 03/06/2008 the query runs as expected. If I execure via the calendar on the...

    -------------------------------------------------------------------------------------
    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

    May 29, 2008 at 7:25 am

    #821738

  • RE: Add Parameter to enable user to input value GETDATE + 'Parameter' value

    Hi. I have tried replacing the <= GETDATE() + 5 with <= @Expiry

    In the report I set the parameter data type to DateTime. When I select the date from the...

    -------------------------------------------------------------------------------------
    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

    May 29, 2008 at 7:20 am

    #821733

  • RE: Advice on Query 'Expiry Date' GETDATE() + 5 Days?

    Thanks. I now have a related question regards the report side that I will post to the relevent forum.

    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

    May 29, 2008 at 6:17 am

    #821708

  • RE: Crosstab Query

    Thanks for the reply Michael. I did not intend to change the schema. What I am doing currently is deleting the data from the tables in the database I wish...

    -------------------------------------------------------------------------------------
    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

    May 17, 2008 at 2:15 am

    #816843

  • RE: Identity Column Inserts Issue.

    Hi Sandy. Do you have an example as I could put that to good use.

    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

    May 14, 2008 at 10:41 am

    #815395

Viewing 15 posts - 436 through 450 (of 541 total)