Seal Report Forum
»
General
»
General Discussions/Other
»
How to use XML String/file in Seal Reports
Rank: Newbie
Groups: Registered
Joined: 5/22/2018(UTC) Posts: 0  Location: Pune
|
I am new to Seal Report.
I have a XML where we have defined rules with there UpToMark value(assume for password the UpToMark value is 6).
And another table(SQL) having the user wise entries which having their rattings for Password (it could be 2, 4, 6, 8, etc).
If users UpToMark => 6, then that password rule is satisfied for user. If it's below 6 then its failed for user.
So table having the user's data and wanted to show in report, in terms of users.
But we need to crosscheck users get UpToMark value with the value defined in XML.
To work with this, I wanted to know -
1) Whether Seal Report directly accept XML and provide output in table format? Then I can run comparison
2) Whether we can call API with the input parameters in Seal Reports and in response API can pass Dataset/Table
Most welcome if there are any suggestions.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
For XML input you might try NO SQL Data Source, there is a sample in the report
41-No SQL Source - XML Google API.
To get and use the input parameters, you should check
51-User input - Connection and threshold
52-User input - Select columns to display
A Pre-load script is defined for the model...
Actually you can code what you want, but you must be familiar with C# anyway.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 5/22/2018(UTC) Posts: 0 Location: Pune
|
Thanks for your quick reply.
But customer is using MS-SQL and there we are trying all these options.
Can I achieve this with additional C# code.
If Yes, please provide some guidelines/steps.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
MS-SQL is not a problem.
You can also create a task that loads the XML into a table so you get rid of XML staff in the model.
Difficult to say what is the best approach.
Good luck.
|
|
|
|
|
|
Seal Report Forum
»
General
»
General Discussions/Other
»
How to use XML String/file in Seal Reports
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
