DLL OR OCX??

Question

DLL OR OCX??

Meera

SSCommitted

Points: 1966
More actions
June 16, 2010 at 4:53 am

#387168

Dear all,
Kindly clarify my doubts regarding the following,
1. Can a report created via BI or SSRS be helpful to create a dll file ? (Sorry for my innocence reg this)
2. if so how should the dll file be converted to a ocx file.
I am slightly good in writing queries, but our client asking to see the reports into their application itself and not in SQL Reports Server.
Heard from ppl that once we can able to create a dll from SSRS reports it should be converted to ocx in order to view the report from their application. But i dont know how to do so or whether is those are possible.
please if any could help me, i'll be glad and thankful !!
Thanks in advance,
Meera.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

you probably heard wrong, i think.

a SSRSreport is saved to a .rdl file(RDL=report definition language?), which is xml for the report's structure,design,location of all it's objects, etc.

that is what your client want's to see. they can add that rdl to their own SSRS server, rather tahn getting just a sql and having to design the rest.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Meera SSCommitted Points: 1966 More actions · Answer 2

hi Dear,

Thanks for your reply !

Fine, in addition let me explain a little more.

(Kindly bear if this is not the right forum to post my queries)

What they have done is

1. Created a dll file holding SQL server connection string along with the query required (from Visual studio 2005 project 'Class Library').

2. Now they create a OCX file placing the dll in. (I dont know what exactly is done)

After all done, they register the ocx with thier application and using to view their customized reports.

I am trying to find out but still failed.

Kindly let me know if this is not the right forum, where can i port to get a solution

Thanks and Regards,

Meera.

Meera SSCommitted Points: 1966 More actions · Answer 3

Meera

SSCommitted

Points: 1966

June 21, 2010 at 1:04 am

#1182555

Any light on this ???

please ....

Lowell SSC Guru Points: 323518 More actions · Answer 4

maybe i'm mis reading the request, but it seems to be "show SSMS reports in our application instead of SSRS web pages". I had thought it was different.

I'm assuming the reports are already written, but now they don't want to....what? open an IE window? get hassled with logins/security of the SSRS server?

AFAIK that is not possible. you cannot compile the SSRS into a portable DLL.

other options might be:

1.opening the IE inside your applicaito, but it would still go to the SSRS installation/pages.plenty of exampels on codeproject where they make your own browser you could use as a model.

2.read the xml from an RDL file,parse out the pieces for your application to use, and use that to present the results of simple reports(no sub reports)

in a grid within a windows form. if you open an existing rdl file, you'l see alll the information related to the report is inside it. binding a grid to a datasource based on the sql within the xml is trivial, so extracting the sql from the xml is the easy part....the column names would have to come from the xml if they are different than the dataset's column names. it's not an easy project, but not difficult either. other settings, like widths, colrs and stuff are doable as well.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 5

Sorta sounds like a Crystal Reports requirement being pushed at SSRS....

It's a litttle hard to tell exactly what you're trying to achieve but you *might* be able to get what you want by utilizing local reports (*.rdlc) and the report viewer control. Basically, you take you current RDL and convert it to RDLC (see here) and then include these in your project. The report viewer control then does the call to retrieve the data and render the report.

HTH,

Steve.

Meera SSCommitted Points: 1966 More actions · Answer 6

Dear,

Thanks for your replies !!!

i found that i has to be done as a vb project and then to take the dll created inside our application and then from there i need to trigger the query to return value.

Thanks for your time !!

Meera.