Dear All,<br/> How can I populate a data report using a Sqlquery.<br/>Thanks in Advance<br/>Dana

Can someone tell me why is this not working? After the else is the error. It states that it is not part of the formula.WhilePrintingRecords;numberVar numNB;numberVar numRPC;numberVar numMC;numberVar numMRPC;numberVar numDPP;numberVar numNB2;numberVar numRPC2;numberVar numMC2;numberVar numMRPC2;nu...

I am running CR X and Access 2003 database. I have a table defined as Employee and one of the fields is called RESDate and is defined as Date/Time.The RESDate has a default value Date () - 1. Bascially, I am deriving yesterday's date. When I view the table in Access, I see yesterday's d...

Hello,I am trying to use a query in CR9 to pull the latest date of a DREXAM for each patient. The patient can have one item or several items. When I run this query, it only pulls back one record, the latest DREXAM from the whole table, not by patients. I need it by patients. Any ideas on what I&...

How can i display CurrentDate in a parameter field on parameter form?

I created a report in Crystal Report 10 with the specifications Server Name=db02 ;User id=sa;password=something;Database=Northwind;The Client machine spcification are:Client's Server Name=Srv;User id=abc;password=xyz;Database=NorthwindCopy;My Web Application does not change the all these specif...

Hi everyone.Maybe this problem seems too stupid for someone, but I'm going out of my mind. This is my aim, I want to specify the terms for many groups, for example (nothing to do with the real data):I have a population data, and I need three groups:- The first one, with the people who are up to...

Hello,I am getting the following error message while attempting to print a report.The code is given below:-me.CrystalReport1.ReportFileName = App.Path & "\reports\purchaseOrderDupli.rpt"me.CrystalReport1.sqlQuery = sqlStmtme.CrystalReport1.parameterFields(0) = "org;" & moduleOrgcode & ";true"me.Crys...

Recently we migrated our citrix farm to presentation server 4.5 in windows 2003 . In our bank we are using crystal decision 9 for one application reporting . Now in 2003 terminal services the error is comming like report load failed. But if we login locally in that citrix server it is working perf...

Hi all,I am using VB6, PostgreSQL 8.1 & Crystal Report 8.0. Now i am able to achieve the connection between a Crystal Report and postgresql database thru ODBC DSN which is hard coded in that crystal report @ design time. Is it possible to establish connection between postgresql and crystal report on...

Hi,I want to save (bar/pie or line) chart as image file using CR 11 in .NET and later create PPT using saved image files. Is it possible? Don't worry about creating PPT, which is not related to crystal report. I am looking for the solution to first one.If any of you done before or similar to th...

Hi Friends, I need to set the maximun and minium value and Number of divisions to chart at run time.Can any one please help me out in this? If any body get the links of related to this.I need the Keyword related to this ,to use in my coding..Thanks in Advance, Kavitha...

Hi all,<br/> in may application i use crystal report viewer of visual studio 2005.Ther's a way to set the viewer's export button only for .pdf files?<br/>Thank's

Sorry for the newbie question. I have a need to share reports with non-Crystal users. I'd like for recipients to be able to access reports and refresh the data. Is is possible via web or a reader if the recipients don't have access to the databases? Or, is there automation contained with C...

I would like to find away to have Crystal generate a table of contents or an easy way to create a table of contents in crystal.<br/>I am using Crystal version 10 with an Access database.<br/>Does anyone have any suggestions?

in my pageheader , got country and cityname.below it, is a section that has district as a group.below it, is detail section with game field in it.query:select country, CityName, district,case when (population > 200) then game else null endfrom country, province, citygroup CityName, districtmy pro...

I have a report that after it's compiled and executed it will not stay in the landscape layout?? Even if you run the executable and set printer options to landscape and then print or print to window the setting default back to portrait?? Please advise

One quick question.Can anyone help me with memo field that I have on crystal XI?I see only about 200 characters on a memo field.what is the max characters memo field can hold on crystal XI?I've got to bring this answer to the meeting tomorrow morning. I'm doomed....

Hi there,<br/> <br/> How can i display dynamic table on the crystal report dependes on the data. I mean how can i add and remove table columne dynamicly dependes on the data comes from the data base.<br/>Thank you for your help...<br/>Best regards,<br/>hoho

Hi AllI'm new to Crystal XI so have a basic question for you guys. I have a report with 3 subreports and sometimes some of the subreports run onto more than one page. I would like to be able to repeat the subreport header on each page when this happens. Any ideas?Much appreciatedOz...

I am using Crystal, from VB6. Does anyone know how to get Crystal to create an export file, without first previewing the report on the screen with the Crystal Report Viewer? I need to create multiple excel worksheets from a database, and can't figure out how to get the view to do the export pr...

The data in the report is different from the data in source table (SQL Server). How can I refresh the data? Pressing F5 is not refreshing the data. <br/>Thanks!

If I pull data from excel using ODBC query, I don't get the data truncated.However, if I do it from Crystal Report XI, I get the data truncated.I noticed that crystal report makes the data as memo field since it is large data. I edited the field so that it can grow and no limit on max number of...

I need two values from 2 subreports,so i created formula on each with shared variables as: 1) shared numbervar usagehours := {Command.HRS}2) Another subreport variable as, shared numbervar nextduehours := {Command.HRS} In main report i write a formula as:whileprintingrecords;Shared numbervar usage...

