What is the best way to get the days left in the month excluding the weekend from todays date? <br/>Also to get the count of the days in the month excluding the weekends?<br/>For example: If today is Mar.15<br/>WeekDays in the month: 22<br/>WeekDays left: 12<br/>Thanks.

Is there a way to take a record that is in ALL CAPS and convert it to Uppercase and Lowercase?<br/>I have contact first name like MICHAEL and last name SMITH and would like for it to appear in my Crystal report as "Michael Smith"<br/>Is this possible?<br/>Newbie here.<br/>thanks,...

Dear All,How do I calculate the number of years directly from a report.for example there's a join_group filed in areport so I need to subtrat that from the current date in order to get the number of years that the employee has been with the company. I tried yusing this but it doesn't work:...

Hi,<br/>i hv a datagrid i want to show the available rows according to the height of the screen(without Scrollbars) not by PageSize property of the DataGrid<br/>Pls give me some ideas<br/>thankyou<br/>veeresh

I'm working on cleaning up a report and got a request to bold certain words within a data field. I have no idea where to start or what to search on to do this. For instance, I would want to bold any occurance of "History:" or "Technique:" but not bold "history". The data is coming over as pl...

Dear all,Hope you could help me with two issues.Issue #1:I'm building a CR Report dinamically passing an ADO recordset. After creating the TTX file y call the CreateReportOnRuntime Function and begin assigning the fields with AddFieldObject. For now everything goes ok but I need to set the Left...

I have been using Crystal Reports for some timw now, but in the last few weeks I have noticed that when I change the qry driving a report and update this on the server, Crystal Reports Viewer still accesses the previous version of the qry, even though this no longer exists. I have tried everything...

I'm trying to read a querystring parameter to set my report database location.I thought the following would work, but if I look in the properties of the report, the database/catalog is set there, and it looks like the code behind below won't create the connection @ runtime. If I try it ag...

Hi,I have a Access 2003 DB with password protection. I am using VB6 to conect to the DB using conn.connectionString . I created report using CR9. Every time I run the report from VB a dialog box opens asking for username password. How can I prevent this from happening. conn.ConnectionString = "Pro...

I have a report where I want to supress the header based on a condition that has to do with the number of records in a group.I started by creating a formula to count records and placed that in the details section and hid it.I then created a condition to supress the headder.It seemed to work for the...

I have this parameter and in its options I have the "Allow multiple values" check and then "Discrete values(s)" checked as well.When I go into the "Select Expert" and put the parameter into the expert I get this message... "This array must be subscripted. For example: Array [i]". Any Ideas on how...

I'm a newbie to CR so be gentle :) I'm using ver. 10 I'm going againt 2 tables in a SQL database.The first table has contains problem reports and the second has the remediations they are linked by OutageID. My problem is that on the Problem table there can be several reords that have...

Hi,In a page ASP when executing a report Crystal Reports 9. the screen of the report is all gray. Somebody knows how to tell me that can be happening. Thanks. ASP with Crystal Reports 9 and RAS 9 In the projects he/she has these pages ASP. ActiveXPluginViewer.asp A...

Need help. I am new to crystal reports. I have the sql below that would run perfectly fine unders windows SQL 2000 server and give me the results that I needed. But I can't get the correct count from crystal report if I only want each distinct record to shown once.SELECT TYPE, PART_NUM,...

I have a forumla {@frmPrevMonth} and it contains information like... "21,36.02,11141.75,1" which it came from a Parameter field.It can contain more of less information.What I need is that it can be broke down in order in which they came.1st Detail line: 212nd Detail line: 36.023rd Detail line: 11141...

Hi All! While Exporting a crosstab report to Excel data only, the % column data is corrupted. After exporting to excel, I write a macro to fix the problem. Now how to publish this macro in BO XI ? When I export a Crystal report, how to automatically run this macro? Any help w...

