Search Results - VBForums

Search:

Type: Posts; User: MMock

Page 1 of 13 1 2 3 4

Search: Search took 0.08 seconds.

  1. Re: SSRS tablix - want to center a title over it

    Here is a link I would try if I had time, but I guess in the interest of time we are going to live without it.
  2. Replies
    5
    Views
    196

    Re: unions versus individual selects

    I am not sure what's going on. When I use the IF statement, I don't get the rows I don't want. When I put the condition in the WHERE statement, I get the rows but they are NULL, so I could exclude...
  3. Replies
    5
    Views
    196

    Re: unions versus individual selects

    That is what I tried first, and for some reason it didn't seem to work.

    Here is the original WHERE clause:
    where u.po = @po
    and (u.store_number not in (select StoreNumber from stores...
  4. Replies
    5
    Views
    196

    [RESOLVED] unions versus individual selects

    I am working with an existing stored procedure which explicitly creates a temp table then does: insert into #tempTable select blah-blah-one union select blah-blah-two union select blah-blah-three. Is...
  5. [RESOLVED] SSRS tablix - want to center a title over it

    I have a tablix on my report that's a pivot table and can have a variable number of columns depending on what the stored procedure returns. Is there a way to center a title over the tablix when you...
  6. Re: [RESOLVED] SSRS report that uses a pivot table with dynamic columns

    Good morning! While I did not solve it exactly as you suggested, your suggestion made me look more closely at the union statements of my final select in the sproc. I am selecting the rows in the...
  7. Re: [RESOLVED] SSRS report that uses a pivot table with dynamic columns

    Never mind that previous question; that is done. This is my last question because it is the last thing I need to do and something I am not sure I can figure out. I need a couple of blank lines in...
  8. Re: [RESOLVED] SSRS report that uses a pivot table with dynamic columns

    Truly a follow-up question I don't think I will be able to find help for - See in Post #5 I have a row called Pct Missing? I want these values to be followed by a percent sign, such as 19.2%. The...
  9. Re: [RESOLVED] SSRS report that uses a pivot table with dynamic columns

    Never mind. Looked some more and found it: remove the sorting from the group properties. The default was that this had been created so all I had to do was delete it. Thanks. (Sometimes it isn't...
  10. Re: [RESOLVED] SSRS report that uses a pivot table with dynamic columns

    If I may ask one more question. In the sproc, I am doing my SELECT...UNION statements in the order in which I want to see my rows. So I have rows named Cartons Received, Total Units Received, and...
  11. Re: SSRS report that uses a pivot table with dynamic columns

    Thanks to both of you for your replies. I used the link tg posted and it was so incredibly helpful I don't know how to thank you (and the person who answered the stackoverflow question)!!! My boss...
  12. [RESOLVED] SSRS report that uses a pivot table with dynamic columns

    I have a task to take an existing stored procedure and make it an SSRS report. Note that I did not write the sp and don't understand it fully. It is making a pivot table. I think where the...
  13. Re: Oh Sheet! Why can't I delete my Excel worksheet?

    I saw this a while ago but didn't think it was relevant, but it seems to be what I needed in order to delete my worksheet:
    ...
  14. Re: Practical Application of Inheritance

    public DataSet QuerySPDataSet(string ConnectKey, string StoredProcedure, object[] Parameters)
    {
    DataSet ds = new DataSet();
    using (SqlConnection conn = new...
  15. Re: Practical Application of Inheritance

    I believe what I need is DeriveParameters(). I knew there had to be some way to discover the params. Thanks for listening.
  16. Re: Practical Application of Inheritance

    Basically, my problem is how to pass parameters to a stored procedure when I don't know the names of the parameters because I want to have a generic method that calls any stored procedure.

    If I...
  17. Re: Practical Application of Inheritance

    Very cool. Thank you.

    This next one may be a specific database question, but any idea what is going wrong here? My sproc is expecting two datetime parameters and I am trying to deliver those,...
  18. Re: Oh Sheet! Why can't I delete my Excel worksheet?

    Yes, the workbook is of course open when I am deleting the worksheet but I was wondering if I was leaving it open or otherwise in a state where it wasn't being saved.

    Basically, it is all the same...
  19. [RESOLVED] Oh Sheet! Why can't I delete my Excel worksheet?

    I am using the Excel interop. I've been researching this for at least an hour. Everyone says just call the delete method of the worksheet, but that is not working for me. I would like to see a...
  20. [RESOLVED] Practical Application of Inheritance

    I thought I understood inheritance but now that I have to use it practically, apparently I don't.

    I am using an in-house dll to run stored procedures. The DLL has methods such as: Query, QuerySP,...
  21. Replies
    10
    Views
    326

    Re: [RESOLVED] git question

    Thanks. I will definitely take a look at those links.
  22. Re: Read Excel column names from header doesn't work for datatype double

    Yeah, I was wondering about that guy's fluff too :). I didn't know if it was because column.ColumnName was values "F1", "F2", etc. and he had to plug it into the other instruction to get the "real"...
  23. Read Excel column names from header doesn't work for datatype double

    First, I want to thank this forum for allowing replies to RESOLVED threads. I just joined ASPFORUMS solely to comment on a post and I can't because it's resolved.

    I need to read the names of...
  24. Replies
    10
    Views
    326

    Re: git question

    Hmmm, the forum said if I leave this page my changes will be lost, but instead of being lost they were duplicated. Sorry for repeating myself!
  25. Replies
    10
    Views
    326

    Re: git question

    I have no idea if my system is prone to crashes. I've been here a month. But I don't know that it isn't prone to crashes, so I am being careful :)! Thanks for the replies.

    (Every 70 minutes. ...
  26. Replies
    10
    Views
    326

    Re: git question

    I have no idea if my system is prone to crashes. I've been here a month. But I don't know that it isn't prone to crashes, so I am being careful :)! Thanks for the replies.

    (Every 70 minutes. ...
  27. Replies
    10
    Views
    326

    Re: git question

    Right, I guess it's not all that different. For some reason I feel I shouldn't push anything that isn't stellar, that I don't want everyone to have - even though you're right that a check-in in TFS...
  28. Replies
    10
    Views
    326

    [RESOLVED] git question

    We are using git as our source code control system. (I am from a SourceSafe background; years and years of it). I had some free time the other day and started to read a git tutorial so I would...
  29. Re: webBrowser control prints about.blank instead of data

    Maybe I do! You are most likely right, but this is what I ended up doing. The design kind of changed. We were going to have all this happen in the background. So, the user would make a selection...
  30. Re: Update a record using Entity Framework

    It's not Monday anymore, which in itself is pretty helpful! I thought about this a little more, and decided what I needed to do was actually retrieve the entity I wanted to update (of course!):

    ...
  31. Replies
    2
    Views
    221

    Re: Initialize Combobox Selection

    project[] activeProjects = null;
    using (DbEntities ctx = new DbEntities())
    {
    activeProjects = ctx.projects.Where(x => x.active == true).ToArray();
    ...
  32. Re: webBrowser control prints about.blank instead of data

    Maybe it's important to say that the webpage I am printing contains a bitmap. Maybe not; I really don't know.
  33. [RESOLVED] webBrowser control prints about.blank instead of data

    I'm probably missing something very fundamental, but I can't figure out what. I have a webBrowser control on my Windows form. I initialize its Url property to a webpage that my coworker wrote, and...
  34. [RESOLVED] Update a record using Entity Framework

    I have been using the Entity Framework for about 5 minutes, and I have a question on how I can update my table using it.

    I am displaying a combobox so an admin user can select a project id. The...
  35. Replies
    2
    Views
    221

    Re: Initialize Combobox Selection

    I rewrote this entirely and I have it working. I will post it later. Right now, I have to go post a database question on how to save the combobox new selection to the database...
  36. Replies
    2
    Views
    221

    Initialize Combobox Selection

    This has always given me trouble and I can't recall how I've solved it in the past.

    I have a combobox that lists our active projects. It's populated from the database and bound. DisplayMember is...
  37. Replies
    4
    Views
    236

    Re: Add new stored procedure to edmx

    Oh, I did also run this in SSMS: GRANT EXECUTE ON sprocname TO [DOMAIN\user] because a lot of my google hits said it was a permission thing. I had copied this new sproc from an existing one and...
  38. Replies
    4
    Views
    236

    Re: Add new stored procedure to edmx

    OK, I figured it out. But I am not sure I can explain what I did to help someone else :o.

    1. Open the Model Browser. Because when I first found I needed to do that I didn't know what the heck it...
  39. Replies
    4
    Views
    236

    Re: Add new stored procedure to edmx

    So given this statement: When the Entity Data Model Wizard generates an .edmx file from a database, it creates entries in the storage model for each stored procedure in the database, what would it...
  40. Replies
    4
    Views
    236

    Re: Add new stored procedure to edmx

    I was able to get the 2nd edmx file to portray the tables, but still no code is being generated to call the new sproc.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.