PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → Sql server reporting services
Sql server reporting services
Débuté par Alan Telford, 02 juil. 2009 09:35 - 3 réponses
#1
Posté le 02 juillet 2009 - 09:35
Has anyone integrated WEBDEV with Sql server reporting services (SSRS)?
I already have 40-50 reports in SSRS running from a SQL server database.

I'm evaluating WEBDEV for suitability to provide an alternative front end to SSRS. Basically it would need to allow users to:
- logon to a website
- maintain some tables/forms
- integrate and run SSRS reports.

I can already do this from a simple ASP.NET website.
But it will take a lot of work to extend it to support the maintenance of an additional 40-50 SQL tables, so I'm wondering if WEBDEV may be suitable for the task.

Any comments please...
#2
Posté le 02 juillet 2009 - 14:35
Hi Alan...

I have NOT done that, so it's just an idea. Can one of those report be
started from a stored procedure? If Yes, then you just have to create
the calling procedure and start them from webdev, and that is easily done

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


Alan Telford wrote:
Has anyone integrated WEBDEV with Sql server reporting services (SSRS)?
I already have 40-50 reports in SSRS running from a SQL server database.

I'm evaluating WEBDEV for suitability to provide an alternative front end to SSRS. Basically it would need to allow users to:
- logon to a website
- maintain some tables/forms
- integrate and run SSRS reports.

I can already do this from a simple ASP.NET website.
But it will take a lot of work to extend it to support the maintenance of an additional 40-50 SQL tables, so I'm wondering if WEBDEV may be suitable for the task.

Any comments please...
#3
Posté le 03 juillet 2009 - 01:14
I have NOT done that, so it's just an idea. Can one of those report be
started from a stored procedure? If Yes, then you just have to create
the calling procedure and start them from webdev, and that is easily done


No. I don't think so.

To ask a different way, in ASP.NET I do this by dragging an ASP.NET rsweb:ReportViewer control (from Microsoft.ReportViewer.WebForms assembly) onto a page.

So it is possible to use an ASP.NET control on a WEBDEV page?
If I can use an ASP.NET control, then I should be able to use the report viewer control?

Thanks,
Alan
#4
Posté le 03 juillet 2009 - 15:09
Hi Alan

several ideas:

in webdev, you have the html field in which you can basically put
anything html compatible (flash by example)... This may support your
reportviewer control, but you will not be able to drag and drop the
control itself, you'll have to copy some html code...

Another possibility is to maintain your tables in webdev (easy enough)
and use either embedded report pages (your standard asp pages in an
iframe) or external ones (as webdev is able to execute an external script)

Hope this helps

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


Alan Telford wrote:
I have NOT done that, so it's just an idea. Can one of those report be
started from a stored procedure? If Yes, then you just have to create
the calling procedure and start them from webdev, and that is easily done

No. I don't think so.

To ask a different way, in ASP.NET I do this by dragging an ASP.NET rsweb:ReportViewer control (from Microsoft.ReportViewer.WebForms assembly) onto a page.

So it is possible to use an ASP.NET control on a WEBDEV page?
If I can use an ASP.NET control, then I should be able to use the report viewer control?

Thanks,
Alan
→ Revenir à WEBDEV 2024