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...
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...
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>...
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 -...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.