MongoDB data source

Stimulsoft Reports.NET discussion
vks
Posts: 1
Joined: Wed Apr 20, 2016 9:12 am

MongoDB data source

Post by vks »

Hello,

I wanted to create some reports from MongoDB data, so I followed these Stimulsoft tutorials on youtube:
http://www.youtube.com/watch?v=8d00pQ7hpmE
http://www.youtube.com/watch?v=oCfpMlAbkXY
http://www.youtube.com/watch?v=VAj1KySNhCc

I tried that on version 2015.3 (fresh install) and had several problems:
1) error while trying to download and install mongodb driver via Designer.exe (it told me that something was wrong with URI) - ok, I did that manually (and was able to see my MongoDB database's structure).
2) error while trying to use query syntax shown in the videos - it always said "some lexemas remain unprocessed".
I rollbacked to version 2015.2 then (uninstalled 2015.3 completely, installed 2015.2) and there were no problems with the above two steps, so I think you should recheck the changes you made in 2015.3.

So now I can query MongoDB data source, but I have a question: how can I use aggregation functions? What syntax should I use? I need to be able to group, sum and count data on MongoDB's side. I can't pull 20 GB of data to the client for that (obviously). Please, help.
.
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: MongoDB data source

Post by Alex K. »

Hello,

We made some improvements and fixes in that direction. Please check the latest build.
If the issue still present, please send us a sample which reproduces the issue for analysis.

Thank you.
t3rminator
Posts: 3
Joined: Tue Jun 12, 2018 3:44 pm

Re: MongoDB data source

Post by t3rminator »

.
Last edited by t3rminator on Wed Jun 20, 2018 7:44 am, edited 2 times in total.
t3rminator
Posts: 3
Joined: Tue Jun 12, 2018 3:44 pm

Re: MongoDB data source

Post by t3rminator »

Hi,
I use Stimulsoft Designer 2018.2.2, try to connect to mongodb 3.6, but data collection not shown after doing the instruction shown in above videos.
1.png
1.png (43.98 KiB) Viewed 4174 times
but no any data collection shown in select data page
2.png
2.png (46.77 KiB) Viewed 4174 times
Can any one help?
the mongodb.cfg :
"
systemLog:
destination: file
path: c:\data\log\mongod.log
storage:
dbPath: c:\data\db
net:
bindIp: 127.0.0.1
port: 27017
"
Last edited by t3rminator on Thu Jun 14, 2018 6:51 am, edited 1 time in total.
Lech Kulikowski
Posts: 6238
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB data source

Post by Lech Kulikowski »

Hello,

We need some time to investigate the issue. We will let you know about the result.

Thank you.
t3rminator
Posts: 3
Joined: Tue Jun 12, 2018 3:44 pm

Re: MongoDB data source

Post by t3rminator »

Hi,
not found any solution?
Lech Kulikowski
Posts: 6238
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB data source

Post by Lech Kulikowski »

Hello,

We are working on the issue. We will let you know about the result.

Thank you.
vanivk
Posts: 4
Joined: Thu Jan 03, 2019 9:33 am

Re: MongoDB data source

Post by vanivk »

Hi Team,

Even I am facing the same above issue for 2019.1 version downloaded yesterday. MongoDB connects successfully, however does not show the list of collections. Does the issue still remains unresolved?

Thanks,
Vani
Lech Kulikowski
Posts: 6238
Joined: Tue Mar 20, 2018 5:34 am

Re: MongoDB data source

Post by Lech Kulikowski »

Hello,

There are some problems with MongoDB adapter. We are working on this problem.

Thank you.
vanivk
Posts: 4
Joined: Thu Jan 03, 2019 9:33 am

Re: MongoDB data source

Post by vanivk »

Hi Team,

Any update of the above issue? Will there be a new release with this fix?

Regards,
Vani
Post Reply