Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NipsMG

    Conditional Group formula not sorting correctly.

    Nevermind. It's amazing to me how badly my attention to detail is deteriorating. I think it's lack of sleep/stress. The reason why it wasn't grouping the way I want is becuase i was overlooking the fact that the FirstGroup group is the one I want to break by. so I had to arrange grouping. I...
  2. NipsMG

    Conditional Group formula not sorting correctly.

    ok I got the ordering of the groups fixed.' Right now, everything is sorting correctly, but here's the problem: My Group (third group) returns the first 2 letters of the location code in a formula {@LocFirst}. I have in the group footer a "new page after" command. here's my problem Page 1...
  3. NipsMG

    Conditional Group formula not sorting correctly.

    Sure. My groups: IN ORDER: WO (Work Order, DB Value, No Formula) \_ @LocationString - if {PickListData.LocationCount} <= 1 then 'Single Location' else 'Multiple Locations' \_ @FirstGroup if {@Location String} = 'Single Location' then {PickListData.t_sitm} else {@LocFirst}...
  4. NipsMG

    Conditional Group formula not sorting correctly.

    No, it's was a typographical error in the forum post, not in the report. Thanks though.
  5. NipsMG

    Conditional Group formula not sorting correctly.

    Basically, I have 3 groups. If a flag is set one way, the formula that I'm grouping by returns a value from field, if a flag is set the other way, it returns a value from a different field. I first group by that flag, then I group by the 3 formula fields. However, it seems that the group is...
  6. NipsMG

    Conditional Group formula not sorting correctly.

    Ok, here's the deal, I'm grouping based on a formula. I have 3 groups. Each group is being sorted by a forumla. In each formula, I have if {@RecordType} = 'SingleLocation' then {MyTable.SomeField} else {MyTable.AnotherField}. If the Record type is MultipleLocation, I want it to...
  7. NipsMG

    Is conditional grouping possible?

    Is conditional grouping possible? Basically, I've got a formula that sets a flag one way or the other. If the flag is set one way, I want to group by location ONLY. If not, I want to sort by Item, then by location. The only way I can figure to do this is Conditional group by Item...
  8. NipsMG

    Read binary from database

    You're trying to retrieve BLOB (Binary Large OBject) data. Here's an article explaining how to do that: Utilize ADO.NET and C# to work with BLOB data. --NipsMG
  9. NipsMG

    Convert hex string to file/bitmap?

    I've got a library (tagnetlib) that i'm using to grab id3v2 information from an MP3 File. I'm specifically having trouble with embedded image information. I'm able to extract the data, which is in the following format: Size)HexStringGoesHere+. FrameName[Type,Enclding, MimeType, ?, ?, Data] An...
  10. NipsMG

    OpenFileDialog Issue: Can't Retrieve Filename!

    I get AssemblyName.FormName does not contain a definition for Controller.
  11. NipsMG

    OpenFileDialog Issue: Can't Retrieve Filename!

    I'm trying to use the ResEditor sample in the .NET Framework. There's code for an "Open File " Dialog box as listed below: if (openFileDialog1.ShowDialog() == DialogResult.OK) { currentFileName = openFileDialog1.FileName; FileInfo efInfo = new FileInfo(currentFileName); ...
  12. NipsMG

    DFS Mapping randomly fails on terminal servers

    I've got DFS set up for one network share. I randomly run into issues with terminal server users, who cannot map to that share. I'm using S: as the mapped drive letter. When investigating the problem, it appears the user's s: is not mapped to anything. From the command line, NET USE S...
  13. NipsMG

    Question about N-Tier Structure

    That's the kind of thing I'd love to do. It makes so much sense to do things that way, but it would be much easier for me to visualize if I had some form of example. The issue is, I've got a company of 200 people here, and at the moment, a 2 person IT department. My many hats include IT...
  14. NipsMG

    XML file as a database

    Agreed, It does have its uses.
  15. NipsMG

    XML file as a database

    I don't understand the resistance to using some kind of database system. Especially if this is supposed to be multi user, and the data is of a critical nature. If you don't want to go for SQL Server, use MYSQL or MSDE. There's no point trying to re-invent the wheel, or implement your own...
  16. NipsMG

    Question about N-Tier Structure

    I'm trying to design in this way more frequently. However, I've found it extremely cumbersome in many cases to make a separate data layer in front of the databsae. Too often, there's come complex data operations that jsut don't lend themselves to a black box, one size fits all, data layer. I...
  17. NipsMG

    webservice gurus, help with asynchronous invoking

    Oh yeah, and in the webservice, you can fire a status message back to the client by: m_smStatus.Invoke("My Status Message")
  18. NipsMG

    XML file as a database

    You'd have no record locking, and multiuser access would be unreliable. Basically, you'd have to read the XML file into a dataset at runtime. Until you decided to write it again, the XML file would stay static. IF another user opens the XML file, then you make a change and write it, his...
  19. NipsMG

    Evaluating Expressions at run time

    Just make a case statement. Pull the operator and value Public Function Compare(ByVal MyValue as Integer) AS Boolean dim Value as integer, Operator as String Value = DataRow("Value") Operator = cstr(DataRow("Operator") Select Case Operator Case ">"...

Part and Inventory Search

Back
Top