If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > Custom Report Tools

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
Custom Report Tools

Hello,

I need some suggestions of a need to build a custom report. I have a SQL Database 2008 R2 that has several tables within the DB. My users enter data in tables such as "Personal Info", "Vehicle Info", "Memo" and "Expierence".

I need a way, to build a query for say the person's name in the person table and the resulting custom report will place the data from that person and related linked table data on a viewable or printed page. I would need to initially create the look of the report and the results of the query will fill the fields of the report.

This is much like MS Access will allow you to design a report to print. I am not looking for a tubular or row of data reporting, I can do that without an issue. It is the type of report that I need to place the data in sections of the custom report with the data fields in each section.

If there is a free or low cost version of custom reporting tool (other than Reporting Services from MS)?

Does anyone have any suggestions that will assist me?

Regards,
Joe
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Oct 2009
Location: 221B Baker St.
Posts: 487
Maybe it will help if you "mock up" a sample that shows what you want.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
Excellent Idea.

If I have done this correctly you should be able to see an .doc attachment. The example is very very simple but what I need in a custom report is much more detailed and this is why I am seeking assistance in finding a custom report creator for my users.
Thank you for your assistance
Joe
Attached Files
File Type: doc dbexample.doc (134.5 KB, 8 views)
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Oct 2009
Location: 221B Baker St.
Posts: 487
How much are you/your organization able to spend?

As you are already running SQL Server, you might consider SSRS (Sql Server reporting Services).
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
Yes they are MS Sql Server 2008 R2. This is a site that I am a consultant. I have no ability to purchase for the client.

I have looked at SSRS but in my research it appears that it needs a server license and client licenses, per seat. I could not determine the cost of this item or if it will even allow me to develop reports of the data in a manner I needed.

Joe
Reply With Quote
  #6 (permalink)  
Old
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 14,794
The SQL Server license covers the SSRS license as long as both reside on a single Windows Server.

I'll be shocked if you can envision any report that will give SSRS trouble... I know thosands of users, and have yet to see any report that it could not produce.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Nov 2012
Posts: 4
Thank you PatP, I will contact my client's Microsoft rep to see if this will work.
Regards,
Joe
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On