Search results for query: *

I'm trying to build a report that has something similar to this Depart Category Staff Age Years Hidden(Yrs/Age*) 12 Baby Boom 12 20 1 240 12 12 Seniors 6 40 3 120 18 18 27.5 1.66 33...

I have a calculated field, with a formula inside it that runs fine and can be summarized in Crystal 8.5 When I try the exact same values and formula in Crystal 10.0 it says the "Field cannot be summarized". When I comment out one of the fields (it's fomula below), all works fine. Why would...

I'm trying to create a view that will be used with Crystal Reports, in conjunction with other tables. The table the view is based on is the HR table, with user name and location. If I create the view: select user_name, loc where SYSTEM_USER = user_name This returns the correct result for the...

I'm trying to create a report with tables, not a stored procedure attached to the report. The problem is, I can't find a way to get the users' NT account (Crystal 8.5) into a formula to compare with the HR table in the filter for the division of the individual. I can create a view that uses...

As the company has adapted to changes for SOX and creation of new applications for other divisions, we've encountered an issue. In seperating data, we've taken an application from Schema1 and moved it to Schema2. The problem I have now, is how do I change the Crystal Reports to reflect this.

When security the front end database for my access application, I would like to be able to ensure users are able to read/write/delete to attached tables, but not be able to go to the Database Window and run queries/edit tables directly. It's been a while since I worked with security, could...

I've developed javascript code that works within .NET, when an item is selected from a DropDownList, a textbox on the screen is filled with this value. The problem I have now is that I want all the formatted text (Carriage returns and all) in the item selected in the dropdown list to be copied...

I'm trying to write a select statement that lists the first Invoice sent out to each of our customers. The catch is that the lowest Invoice number with that customer ID may not be the first sent out to a customer. i.e. We are invoicing a customer in two different systems and require a union...

When I created an invoice report, a cross-tab subreport was at times going to a second page. Is there a way to carry across the page header for the invoice, and add this to the overall page count of the report, numbering it as one goes?

I've developed a report with numerous cross-tab reports within it. The problem I have is space in the cross-tab, such that with varying sizes of numbers causes column overlap. Is there a way to print the cross-tab amount with the minimal decimal places for the amount. i.e. 1200.00 8.25...

Building a report based on tables in Crystal, I've encountered a discrepancy with Oracle (DataSource). Off an invoice I refer to the same code table multiple times to get potential descriptions for fields (the source field may be null) The problem I hit is that due to some fields being null...

I've created a custom dataset holding a table Bid_Items (Holding Bid_ID, ITem_ID, Item_Description) populated using a dataadapter and a select statement. I then take this dataset and create 2 views which I then have to bind to different grids. Doing the bind itself seems to be find, but when I...

I am working on a Bid, Bid Details data entry screen and have decisions to make on how to work with Grids/Datasets/Lookups and Templates. My table layouts are as follows: Bid Bid_ID, Company_ID, Bid_Date ... Bid_Item Bid_ID, Item_ID, Cost_Category_ID... Item Item_ID, Item_Name...

I am working on a Bid, Bid Details data entry screen and have decisions to make on how to work with Grids/Datasets/Lookups and Templates. My table layouts are as follows: Bid Bid_ID, Company_ID, Bid_Date ... Bid_Item Bid_ID, Item_ID, Cost_Category_ID... Item Item_ID, Item_Name...

I've found that in running the same selection routine in Access to Oracle and CR to Oracle, Access performs the work in 1/2 the time. Is there some setting in CR that improves the performance. Currently I had both simply displaying all details, so the comparison was fair: Crystal Reports...

I'm currently running the Query Analyzer and am able to create an export file, but the issue I'm having is the garbage blank line and xxxx row(s) affected are also appearing in the export file. Is there a setting such that this doesn't occur?

When using the following formula in Crystal reports 8.5: DATEDIFF("n", {t_TicketHeader.th_StartTimeStamp}, {t_TicketHeader.th_EndTimeStamp}) It fails to recognize the function or the 2 fields being Datetime values. When the SQL is run in SQL Server 2000, it runs fine with results...

I have 2 views in SQL Server I access through ODBC within Crystal Reports. One view takes a total count of vehicles within the organization, the second takes the daily usage of each vehicle. On the report I want to figure out percent utilization of the vehicles, but due to the fact on...

I've developed a stored procedure to retrieve the travel logs for vehicles on a specified date. The issue I'm hitting now is I want all vehicles, even if they didn't travel on that date to be returned, with the travel info simply blank. i.e. Vehicle1 June 13 25Kilometers Vehicle2...

Is there a way of using something such as multiselect on a for that contains all the details of an invoice. What the user wishes is to pick records in the detail area and then mass change a flag on just the selected ones.