SharpDevelop Community

Hi, I want to know which programs could I use to create reports for my application in sharpdevelop.

I tried the SharpReport but there is a problem with stored procedures, another program? I be trying with NeoDataType Report but I didn't find any tutorial, so I am having many troubles and using a lot of time to learn it.

I used to work with Crystal Reports. There is a way to use crystal reports in sharpdevelop?

Please help me.

Evelyn

P.D Sorry for my english.

Hi Evelyn,

sorry for my late answer, but i stay in holidays. If you can name me the problems with Sp's i can give you any kind of help. Also i'm working on an example how to use SP's including Parameters with SharpReport

Peter

Hi Peter,

Well, I have problems with reports with stored procedures including parameters. I wrote an email before.

I have an error like this "SharpQuerySchemaEnum.ProcedureColumns not supported by SQLOLEDB.1" in the window of Pull Data Model, also if y press next I have this error "Object reference not set to  an instance of an object" at show Query result window.

I'm using SharpDevelop 2.0.0 Buil 1591 and net framework 2.0

Hi,

i think there is something wrong with your Connection to the Database. You should use 'Microsoft OLE DB Provider for SqlServer' when you are asked for a provider by MSDATALINK to connect to the Database. The error message 'Object reference not .....' means that there is no valid connection. 

 Also you can find many questions and answers about connection to a database here in the forum. Also there is a link how to install MSDAC 2.x on your machine.

 Hope this helps

Peter

Me again,

http://community.sharpdevelop.net/forums/1/6994/ShowThread.aspx

please read this thread.

Peter

Hi Peter,

I'm working in win xp sp2, with mdac 2.8. installed.

I use the sample that is in the readme of the SourceCode of #D. Also I use in my report a 'Microsoft OLE DB Provider for SqlServer'  v. 2000.85.1117.00.  I test the conection in the wizard of #report and everything is ok. I select my stored procedure and drag it to command text section but when I click on the next button I obtain the followings errors :I Value cannot be null, Parameter name: stream" or "Object reference not set to an instance of an object"

Also when I expand stored procedures in the database window, there is an error in all the stored procedures : "X SharpQuerySchemaEnum.ProceduresColumns not supported by SQLOLEDB.1". But not exists any error in tables and views.

I create a report in Crystal Reports, only for proving the connection, using the same stored procedure and using the 'Microsoft OLE DB Provider for SqlServer'  and everything is ok. So I don't believe that there is a problem with my connection to the db.

I really don't understand why I'm having this error in #report

Evelyn

Hi Evelyn,

i think i solved your problem.

 Under this thread http://community.sharpdevelop.net/forums/thread/10479.aspx i told you to get the newest version of #Develop

I solved the problem with ref 1694 and you are working with ref 1591!

So if you get the newest download from the repository and give them another try.

Peter

To obtain the latest source code, follow these instructions - a short excerpt:

You can use anonymous / no password to get the sources:

SharpDevelop 2.1:

  svn co svn://sharpdevelop.net/sharpdevelop/trunk/SharpDevelop SharpDevelop21

SharpDevelop 2.0:

  svn co svn://sharpdevelop.net/sharpdevelop/branches/2.0/SharpDevelop SharpDevelop20

In any case, you can then always stay up to date with:

   svn update

About #develop, the open source IDE for writing .NET applications
04.08.2005 09:04:19 - Fah2710in the folder SharpDevelop. To create the executable file, navigate to the src folder and type:

 releasebuild 

Hi Peter, 

I downloaded the last realease 1710, but I still have the same problem with the stored procedures. :(

"SharpQuerySchemaEnum.ProceduresColumns not supported by SQLOLEDB.1"

Evelyn

Hi Evelyn,

i send you a private Message

Peter