I have a VB application with about 75 installations that uses the Crystal Control (Version 7.0) to print Crystal RPTs. On about 7 of these installations the clients are getting duplicate lines (usually on the last page or a single page report). 1) Using the same data (and reports) we cannot create t...

Hello everyone, 1st time poster!I've not been using Crystal reports long and subsequently don't know much and need help.The company i work for uses Efacs v7.2 from Exel Systems as it's ERP with Crystal Reports 7 as the report generator/writer.We generate a works order/schedule that is...

hai,I am developing my application using VB6, Crystal report10, Msaccess.My problem was i am unable set database path in the crystal report 10 dynamically.Prev. in crystal report 8.5 i use the connection property SetLogonInfo. But in crystal report 10 the property does't exist. what is the equi...

Is there a function that will return a table name? Say I have the following field on a report: BIKES.City_Price<br/>I like a way to return "BIKES". Is this possible? Thank you.

I have a crystal report form.I use lines and boxes for layout.But I found it's hard to make changes, if we want to make a field smaller, a row shorter, we have to move or adjust all the other lines below to make the form looks good. is there an easy way to do this, like in other develop tools,...

I have a report, details a and details b. i need details b to show when a series of formulas are met.I am having trouble getting this to work:{loan_main.datepurchased} <> {?Date Purchased} AND not ({loan_query.reivname} like "*wells*")AND is not performing an AND...help me please.thank you :...

In a web-based application, I am trying to display a report that is wider then the width of the screen. Instead allowing horizontal scrolling, the report columns are compressed so the rows fit on 1 page. This makes the report unreadable and unprofessional looking. How to I make the columns stay...

I have a subreport inside of a report that I want to copy and paste in another part of the report (two identical subreports in the same report).<br/>What is the easiest way to accomplish this?<br/>Thanks,<br/>Michael

hi i have designed one crystal cross tab report.it is displaying only column heading.but i want to assign heading for rows also. col1 col2 col3row1 row11 val1 val2 val3row2 row21 val1 val2 val3but i want heading for the...

Im currently using CR v9. Just want to ask how can i select records to display during runtime or in formula. I only want to display in my report the latest date but it keep on displaying all the available dates for a record. Pls help. urgent need. Thanks!Sample:KeyID Description...

Hi, i have one sub report placed in main report.i have to calculate the totals of every page and it should displays in the footer.when sub report records exceeds 25 that subreport extends to the next page.so i could n t able to show the totals in the footer..after completion of the sub report onl...

hi,<br/> hw to display sub report footer in every page.i can able to display the header of sub report in every page.but i could n t able to display the footer of the sub report in every page..pls help me..thanks in advance

I have two detail sections A and B. Details A is on one page, then a new page starts for Details B.<br/>I want Details A - Legal Size<br/>Details B - Letter Size<br/>How can I accomplish this.<br/>thank you

Posted: 27 May 2007 08:27 Post subject: Change the format of text object in sdk ------------------------ hello! when i'm trying to change the format of textobject in skd(using java). its only change the format of the first object in the textobject. TextObject p2 = new TextObject(); p2 = (TextO...

I have a report in which I am using 5 Subreport. Whenever I export the main report in pdf format then the only blank page has shown. I am not able to understand the problem. and when I export the report that has only 1 report without any subreport that it's work properly. So plz temme the solut...

HI<br/>can anybody tell me how to show crystal reports on Web page ?? <br/>Thanks

df

I am trying to create a report with three parameters (date, license number and application number). I want report by License Number or Application number in the date that I put in. I trying following in Record Selection:1.{Command.LICENSE_NO} = {?License Number} or{Command.LICENSE_ID} = {?Applicatio...

Hi,I'm using the Crystal Reports that shipped with Visual Studio 2005, in Visual Basic..In the form, there's a button that says "Main Report" that start as the default on all new Crystal Reports Projects as far as I can tell...I'd like to add a second option there, that loads a second...

Hello Everyone,I am new to Crystal Reports and I know this is very simple. I have created a report with a discrete parameter where the user can enter a value when opening report. I would like to give the user the option of entering a parameter and displaying the selected data or entering no value...

Within the CRXI application, is it possible to access an object's properties (eg, width, etc.) in a formula in the Formula Editor, at runtime?Specifically, I would like to place an object to the right of a crosstab table which may expand horizontally. Can you set an object's runtime '...

I AM GOING TO PRINT DATA ON PRE PRINTED FORMS USING CRYSTAL REPORT 10.For this purpose i am using EPSON LQ 2170 printer.Pre Printed form consist of three sections.If user send one record from report, only one section should be printed with that records and printing should be stopped here.if user t...

hello, i just started using crystal reports and have been trying to get the report to display the same fields as shown below.2006/02/11 2005/11/09 2006/01/01 James john sandy2003/08/16 2007/01/22 2006/01/01...

I am trying to work out a formula that works out the change in disk size on our servers and whether they have increased/decreased in size. We have created a table on our database server, that looks at the disk space used, and total disk size. This was created on the 23 March 2007. Effectively the re...

I need to set the size of the page 8.5*3.5<br/>can i change it.

I want to suppress rows using formula if any duplucate invoice_no found.For exampleOrder Customer Amount InvoiceNO1 100 100 7 2 200 1000 63 100 3000 7-- i want to supress this line4 300 5000 85...