We are migrating from Crystal Reports 7 to 10. I've referred CRAXDRT.dll and crviewer.dll in VB6. I can able to call the reports.But it doesn't show me the correct results.Duplication of records arises. The query return 22 rows.but report shows more than that. I've given correct links...

heywe are using crystal reports with oracle backend.JSP is used to create front end.Our crystal report has got a sub report tat is supposed to open in the second window. But when it opens it asks for the user name and password. i m not sure how to remove this prompt and automatically set the user id...

Hi, anyone has CR repository on an Linux, RH4.0, Oracle 10g RAC? Could you share any info about it?<br/>TX.

I'm creating a report and wish to use field {Session_Starts.Special_Date}. It is a string field and I want to create a formula where this field automatically draws in the next string item.Example if the special date is March 26, 2007, I want it to use the next string item, which is April 9, 2...

Hi guys,i'm using Sql Server, VS2k3 +VB.NET, CR 9. My problem is this:I have a Strongly Typed CrystalReport, and a CrystalReportViewer, i have a databse i wich i must access so i can fill my CrystalReport, when i created the CR, i typed the connection, the DB, user & pass.But everytime the View...

Any body help me that I want to use Crystal Report viewer 8.5 to explore the conditional report. For Example<br/>Show data from date to date, or show data for particular code(s).<br/>Yours cooperation in this regard is highly appreciable<br/>Thanking yours.

I have an at destination time (FDC_Trips.atdtime) and a created time (FDC_trip_Packages.createdtime). I want to know the difference between the at destination time and the created time. I was looking at the DateDiff in help but I did not see anything pretaining to time. Thanks as always!

Hi,is there any way to initialize the Runnig Total Variable Value to Zero and reset to zero upon group change?.The requirement goes like this. aTable having payment Details.I want to summarize all the payments done by "Cash" into a seperate location and those non cash on another location. the field...

Im using a Crystal report and i have to split the records to be printed from the application.For Eg: I Generate a report which has about 2000 pages, now i want to print first 500 as one job and then the second job with the other 500 and til 2000 pages.Now i want to know how to split this records..If...

i have these three tables.Supervisor -------SupID -->PK Student--------StuID --->PKSupervisorStudent--------SupID --->FK StuID --->FK This way i could show the students were tied unde...

I can not export any files to .XLS on the server, but I can on the local machine. Any ideas? Strange thing is that I can export to PDF. Is this a bug in CR 9?

Hi people,first let me apologies ive only been using crystal for 2 weeks now and have been asked to do change a report.The current report works out the turnaround from date A to date B in calendar days. The only trouble is that all other turnarounds in the company are done on working days through a...

I am using VB6 and CR10 & SQL Server 7I am working on an inventory project nw.. I'm new to crystal reports..For the report i need to pick data from 2 tables(Sales_Details, Purchase_Details) There is no link between these 2 tables (except a similarity that both have got a date field) TA...

Hi EveryoneIs there a way to find an average of a day using a cross tabExample. If there are two Mondays. Some one made 4 calls on one Monday and anthoer 4 calls on another Monday. I need to find the average of the Monday. Which would be 4 calls. Is it just possible to still keep the daily sta...

Friends,i have developed a system using VB 6.0 ad crystal report XI, and system is working quitely in my system...and i installed the system in client machine (package is created using visual studio)when i was trying to run report at client, i got error titled as 'invalid TLV Record' i hop...

Hi guysJust a quick question that has been bugging me.I have made up a formula that tells Crystal Reports to put some text into a field if it is empty. The formula goes as follows:if Instr({Config.Notes}, " ") = 0 orisnull({Config.Notes})then "No Equipment Notes." else {Config.Notes}So if the field...

Hi,<br/>Somebody already made Crystal Reports to read a base HTML. <br/>If yes. Which datasource should I use? <br/>Thanks

I have the formula below that gives me the difference between the at destination time and created time. There may be cases were there are multiple times. I want to average the time result. As always, any help is appreciated!NumberVar YY;NumberVar BB;NumberVar DD;NumberVar HH;NumberVar MM;NumberVar S...

