Forum Replies Created

Viewing 15 posts - 9,151 through 9,165 (of 9,725 total)

  • RE: Lining up the subreport

    DOH! Nevermind. One column in the main report was a different width then all the other columns. It was throwing everything else off.

    Thanks anyway. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Daily Newsletters for past two days???

    Frances,

    I'm talking about the email subscriptions. I'd like to know if they were actually emailed out.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: How to Run Missed Scheduled Jobs/Subscriptions in MSRS '05?

    Dave,

    SQL 2k5 & SSRS 2k5 set up jobs in SSMS to relate to each individual timed subscription. The bad thing is they name the job with some sort...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Divide by Zero frustration

    Now there's a nifty piece of code I need to book mark. Thanks, toolman!

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Upgrading Access Report with DLookup

    Matt,

    Part of my problem was that I was using a dynamic SQL string to create a PIVOT of the totals to get my group totals for the subreport. I've...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Divide by Zero frustration

    Matt,

    You're da bomb! Thanks, that worked perfectly.

    Don't know what I'd ever do without you. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Anyone taken 70-445 (BI exam)?

    Dave,

    90%? Depends. How comfortable do you actually feel with the material? Do you think you could pass the exam, no distractions, without having a copy of BOL...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Contracting question - Left old company, but still provide support.

    Question on the insurance issue. Are you guys just talking about health insurance or other kinds of insurance?

    What if you're a FTE someplace else (with health insurance) and doing...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Upgrading Access Report with DLookup

    Matt,

    Yes, I did put the subreport in the group footer, and ended up getting all total lines on each individual group.

    I'm going back to the end users to see if...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Rant: sa account

    Adding to what George said, if you have the SA pwd, then you definitely have the ability to back up your own databases. I would assume the MAS people...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Rant: sa account

    I'm going to have to get back to you on the "permit in database role" stuff for SA, but I wanted to mention something to you about your last post.

    If...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Upgrading Access Report with DLookup

    I did actually have the subreport parameterized, but maybe I set it up wrong. Thanks, Matt. I'll look into it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Rant: sa account

    What it means is they've packaged their datafixes in an .msi or something similar which has the SA account hardcoded into it and it just prompts for a password.

    I've seen...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Upgrading Access Report with DLookup

    Matt,

    I'm not sure Rollup is going to work with this. The detail takes the PaidAmt and divides it by #Claims. I'm not quite sure what the load process...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Upgrading Access Report with DLookup

    I'm thinking about this report and-ideally-here's what I'd like to do.

    Have 2 datasets. DataSet1 is the detail. DataSet2 is the totals.

    Write some sort of expression or code where...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 9,151 through 9,165 (of 9,725 total)