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 Chris Miller 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. blaatblaat

    Obtain a record from a table via a formula

    It is quite easy, I had even two options to solve this problem. 1) Solve this in SQL (xml parsing) 2) Use an ADO.NET Dataset (which I have chosen) With that dataset I can fill it in the codebehind of a page and do SetDataSource on the crystal report. In this way I've all the data parsed which...
  2. blaatblaat

    Obtain a record from a table via a formula

    Yeah, well I thought that the a formula can work differently by passing by new values, but what didn't work. I have already realized that it only grabs the first value. I have now an another solution for my problem and personally I think it is a better approach for heavy reports with lots of...
  3. blaatblaat

    Obtain a record from a table via a formula

    It can be 0, 1120, etc... it needs to iterate through the records
  4. blaatblaat

    Obtain a record from a table via a formula

    I'm sorry I forgot indeed the XML data. Here is a sample of the XML data <Service.Address xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Fields> <Field Type="Rack"> <Alt>Rack</Alt> <Value>12</Value>...
  5. blaatblaat

    Obtain a record from a table via a formula

    Alright my table of resources looks like this: Id (int) - LanguageId(varchar) - Category (varchar) - Value (varchar) And some example data 5555 - en-US - System.UI - Some english value 5555 - nl-NL - System.UI - Some dutch value 5556 - en-US - System.UI - Some english value 5556 - nl-NL -...
  6. blaatblaat

    Obtain a record from a table via a formula

    Well, that was also a thought of me to use the Add Command in the database expert. Only there is only one slight of a problem. This will select only one time the resource instead of dynamically. In the example what I have described in the first post I select a ID from the XML and with that ID I...
  7. blaatblaat

    Obtain a record from a table via a formula

    Thank you for your reply lbass, but I'm not quite sure what you mean. You mean that I need to set the table into my database expert?
  8. blaatblaat

    Obtain a record from a table via a formula

    In the report that I'm working on has some localization in the reports. I have a seperate table in my database which contains the necessary resources for localization. This table has two fields where I can identity which resource I want to use. These fields are the ResourceId and the LanguageId...
  9. blaatblaat

    [CR/C#] Not able to concatenate values from a table

    Hello, Following the thread: http://www.tek-tips.com/viewthread.cfm?qid=1588797 did not succeeed for me to concatenate values of a specific table. My table has the following set-up: ObjectId - FieldId - Value 88896 - 1 - 3 88896 - 213 - 123 88896 - 100 - MyValue My job...

Part and Inventory Search

Back
Top