Search results for query: *

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...

I was given this SQL code by our Data Base team. Please have a quick look. They want me to use this, but I would rather do this with Crystal Syntax. Here's the SQL code.... SELECT "CallLog"."CallID", "CallLog"."RecvdDate", "CallLog"."CallStatus", "CallLog"."ModDate", "CallLog"."KeyWord"...

Hello - Here's the report in drop box. Please review... https://www.dropbox.com/s/91gvfi50jtpc7yw/Quarterly_BWHelpdesk_Tickets_Report_v0.2.rpt Please let me know if this works out. The report is a CR11 report. The relationship between these two {Asgnmnt.Assignee} and {Asgnmnt.GroupName} is...

Right now its 3:45P my time. So I will add the report here in a few hours. Thanks Pete.... This is not in the record selection formula. Here's what in there now.... {CallLog.RecvdDate} >= totext(date ( year(dateadd("q", -1, currentdate)), if month(currentdate) in [1,2,3] then 10 else if...

Hi, I have a question? Please. If the formula is used in the Group Selection... Distinctcount({Asgnmnt.Assignee},{CallLog.CallID}) = 1 and {Asgnmnt.GroupName} = "BWHelpdesk" Will it bring me back tickets with multiple or single assignments only within the BWHelpDesk? Or will it bring me...

Pete - I tried that but tickets with assignments to other groups are also coming in. I did notice that there was a link from the Calllog table to the Asgnmnt table that looked out of place. It was a link from (CallLog Table) DTLastMOd to (Asgnmnt table) DTLastMod. I removed that link and I am...