Search Results - VBForums

Search:

Type: Posts; User: MMock

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: [RESOLVED] QR Code generated incorrectly for text containing hyphen

    That might be a good idea, as I was thinking an error message from them would have been better than getting output that was wrong and not knowing about it until people here did a lot of work that now...
  2. Re: [RESOLVED] QR Code generated incorrectly for text containing hyphen

    What is not so "obvious" is how input of REP02-9 produces output of R0002-9 when alphanumeric was chosen. Because trust me, I did not input the string R0002-9.

    Again, thanks so much for the...
  3. Re: QR Code generated incorrectly for text containing hyphen

    Alphanumeric:

    122973

    Byte:

    122975

    The one generated with byte encoding works. Thanks. I just have to tell the user I have good news and bad news.
  4. Re: QR Code generated incorrectly for text containing hyphen

    I got great advice from you, too (as always) so don't think he stole your thunder!

    I don't think I am using the same code as Schmidt at all... That's why I was asking if in my case, I could just...
  5. Re: QR Code generated incorrectly for text containing hyphen

    Thanks, I may have to spend the rest of today solely on something else so I'll let you know how it goes when I have a chance to try it.
  6. Re: QR Code generated incorrectly for text containing hyphen

    Wow - that is awesome. We are scanning your QR and it is correct!

    So when you say code as 8-bit data, perhaps that is the Byte option vs the AlphaNumeric option we've been using?


    ...
  7. Re: QR Code generated incorrectly for text containing hyphen

    No special printer. The user was given the file on a network share so he printed on some printer of his. I printed on ours - it is our everyday printer used by everyone, that worked for every QR up...
  8. Re: QR Code generated incorrectly for text containing hyphen

    That returned 45 (it is ASCII).
  9. Re: QR Code generated incorrectly for text containing hyphen

    So if I just update the row, even though it would look like I'm updating it to the same thing it is, that might overwrite it with better data?
  10. Re: QR Code generated incorrectly for text containing hyphen

    Not nvarchar, but

    CREATE TABLE ...
    [description] [varchar](256) NOT NULL,
  11. Re: QR Code generated incorrectly for text containing hyphen

    Interesting thought. I created the INSERT statements in Excel because we were given a range of new locations. To save typing, I typed just "Repo1-" in an Excel cell and replicated it down the...
  12. Re: QR Code generated incorrectly for text containing hyphen

    It can be made several ways? It's read from the database. How it got into the db is the user said he needed this list of particular new locations and I created sql insert statements for them.
    ...
  13. Re: QR Code generated incorrectly for text containing hyphen

    Yes, without a dash it read it exact (W2D01). He was going to try one with a space; I'll go ask him again to do that.
  14. [RESOLVED] QR Code generated incorrectly for text containing hyphen

    I'm not sure C# is the correct forum for this question, but it's a C# program I'm using so I'll start here. I inherited a program that generates label print-outs as QR codes so they can be scanned. ...
  15. Re: [RESOLVED] SSRS to Excel and The number in this cell is formatted as text...

    I decided to start out small and omit all the formatting, get just numbers, and start adding in from there.

    My result is that only the percent row is now considered text. I'm sure he'll be able...
  16. [RESOLVED] SSRS to Excel and The number in this cell is formatted as text...

    I'm having the problem that everyone else has had - you export your report to Excel, and Excel takes your numbers and formats them as text with a leading apostrophe and marks them with green flags.
    ...
  17. SSRS report parameters are dependent dropdownlists

    This is so close to working I hate to give up so I hope someone can help me. This is a hypothetical example that illustrates what I am doing for my business. I have one dropdownlist populated with...
  18. 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.
  19. Replies
    5
    Views
    242

    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...
  20. Replies
    5
    Views
    242

    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...
  21. Replies
    5
    Views
    242

    [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...
  22. [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...
  23. 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...
  24. 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...
  25. 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...
  26. 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...
  27. 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...
  28. 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...
  29. [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...
  30. 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:
    ...
  31. Re: Practical Application of Inheritance

    public DataSet QuerySPDataSet(string ConnectKey, string StoredProcedure, object[] Parameters)
    {
    DataSet ds = new DataSet();
    using (SqlConnection conn = new...
  32. 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.
  33. 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...
  34. 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,...
  35. 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...
  36. [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...
  37. [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,...
  38. Replies
    10
    Views
    381

    Re: [RESOLVED] git question

    Thanks. I will definitely take a look at those links.
  39. 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"...
  40. 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...
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.