Database

31-Jan-11 3:01

Hello,
I would like to find a cheap (free) software package that I can use to output data from SQL Server. It does not need to be too fancy as all I am doing is connecting two tables (header and detail).

I do not do this often enough to purchase Crystal Reports.

Thanks
djj

Note I originally posted this in the Lounge as a reporting question. I guess I should have thought to put it in the DB area.

modified on Monday, January 31, 2011 9:08 AM

DaveAuld31-Jan-11 3:03

DaveAuld

31-Jan-11 3:03

As a developer, can you not write your own? Smile | :)

Dave
Find Me On: Web|Facebook|Twitter|LinkedIn

Latest Article:Data Historians! You Bought It, Use It! Real World Example
Latest Tip/Trick:Google Charting API and Formula Imaging

Corporal Agarn31-Jan-11 3:05

31-Jan-11 3:05

I am not a developer! I do a little programming but am mainly a T-SQL person as a DBA.

I did think about it though Smile | :)

DaveAuld31-Jan-11 3:23

DaveAuld

31-Jan-11 3:23

djj55 wrote:
I am not a developer

Your profile says you are.....

If your not looking for anything fancy, then sometimes rolling your own can be the best option. Sometimes giving your brain that little challenge is enought to keep you ticking over nicely.
Smile | :)

Dave
Find Me On: Web|Facebook|Twitter|LinkedIn

Latest Article:Data Historians! You Bought It, Use It! Real World Example
Latest Tip/Trick:Google Charting API and Formula Imaging

Corporal Agarn31-Jan-11 3:41

31-Jan-11 3:41

Actually my profile says I have been programming. That technically is not a developer as they generally (I hope) know what they are doing.

The number of programs being used by people that I have developed is very small and the programs themselves are simple.
Four years ago I could have knocked something out quickly but know I need to refresh my memory on how to do it which I like to do but the boss thinks I could use my time else where. Big Grin | :-D

Re: Software to create reports [modified]

moon_stick31-Jan-11 3:04

moon_stick

31-Jan-11 3:04

If you've got Server SQL, why not use Reporting Services (SSRS)?

Sarchasm : The gulf between the author of sarcastic wit and the person who doesn't get it.

Corporal Agarn31-Jan-11 3:09

31-Jan-11 3:09

Good question. Mainly I do not know how to. I guess I can get my book out and see what I come up with.

-- I have a quick and dirt report but need to figure out formatting.

modified on Monday, January 31, 2011 9:43 AM

Dalek Dave31-Jan-11 3:04

Dalek Dave

31-Jan-11 3:04

Excel?

I use it and it is easy to manipulate.

------------------------------------

I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave

CCC League Table Link
CCC Link[^]

Corporal Agarn31-Jan-11 3:06

31-Jan-11 3:06

I have a text column that is greater than 255 characters. Frown | :(

Excel has a problem when I try to move the info around.

Mycroft Holmes6-Feb-11 13:20

Mycroft Holmes

6-Feb-11 13:20

Excel as a reporting tool is a dog, integrating any office product to a database/c# application is always fraught with danger.

Outputting the data to a csv file and manipulating it in excel on the other hand is reasonable.

Never underestimate the power of human stupidity
RAH

PIEBALDconsult31-Jan-11 3:59

PIEBALDconsult

31-Jan-11 3:59

I write XML and then use XSLT to transform the data (to HTML or CSV).

Stored procedures in Entity Framework

Mycroft Holmes6-Feb-11 13:23

Mycroft Holmes

6-Feb-11 13:23

Get to know SSRS, theoretically as a DBA it does (sort of) come under database.

It's free and you can use embedded reports if your requirements are simple (if you do not need the full server capability).

Never underestimate the power of human stupidity
RAH

jonatan_55630-Jan-11 22:49

jonatan_556

30-Jan-11 22:49

Hi everyone.
First i want to ask apologize for my english but it isn't my mother language. But i try my best to explain myself. second i already post it in the .Net Framework section at Question & Answers label, but Henry Minute said to post it here because.

My Problem is:
I'm building a project using entity framework. The data base is generate by a edmx(database project). To implement business logic i use stored procedures, but i only con map the to parent entity funcions. I can't map stored procedures to an associated table.
Thanks

Re: Stored procedures in Entity Framework

Ali Al Omairi(Abu AlHassan)30-Jan-11 23:26

Re: Stored procedures in Entity Framework

30-Jan-11 23:26

give me your sp

Help people,so poeple can help you.

jonatan_55631-Jan-11 0:11

jonatan_556

31-Jan-11 0:11

Hi,
the problem is not the sp. The problem is i can't map it. I only can map sp to an Entity(stored procedure mapping) that exists in the .edmx file. Ex: sp_insertClient is mapped to the addClient at mapping functions. But imagine that is another table associted with the Client table by a many-to-many association. The intermediate table beetwen them has no entity in the designer model(.edmx file). So, i can not map a sp to that intermediate table.

Best regards

Re: Stored procedures in Entity Framework

Ali Al Omairi(Abu AlHassan)31-Jan-11 0:48

31-Jan-11 0:48

send your data as an xml to the sp as

SQL

SET @Sls_Serial = SCOPE_IDINTITY();

DECLARE @insptr Int;
EXEC sp_xml_preparedocument @insptr OUTPUT, @XML;

INSERT INTO Sales_Head
    SELECT
      @Sls_Serial_No
      -- ,<other columns>
     FROM OPENXML(@insptr,'<element path>',1)
WITH
(<column> <type> '@<attribute name>');

EXEC sp_xml_removedocument @insptr

Help people,so poeple can help you.

Installation Failure

Ali Al Omairi(Abu AlHassan)30-Jan-11 22:39

30-Jan-11 22:39

Guys, I have a situation here.
I have tried to Install SQL Server 2005 on my pc, all the components were installed successfully except the 'Database Engine'.

Any body knows why? D'Oh! | :doh:

Help people,so poeple can help you.

Pravin Patil, Mumbai30-Jan-11 23:22

Pravin Patil, Mumbai

30-Jan-11 23:22

What error did it give..?

Ali Al Omairi(Abu AlHassan)30-Jan-11 23:46

30-Jan-11 23:46

Sir, I should have thought about about you answer "What error did it give..?" I checked the log file carefully and found a the edge of the thread where i can start "Product: MSXML 6 Service Pack 2 -- (KB973686) Configuration failed." so i got redirected to the MSDN, searched for "(KB973686)" and simply fount the solution. $Shucks | :-\$

thanks for all who participated in this thread and tried to help me.
100 Rose | [Rose]

Help people,so poeple can help you.

mgr_2k731-Jan-11 2:43

mgr_2k7

31-Jan-11 2:43

Does your hardware configuration matches the one needed for the installation of Database Server?

Ali Al Omairi(Abu AlHassan)31-Jan-11 8:28