Search results for query: *

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

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

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

Hello Everyone - Can I please get some help from your expertise? Thanks in advance for your help. I need to extract all tickets in a set period that have been assigned to the “BWHelpdesk” queue where multiple assignments to “BWHelpdesk” are ok but the results cannot include tickets that also...

Hello Teachers - I have a report that I am trying to filter tickets from the group BWHelpDesk. I want tickets that have only the assignment to the group BWHelpdesk. I am getting tickets that have an assignment to BWHelpDesk, but some of the tickets have assignments to other groups as well...

Hi - I noticed on an old report that someone used this, Hfwdatetodate({CallLog.ModDate}) on the report. I cannot find any reference to HFWdatetodate in Crystals Help library. What does HFWdatetodate mean and why did they use this? Thx. G.

Hello - Hello - I know a search can be made within a field for a word, but I am not to sure, or I don't know how to accomplish this...To do a search in a field for certain characters within a larger set of characters. For example: I would search, in the Call Description field, for DXXXX...

Hi - This is a continuation of thread thread767-1733072 - I would like some help from more experienced Crystal Developers please. I have 4 fields on my report. They are CallLog.CallID, CallLog.RecvdDate, CallLog.CallStatus, and Asgnmnt.AssignStatus I would like the report to pull Open Tickets...

Hello Teachers - I have been asked to create a report with tickets that are "Open" and have no "Active Assignments". Most tickets that are "Open" have at leaset one "Active" assignment. They want to find tickets that are open, but do not have any "Active Assignments" so they can issue an...

Hello All - Thanks for your help in advance. I have CR8 on my computer, and I want to transition to CR11. My question: Can CR8 and CR11 reside on the same computer? Will CR11 open reports created in CR8? If I open a CR8 report with CR11, what kind of problems can I expect to find? Thx. G.

Hello - I would like to calculate the days between two fields/dates - {CallLog.RecvdDate} and {CallLog.ClosedDate} both of these fields are strings. I would also like to subtotal the total number of days for each group, and the total number of days for all the groups/departments Thanks for...

Hi - Currently I am using CR8 with SAP Business Objects Enterprise XI. My question: Can I have CR8 and CR11 on the same computer and use them both with SAP Business Objects Enterprise XI? Thx. G.

Hi Everyone - I have a report that shows analysts if they have tickets. Please help with a formula to have a check on this. I would like Analysts to only be on the report if they are the Owner and have the current/latest Assignment on a ticket. 1. Owner of ticket field {CallLog.Tracker} 2...

Hi - Has anyone ever encountered this problem? When exporting a CR8 report to a PDF some of the title headers have an extra "i" in the words. Is there something in CR to prevent this from happening? Thanks. G

Hello Experts - I have a field that analysts enter a date for journal updates. I want to add a formula to the report the selects the most current date of this field. The field is 'Journal.EntryDate' The formula that I currently have is: Maximum({Journal.EntryDate}, {Asgnmnt.GroupName})...

Hello - I have a field 'Journal.EntryDate (string)' that analysts use to update a ticket with a journal entry and date. Every time there is an update to a service desk ticket they enter an update to the ticket. Tickets can have a few to several journal entries with each having different dates...

Hello - Thanks in advance for your help. In this report I have placed 'Current Closed Tickets' field that produces a count for each analyst at the far left, For that field, a 'Running Total Field' was used with a formula. The field to Summarise is 'CallLog.CallStatus', the type of summary is...

Hi - I would like to create a macro to copy (4 or 5) multiple rows to 1 row on another excel spreadsheet. Can this be completed. Pleas be specific and elaborate - I have never created a macro before...help! Thx. G.

Hi, I know there are a few functions to remove duplicate values/rows. But what is the best one to use to remove, or not show duplicate rows on the report. Please eleborate. Thanks. G.