Can ne1 tell me what is the best way to handle barcode fonts in crystal report?I installed IDAutomationHC39M barcode font on my machine and used it in the report. when i used it it shows me the barcode and if i print from the crystal report ide it prints the barcode too.Now when i try to load the sa...

I've facing problem in creating the package for the application using VB6 and Crystal reports 10. What are the support files needed to be included in the package. I've already included Crviewer.dll,CRAXDRT.dll. But there is no response in the client machine.Whether Crystal Reports 10 need...

i have issues regarding the parameter passing to report, currently i am passing the date parameter like this.cv.SelectionFormula = "{tt_detail.tt_date} >= Date(" & Trim(datefrom) & ")" & _ " And {tt_detail.tt_date} <= Date(" & Trim(dateto) & ")"tt_detail = Table Namettt_date = Date Colu...

Is there a way that I can have recordset data in ASP, linked up to a label in Crystal 9?<br/>Thanks.

EnvironmentVB6.0Crystal Report 8.5problem : "Unable to connect: incorrect session parameters." Error MessageI generated my crystal report using PEOAuto. and having above error message whencrystalreport.previewline is executed.there is no formulaparameters are passed.report is generated from crystal...

Hi,I have very simple requirement. I would like to create a crystal report using XML. This XML file will be decided at run time (not at design time).Hence i have added a crystal report viewer control to my windows form and did not choose any data source (i left it blank currently). Now i am trying t...

Hi all. Great Forum by the wayI have a question. I have some crystal reports that people open via a hyperlink on a web page. This brings up the crystal report but people have to then "refresh" or "run" the report themselves. They are then prompted for a "start" and "end" date for report.Is it possib...

Hi,in my Crystal Report is a OLE Object with a reference. The content of the document that is referenced may change. If I open the report as preview the OLE is show right and it looks good when i print it out of the preview.If I print it directly with PrintReport(), some printers print right and som...

I ask some help for two problems .How to change the letters of the cutline in the CrystalReport?How to change the letters on the cakychart bigger in the CrystalReport?If you know some methods,please write back to me as soon as quickly.My Email is Nanty201@hotmail.com . Expect your letter.Thank you v...

Hi All,I am working with Crystal Reports and am relatively new to it.Reports are been shown using the .net framework. My problem is that while the report is been displayed the CSS are pesristing and the report looks good.However when i export the report to any other format (PDF, Word, etc.) the CSS...

Hi all,I am working on Cyrstal Reports 10 with .Net framework.Whenever i display data in the group section it has a link to it. On click of that link it shows the current section and all its child sections.However this problem does not occure when i display the data in the details section of the re...

I have a vb.net program that reads an xml file and creates a crystal report.It all works fine except it takes so damned long. So i'd like to create a progress bar just to show the user that something is going on, right now i have it looping from start to finish. However there doesn't seem...

Can anyone tell me what is wrong with this?<br/>Month({Command.Date_Received}) IN [({?ParamMValue})] <br/>?ParamMValue could have... (2,3,4,5) or (2) or (1,2,3,4,5,6,7,8,9)<br/>Why is it telling me that I need a number range in the IN statement?<br/>What should I do instead?

Hi,i am written a vb code which actually uses crystal reports 10 dll's and tries to invoke crystal reports 10 as well as reports designed in crystal report 8.5the problem here is i have a report designed in 8.5 which gets data froma view. when i try to call this report from my vb application us...

Hi All.I am using VS.2005 and 10.2.51014.0 version of Crystal Reports.I have a windows application.I am using a lot of images on my reports.Error in File c:\winnt\temp\{2824C0F2-A23B-4BA7-9239-D75C53D838A}.rptThe request could not be submitted for background processing.With some other combinations o...

Hi,<br/>I am facing error while tring to run a .rpt file (perfectly running on CR Verion 8.0.2.672) in CR Version 8.0.0.371. It just takes date and time parameter to run.<br/>Anybody if had faced similiar problem or have some idea to resolve this, pls reply.