Hello all,
Can anyone give me a link to detailed instructions for creating reports in Valentina Studio? A video would be nice, or sample code?
Also, how is that integrated with the ADK for Xojo?
Am using PostgreSQL for database.
Thank you,
Tim
There is a step by step tutorial on the wiki but, it looks like someone moved the underlying files around. I have asked someone to fix it.
I always recommend using the wizard to collect up you database info step by step. After you step through it, you can make changes of course.
1 Like
Valentina licensing is a mess, we have no idea on how to know what we need for certain needs and prices in a glance. Even in a deeper 5 minutes look we end with the feeling that we are wrong and give up.
there should be a report designer.
a reporting server or you can include and use reports whithin app.
Which?
Always? Which?
You mean embed a server? Is it free?
And all those cryptic ADKs and salad of licenses?
I guess people pay for something and later learn that they bought something wrong or missing something. Like “Valentina for Xojo” and later learn that for report needs something else, and for another OS other things, and for another DB even more things, no?
Seems so complex that it deserves a price wizard full of boxes select if want this, select if you want that, and a summary of what they need and the prices is shown below.
I have to agree.
I’ve looked at the https://valentina-db.com website several times, because I’m curious about having a simple SQLite-based Server, like CubeSQL (which didn’t appear to be actively developed anymore, until very recently).
Valentina has a “free” server license, but it doesn’t say whether you get SQLite or the Valentina-branded db server. The purchased version says both - but what if I just want SQLite?
And if so, are the Stored Procedure, REST & Json features available for SQLite? It’s not clear.
Likewise, I have no need for reporting. Can I get a db version with all the bells & whistles for SQLite - but no Report Server? A pricing wizard would help I guess, but seeing the free/cost/add-on break-down in a list would be helpful too.
At first glance, it’s either “Free” or $ 1,499.95, which leaves a lot of guessing as to whether there is any middle options. There is, but you have to dig for it.
Some nice clear full-size screen-shots of the Studio and its key features would be nice too. Sure, because there is a free-version I could download and try out, but really, do I have go through all that just to discover what features are locked-out, and which are not? I want the download decision to be easy.
My apologies if I’m asking for too much.
1 Like
its all described here
www.valentina-db.com/en/discussions/forums
www.facebook.com/paradigmasoftware
(i got a good deal at Omegabundle few years ago.)
you could contact Paradigma Software and ask what software is required for your need or best choice.
1 Like
If you have back issues of xdev magazine i wrote an article back in 2014 thats still current but will need update to api2 but reports bit still valid.
1 Like
Most people won’t, me included. They may not even know they have a problem. The “give up the product at the doorstep”, the seller didn’t even know the potential clients giving up on them at the door. MOST people run away of unclear prices, don’t even bother to consult a seller when detecting cryptic/unclear/complex pricing schemes.
What “killed” Delphi? The explosion sales at $99 announced in major magazines in the 90’s became a “call us for a quote” few years later. That was a red flag for 99% of the people.
The company gave up on millions users to focus on a dozen large companies… And the IDE/language lost public interest and sunk.
there is a forum, the prices are in the shop and there is a feature matrix.
Some nice clear full-size screen-shots of the Studio and its key features would be nice too.
1 Like
I only see scattered content, it took me several minutes wandering around reading to learn that Valentina Studio Free is useless if you with to build reports, also learned that the $80 paid one let you connect to one server (so the free one probably lets you connect to zero? 
), and they consider SQLite a server, and I still don’t know if reports are included in this one, but I learned the $200 pro is the one that let’s you design reports. And you must to choose one OS. For design I prefer macOS.
So by $200 you can design useless reports, because to generate reports you need to buy more things.
So you need to buy a $200 thing called ADK Reports for Xojo, and for that you must choose another OS, hmmm, my main target is Windows, so I guess I must choose that.
Am I correct? Now I paid $400 and can design reports on a Mac for several DBs (pro) and build Windows apps able to show/print reports on Windows? What happens if I compile the app targeting macOS?
2 Likes
Iirc you need Studio Pro to design reports but you can run those reports from Studio Free including via the command line.
I do agree their licensing is so messy many potential customers will be put off though.
3 Likes
As a dev, there’s no sense on just running reports, who created them? 
Your work is designing reports and integrating them in our apps, so the only option is Studio Pro. I even guess that those paying for the “single” one (a not free, but also containing “L” that means “with unknown limitations, find it out” 
) may regret as soon as they discover that something basic does not work except in the “Pro”. That’s why I said that pro seems the only real one.
Hi guys -
We are always looking for ways to make licensing more sensible. There are three types of products:
- Studio (Free & Up. Free also acts as a deployment platform for Forms and Reports. Find differences on top menu Studio > Compare Editions…).
- ADKs (ValentinaDB or Reports. These are single connection components)
- Server (Includes ValentinaDB Server, Valentina SQLite Server, Valentina Reports Server, Valentina Forms Server)
If you want to embed a report system in your Xojo app, you get Valentina Studio PRO (for the full Report Designer, $199) and the OS appropriate ADK of Valentina Reports ADK for Xojo ($199 per platform).
You can drill down from the top menu on our website to:
Studio >…
Server>…
Developer>… (which goes to ADKs and unlimited deployment of Server through VDN).
We also set up some specific bundles by development system, such as “Reporting for Xojo”
The licensing is complex so you don’t have to pay more if you don’t need something.
@Rick_Araujo We have customers that pick up a copy of Valentina Studio PRO to create a project that contains reports. You can program in some parameters to a report, and hand the project to someone else. They can in turn, run the report using the FREE version, and use the parameters to give them a wide range of options. The report can contain just about anything you pull from the target database. That is very, very useful if you have users that need to regularly run or print a report but aren’t particularly tech savvy.
1 Like
ADKs are licensed according to OS & platform for deployment. If you aren’t deploying on macOS but are deploying on Windows only, then you don’t need the ADK for macOS. When your app starts, it initializes the ADK engine using a string you pass to it on start up. The engine is deployed with your app.
That said, you can run / print your reports right within your copy of Valentina Studio PRO or Valentina Studio free version. In the case of the latter, you may have built your report on the mac, but it can be used on Linux, macOS or Windows.
I didn’t say that. I said Design the report in a Mac, so Studio Pro macOS. App built for Windows, so ADK for Windows (probably a plugin I guess);
Shouldn’t, as my app should provide parameters and data that only the app has to fulfill it. And I prefer to embed the report into the app, not expose it so the user could damage it.
The command line interface has some interesting switches 
I would never use CLI due to the mess in protected systems not allowing such thing. Better just to use the direct API calls of the plugin.
btw
if you have many reports for the users as example in a business environment a report server is more handy
because reports are often in change or new ones added.