Search results for query: *

I have got the following columns in my report Callid, QNAME, Calls, Abandoned Calls. Now i have a page total as well as grand total at the end of the report. I want totals grouped by QNAME without disturbing the page total or the grand total.what should i do in Crystal Report to get this ...

I Call Crytal report from VB. At runtime i dont want the preview pane to appear in the crystal Viewer. Is there anyway to disable this? Either setting properties or any other way? Can anyone tell me?

How do i get a grand total on the last page of my report after using the following formulas for page totals? reset formula: //reset WhilePrintingRecords; shared numbervar total := 0 accum formula: //accum WhilePrintingRecords; shared numbervar total := total + {table.numberfield}...

Versions VB 6 CR 9 and SQL Server 2000 I run a form in VB which will (execute a SQL procedure) and should then pass a date parameter to the crystal report which has to give the report for the day of the qname, caller id and the total calls. Can anyone very briefly tell me what I should do...

Hi all I want to pass a date as parameter to a stored procedure which on execution retreives records for that particular date. I want to pass this parameter from VB. How can i pass the parameter from VB? What are the parameter settings i should set in Crystal reports for the same? What are...

hai all I am having lot of problems using cross-tab . Especially when it comes to rows and columns . Its like i have some curves for which i have to display concentrations, slope , intercept and correlation coefficient my table should look like this in the end output...

I have the following output from my table in the database STUDNO AGE HEIGHT WEIGHT RACE - -- ----- ---------- ---------- ---------- 1 32 170 60 Asian 2 31 171 60 African 3 30 172 70 Asian 10 29 173 50...

I have the following output from my table in the database sorted using ORDER BY CLAUSE , sort is on STUDNO field. STUDNO AGE HEIGHT WEIGHT RACE - -- ----- ---------- ---------- ---------- 1 32 170 60 Asian 2 31 171 60 African 3 30...

I have a view retreiving data from 2 tables . In CR 7 when i select from the view , if i want to display only a paricular row or couple of rows it fetches the same. But it allocates space before and after the row. Due to which i am having alignment problems. For ex My dept table contains...

I have some statistical tables which have to be diplayed or printed in landscape format , which are present in a sub report, while the remaining pages of the main report should be displayed in potrait format ? how do i do this? i almost have these tables for evry report i work on and they appear...

In MS WORD you have the option JUSTIFY to align your text in a justified manner in a page . Is there any such option in Crystal reports? If i have text in a formula then if its in multiple lines it is auto aligned. But if i have text in a text object immdly following the formula i am not able to...

hai all I have a number returned from the database using the Count function. For eg it returns 12 followed by some text string like males. Is there any way i can display the above output as twelve instead of 12 or any other count returned for that field . This will help me in having a...

hi all I have a date field returned from the database like the following: totext(Minimum({Table.TIME}),"hh:mm on MMMM dd, yyyy") I want AM or PM to be displayed as recorded in the DB . How do i do that. Because the above formula only gives the following output 04:00 on March 15...

I have various students in a course . I have a statement in the report where i mention regarding male/female participants were there in the course. ----------------------------------------------------------- I use the following formula StringVar Sex; if {STUD_SEX.SEX} = "M" then if...

I am workin on CR V7 . Whne i try to export to RTF only the TExt objects are getting exported into the RTF. All database items are not at all getting exported. How do i try to get everything i nthe exporterd file. Why is this happening ? how do i solve this Thanking you in advance Longfellow

I have a text object in the page header having a font of Arial with bold option. But after the report is compiled and EXE file is generated , when i run the compiled report the txt object font appears normal. What should i do to make the txt object appear bold during runtime. Thanking you...

When i select a count(distinct(field.name)) from the database i get exactly one value returned. where as when i try to get the same in CR i get multiple values when i use DistinctCount function. Why is this happening? what might be the reason? Can anyone help me regd this? Thanking you in...

dear all I have a page called Table Of Contents(TOC) which conatins all the various details of the pages in the reports .How do i generate the Page numbers randomly In this TOC at runtime. B'cas the no of pages depends on the data based in my database . Are there any formulas for doing the...

dear all In some subreports i select data from my DB tables . After the subreport i have text items . Sometimes if there is more data , the subreport overlaps on the text data and everything becomes distorted. And if i try to increase the Details section's length it gets sorted out...

CR VER 7.0 dear all This is wrt to printing the report in a window after the exe file is created . i see one font while designing the report and previewing it. But after compiling the report when i run the exe file the fonts for all text items change except for the fonts for Database items...