I am VERY new to Crystal Reports. I have several job numbers that have several payroll dates in each job. I have no problem selecting the job numbers, but my problem is I am only looking for the "Last Date" in each job.Now I have thisJob# 1 6/6/07 6/8/07 6/10/07I want thi...

Another newbie question for gurus. I'm new to using Crystal 8.5, yeah I know it's old.I've created a somewhat huge sql query using "Enter SQL statement directly" into the Crystal SQL designer. (I dislike using the SQL Experts/Wizards/Builder)Code for the "subreport" query goes somewhe...

Can we Use GDI+ in crystal reports?<br/>Regards<br/>laby

Hi,I have a oracle package with few functions in it that returns certain values like name, address, state and zipBut while I am passing these valus to get the result on the crystal report viewer on a web browser, I am not getting any special characters like dashes, commas, parenthesis...ends up in e...

How can we create graphical report using crystal report<br/>regards<br/>laby

I have created several reports from an Excel Spreadsheet and they worked fine, if I happen to reboot or close the spreadsheet and reports and try to open them again and refresh, i get the following two errors.Crystal Reports - Database Error (No rowset was returned for this table, query, or procedur...

I've got a report that works great in Crystal, but when I run the report in VB, I get a nearly blank report. (see attachments)There are 3 sub reports in the main report.Here is the code that I use for the report. I've used similar code before and it's worked before.Dim CRXReport As...

Hi all - I recently started a new position and inherited a very old application written in VB6 that calls a number of Crystal 8.5 reports. My boss wants me to change the look and feel of the toolbar.Here is my problem Everything I have found on this subject indicates that I need to do this through t...

I have a report written in crystal reports 8 that generates an error 'not supported' when any one of three particular fields are included in the report. If I leave the three fields out then the report runs fine, if I put them in then the report is returned as blank and a pop-up box appear...

I am modifuying a report which was created by someone else,I 'm not sure what this formula is doing :dim strInputstrInput = {Header.INSTRUCTIONS}formula = replace(replace(replace(strinput, "<br>", chr(10) & chr(13)), "<b><u>",""), "</u></b>", " :") & chr(10) & chr(...

Hello,Is it possible to show a record number or count by group? I know the RecordNumber field will show me the number for the whole report but what I would like is the following:Group A 1 2 3Group B 1 2 3Instead of group B being 4,5,6...I'm trying to figure out how to number the li...

I have an access table with multiple data fields. When I add the fields into my crystal report all of the data fields show data except the date field.I then imported the same table into a ms querry and the date field pulled the data in excel. So there is data when I pull it into excel, but none when...

Hello,Hope someone can help me with this. I have a report where I'm generating records with a specific attribute lets say "ABC" and each reacord has multiple advisers. I would like to see all these records on my report but would like to include a field where the adviser code is "XYZ". If the a...

I am using v11 to create a sort of pledge/installment dashboard report. This report needs to consist of a cross-tab, as well as the main report. The main report is formatted as follows:Group #1: NameGroup #2: Pledge InstallmentIn the detail section, I am trying to show two different values. I nee...

hello, <br/>Is there a way that we can set the row height in a crosstab in crystal report to be dynamic?<br/>Please help!

I have a formatting issue in my report.Issue is one of the field's data continues on next page.Field header and value are in two d/f sections.Requirement is when field displays for first time or on first page, it has a header i.e 'INSTRUCTIONS' but when it continues on next page the...

hi, i'm exporting a crystal report to PDF...it should be pretty straight forward right?in my crosstab objects, i have a double underline for a field, when i export it PDF, it shows up as 1 thick line....is this just a bug within crystal? or am i doing something wrong...i simply go to file>ex...

I use the following code to login to a crystal report based arround an ms access database<add key ="AccessDB" value="d:\goldmine\orielgold\Goldmine.mdb"/>ConnectionInfo crInfo = new ConnectionInfo(); crInfo.DatabaseName = appSettings.Settings["AccessDB"].Value; crInfo.ServerName = appSettings....

In cross tab i have List of hospital name in Y axis. If i click any Hospital name it should drill down new tab and show the list of doctors in that hospital. If i click a particular doctor name ,it should show all the info abount the doctorfield name aaaaabbbbbccccccif i click aaaaait should show a...

I have designed a CR which looks like a form for woker filling information.to maximize the usage of A4 size paper, my tentative design the A4 size paper has 2x2 forms.Now, I can show the report in 2x1 (top and bottom look like) but how to show it in 2x2 (top and bottom with 2 columns showing form) ?...

I am trying to import a text file into Crystal 9. I have used text ODBC drivers, MS Assess type connections. Whatever I try, the first record is always skipped. Crystal is using the 1st record as a field label. The file is a straight ASCII file, 80 characters long per record. There are no field labe...

hello,i designed an application containing Crystal Report in VB.NET and viewed the application and Report successfully on my system. But when i try to execute the same packaged application on a different system, i get an error message saying that a dll cannot be found or invalid code.Please help me...

Hello,I am trying to extract just a little part out of a memo field and display that part on the report. I am trying to use the substring function to do that, but I keep getting an error stating "A string array is required here".Here's what I'm trying to do in a formula:Filter ({NoteSecti...

Will Crystal Reports have a page header that will hide if a condition is not met or viceaversa? If so how is this done?<br/>Example: If Company_Name = 'xyz' then unhide page header A<br/>thanks in advance<br/>cg

i have my db at mysql, but i need to link it to crystal report to make a report for my company.<br/>how can i do it?<br/>thanks

i have two running total fields, Total Keyed and Total NWN.<br/>i have to sum these two fields.<br/>what shall i do?<br/>thanks

Hai,I had developed on project entitld as resume handler in vb.net 2005 and ms access 2000.In this we are storing the candidate details who are all applying for job in our company.It will entire details of the candidate.I want to add another advantage in my project.If I select a candidate name a Rep...

We are migrating all our crystal reports from Crystal Enterpise 9 to BO X1.I used the BOXI Import wisard to import all the reports from CE 9 to the new BOX1 Server Successfully.But currently the reports are pointing to a old database, whereas we need them to be set located to a new database. Is the...

Im using a report with a sub report to show the result on a web survey. The main report is used for making the selection (for instance: show only people that answers A on Q1 and C on Q2 ), and the sub-report should present the data. I would like the main report to generate an array of people and sen...

i have two Running Total Fields<br/>Total NWN and Total Keyed<br/>how can i add these two Running Total Fields?<br/>and how can i connect mysql to crystal report?<br/>thanks

Hi, i have a problem with report.papersize when printing in crystal report.at first i'm using crpaperfolio value for used with printer that has default folio setting.. but yesterday the printer was replaced by printer which don't have default folio setting..so when i print the result is no...

Hi!Im creating a report with a manual running total in a main report. As a condition to the running total, Im having a sub-report in the details section bringing a shared boolean variable back to the main report.My problem is that I dont want the sub report to be visible. Have tried suppress it, but...

Hello.I have some problem in cross tab,I'm creating cross tab like as follow.On Row displaying s_Questions On Column displaying d_DateOn Summarized field dispaying s_ScoreOfQuestionOn perticular date client will ask 10 question to it's user and give score betwen 1 to 10 for every question....

hello <br/>please could anyone help me to insert an image into crystal report if I saved the link in the database . I tried to change the type to "ole object" it works, but i don't have to change the type in my project.

Hi All,I am new here on this forum , i have a database of student registered for 2007-2008 with field of student names and term and i need a formula to show me distinct count of students registered for the following 1)Students registred for both fall and spring2)Students registered only fall not fo...

I would like to know if it's possible to create a report that would react to user events. I would like to allow the user to click on a any value and produce a new report that would explain how this value was calculated. <br/>Thanks<br/>Rufen

Hi, Wonder if anyone can help me:I have a report that has a crosstab which populates a large number of columns across the page. This works fine and can be exported to excel etc.The report also contains a sub report which too contains a crosstab. However the page size is restricted to the size of the...

I need to change the following string formula to be Right Justified it is currently print out as Left. Can anyone help me change it.//firstpay e-name 40 digitsStringVar T1;StringVar T2;StringVar ExStr;NumberVar L;NumberVar X;T1:=' ';X:=Length(T1);Ex...

I have an application that has been working in a Production environment for a few years now. I need to make some tweaks to it and I'm at the testing phase and all of a sudden, I'm getting a Path/File Access Error with the filename in question being one of those vb*.tmp files (it's a...

Hi,I'm new to Crystal. I sure hope someone will be able to assist me in this fairly easy problem. I have sets of data that returns values for each of the 4 quadrants. An example:Quadrant A: 7Quadrant B: 20Quadrant C: 8Quadrant D: 2The above is for Group 1. I also have a Group 2 with its own dat...

Hi to all, I am using the Custom-Multi column report which is selecting from theReport Gallery. Inside the detail section-printing section, there are only 2 options. 1. Across then down 2. Down then across. But my requirement is some thing different fr...

Hi, Still working on this **** report, its getting to be beyond a joke now. Its format just changed again (you all know the score).The first problem i want to deal with is to get a count of the short stops we are having.I have set up a running total that is like soField to summarize = tblDowntime.DT...

Okay, I am pretty new at this, so this may be obvious, but here's what I want to do.I have an Access database that can be used to reserve resources. The user inputs a date range and then checks off what they want to reserve. It looks like this:StartDate .............EndDate .........Laptop......

Hi All, I have a main report with 3 subreports in detail a,detail b and detail c sections.I want to supress page footer on all pages except on pages where subreports are ending. for example, if subreportA has 50 records so on page 1, report footer of main report should be supressed but on on next pa...

Hi,I hope somebody can help me with this issue as it is driving me crazy.I am migrating Crystal 8.5 reports that currently run in an ASP IIS5 Win2K Server web application to a new server running ASP IIS6 Win2003 Server. When viewing a report through the web app the Crystal viewer is displayed but n...

I cannot figure this one out. I have a SQL Server Database. I have 4 tables I want data from. CustomerInvoiceShipperCustomer Address.Customer is keyed by CustomerID.CustomerID is a foreign key in Customer Address, and InvoiceInvoice is keyed by InvoiceIDInvoiceID is a foreign key in Shipper. Shi...

Hi, Hoping to get report passed off today but one problem i have with the re format of the report requested.I have been asked to put product code in the Pahe Header, But i need the page to change when this changes.IE: We have prod Code Wel008-110KSI and it runs 4 coils per shift on average, but on t...

Working with parameters and prompting for user input, is there any way in XI to automatically prompt for input *every* time the report is opened and not having to refresh?<br/>Appreciate the help..thanks in advance..

Crystal version ( crystal build in VB. Net 2005)Hi, can anyone help me here..My problem for almost one month..I have two tables in Access database...1.) FinalCustRSOFields:RSONO PK AutnumberCustomer textZeroStock textNewProduct textProjectForecast textWithMotherPO textOthers textRequestedBy textNote...

I have 2 tables and i combined it in the query (MS Access) <br/>during displaying report it separates related Data by ID but it doesn't work with my code.<br/>any one idea on how to do it please..?<br/>Interested to post code if needed..