Search results for query: *

Create a cross tab with item as the row and store as the column. Use the quantity as the summary value. This will do the trick.

Gary, Yes, I have linked using ?PM-?salesperson and selected data in sub report based on field vOpportunity.SALESPERSON_NAME The sub report selection criteria then contains the phrase {vOpportunity2.SALESPERSON_NAME} = {?Pm-?salesperson} Can't see what is causing the problem. Everything...

lbass - Thanks but I can't make the sub report the main report as it wouldn't make sense. In our database the problem could exist even if I did this. Gary Parker - The sub report is linked by passing a parameter and does not rely on any field in the container report. The container report uses...

Crystal 9. I have a report with a linked sub report. The reports are linked by a parameter value. If the container report returns zero records, the sub report is also blank even if there are records in the database which conform to the passed parameter. Any body give me a clue?? :-(

I need to remove database name & table owner from some reports that I need to distribute. eg; LIVE.dbo.Organisation to be Organisation. I am using ODBC to connect to a SQL Server database. I know how to do this in 8.5 but but I have just upgraded to 9 and canot figure it out. Help Please...

Try this. I use it all the time and it resolves the issue. When using ODBC to connect to the database ALWAYS use the same DSN name eg; crystal_reporter. Using set location remove database name and table owner from the table list in the report. eg; LIVE.dbo.Organisation becomes just...

Ken, Makes perfect sense when you put it like that! Thanks a lot. Bill :-) SSTATZER: Thanks Anyway Bill :-)

Ken, we can create a reports user with those permissions. Database is SQL Server 2000. Can you help? Thanks in Advance. Bill SSTATZER: Thanks for the suggestion but I have only one set of Attendees. The event is not broken down into daily sessions so your suggestion will not work in this...

I am trying to create a daily attendance list for an event. I have a list of attendees and the requirement is to print the entire list once for each day of the event. The event duration in days is held on the database as is the start date. I must show the date for each day in the list header...

Rohan, Have you tried this? Open the report in Crystal Reports. Do to the menu and select Database -> set location. In this window, ensure that the database name and owner shown in the lower panel for each table is for the correct database. Use the set location function to correct this if...

I have a report with 2 group levels. Page headers and footers are displayed. The data display only shows GH1 and GF2. GF2 contains totals. All other sections are suppressed. Headers and footers are set out in columnar format on A4 landscape. Columns are printed down then across. If group 1...

I am using Crystal Reports 8.5 on a SQL Server 2000 database. I have a report that displays a field of type 'TEXT'. The field is set to 'Can Grow' with no limit. When the report is run in CR 8.5, if the length of the field content means that the text should continue on the next report page...

Saw this one late but some people may be interested in a very simple formula for working days, hope this helps someone. Bill :-) The following formula calculates the number of working days in any given period. This is based on a Monday to Friday working week and does not allow for Holidays...

Assuming that the numbers in [] brackets are the positions of the numerical parts of the string, try this: tonumber(mid({security_profile.salary_code},15,1))+ tonumber(mid({security_profile.salary_code},16,1)) The mid() function returns a part of a string in the first line starting at position...

Yes, You need a detail section to hold only the line

If the above doesn't work: Check the version of P2s0dbc.dll on the PC running the application. If the version number is 8.0.0.84 go to the Crystal Decisions web site and search for a download of P2sodbc.dll. They have a new version, 8.0.0.85, which has resolved problems with our application...

You need to put any field or header located below the 'Can Grow' field in a separate detail section. To do thisright click in the details section and select 'Insert section below' from the sub menu. Move all fields & headers located below the 'Can Grow' field into this section. shrink the...

try a formula such as: {datetimefield} - Previous{datetimefield) Hope this helps Bill Fagg :-)

Yes, convert it by using the ToNumber() function. Syntax is Tonumber({Fieldname}) Glad I could help. :-)

Try a formula which evaluates the time value and assigns a category between a and f (six categories). You can then group by the formula field. This will allow you to have your 6 groups and maintain the actual time values