FrançaisEnglishEspañol
PC SOFTForums homeLast messagesOnline repository
PC SOFT
Find...
Perform the searchSearch in...
Newsgroup dedicated to WEBDEV (current version), in English
Sql server reporting services
Jul., 02nd 2009 at 07:35 AM
Alan Telford
<al...nt@maxtelsoftware.com>

Message 1/4
Sql server reporting services

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...


Jul., 02nd 2009 at 12:35 PM
Fabrice Harari
<fr...eb@fabriceharari.com>

Message 2/4
Re: Sql server reporting services

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...




Jul., 02nd 2009 at 11:14 PM
Alan Telford
<al...nt@maxtelsoftware.com>

Message 3/4
Re: Sql server reporting services

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


Jul., 03rd 2009 at 01:09 PM
Fabrice Harari
<fr...eb@fabriceharari.com>

Message 4/4
Re: Sql server reporting services

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