Recent content by gennaroalpha7

Yes, thank you - developing a database from scratch, and migrating flat file data to this new relational SQL database. Thank you for helping out. Alpha

Does anyone?

Hi, How can I get the new SQL DB to produce the "paper report". Do I need to add more tables to the new DB, and relate them, to create the (paper) new report based on the columns of the paper report? How is this process completed? What are the "tools and techniques to take a report file...

Hello - There's is report that I want the SQL DB to produce. My question, how can I get the DB to produce the report - the data is not in the DB to produce. The paper report has 10 columns and between 20 the 40 rows of data from another DB. This report is on paper - what do I need to do to...

Thank you.

Hello - Does anyone have a good (MS Project) database development project plan that I can borrow for my own use? Thanks for your help. Alpha

Thank you everyone! I will take your suggestions... Alpha

Thank you all for your submissions... We want to build a SQL server relational database that will be more helpful than the legacy (flat file) Management Information System that we have now. We will need to migrate files over to the new DB. The goal is to modernize and make it easier for our...

Hello - Anyone know of any good (free)tutorials for MS Reporting Services? Thank you. Alpha

Hi All - We have a legacy flat file MIS that is used for report generation. We want to develop a SQL relational DB. My questions please... 1. What are the steps/deliverables to develop this DB - I am a Business Analyst on the team? 2. What do I need to collect to develop the DB? Thank you...

Interesting... Thanks for your help on this one Pete. Have a good one... :) G.

On the second, single assignment, report the group selection formula seems to be working... just asking - what's the difference from... Distinctcount({Asgnmnt.Assignee},{CallLog.CallID}) = 1 and {Asgnmnt.GroupName} = "BWHelpdesk" To this... Count({Asgnmnt.GroupName},{CallLog.CallID}) = 1...

Yes, it was correct. Thx. I copied the wrong formula to the Group Selection. Is the code provided above for the second report - pulling single assignment tickets from the BWHelpdesk group/department? Thx. G.

Hi Pete - It appears it's working. I have checked quite a few tickets and so far so good. Thx. There's two reports that are kind of a pain. There's this one that pulls tickets with single or multiple assignments in the BWHelpdesk group/department. Here's the Group Selection formula for this...

Hi - Here's the updated report with the changes. Please review. https://www.dropbox.com/s/91gvfi50jtpc7yw/Quarterly_BWHelpdesk_Tickets_Report_v0.2.rpt I have changed the group Selection formula per your suggestion...to Distinctcount({Asgnmnt.GroupName},{CallLog.CallID}) = 1 and...