Is there a way to get versioning information from a Crystal Report for a particuliar application? Like in visual basic you can use "Application.ProductVersion" for a application and you can set a version number in the Assembly. Can something similiar be done for a crystal report for a pariculiar app...

Hello -I wanted to know if we can have a fully dynamic sub-reports in CR. I will explain my scenario below..please let me know how i should proceed. I have two sub-reports which uses two different stored procedures to get the required data. Both the stored procedures will take three parameters each....

Hi,I'm having an application initially designed using Crystal Reports 8.5, which uses CRPE32.dll and P2SORA7.dll. The application (written in C++) is bundles as a dll, which calls on CRPE32.dll. Using version 8.5 this worked fine, but upgrading the dll:s to version 10 (including changing the da...

Hi all,I have a very simple question on Crystal Reports. Is it possible to insert lines (horizontal and vertical) in between the datas in DETAIL section of Crystal report. If yes, how can I do this? If no, what is the possibility to make complete table using Crys. Rep.Thanks...

Hi Everybody<br/>How can I get digit into words in crystal report...<br/>for examble<br/>"102" in to<br/>"hundred and two"<br/>By Rajesh

Hi all, Happy New yrs!I have a problem. I am trying to make a graph in Crystal 8.5. The values I want to use to populate this graph are from formulas. When I am in the graph expert thing, those formulas dont show up... and i have no clue why...Is there something special I have to do to accomplish th...

hi how to convert crystal 8.5 to crytal 10 ver <br/>thanks

hi All, i am vb programmer.i am using crystal reports with vb my problem is that i want to create dynamic reports. let me explain.i am attaching my crystal report with vb and looking through crviewer.and then i perform merge pdf.but this thing is static .i want to change the position of my sub...

I have CR 8.5 Developer Edition installed in my PC. I'm using CRAXDRT.dll specifically in creating my report at runtime. The only thing that gets me stuck is setdatasource parameter. it gives an error, "invalid index", with error code -2147352565. I'm limited on using VB.NET 2005 and Cryst...

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..

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...

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..

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...

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,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...

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...

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, 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...

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,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...

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...

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...

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 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 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...

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.

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....

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...

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...

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

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...

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...

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...

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

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

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

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...

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...

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...

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) ?...

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 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....

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 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...

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 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,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 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,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 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(...