Search results for query: *

Hi all, Thanks for your patience. This might be a trivial question but I seem to be stuck on it, partly because I'm new to Access. I have this form in which I have a macro which updates another table based on some selection on this form. This macro is triggered on after update event. I get...

I have this strange problem. This report (SQL Query Based) worked perfectly fine with version 7.0.702. When I upgrade the report and catalog to 7.1.116.11, the report gives strange errors in prompt variables. Could someone please help. Attached is the exact SQL ******** select T2.SR_NO_TXT...

Hi, First of all, thanks for your time. I have a situation where in I need to sort the columns based on the filter selection. If choice "A" is made then I want the detail records sorted by Column #3, else by Column #4. I have tried looking for anyway to specify dynamic sort order...

I have the following situation. I have two prompts 1. Emp_Name - Pick Employee Name This list comes from picklist report 2. Emp_Type - Pick the Employee Type Choice are "Creater" or "Owner". It is typed in. My data is like the following Record Number...

Hi All, I am new to Impromptu and here is what I need to do. Before running a report, run an Oracle Stored Proc (which does not require any input or output parameters). I am trying to do this as a macro but do not know how do I go about doing this. I have read the threads which explain how...

I have a report package that I am building. This includes several reports which need to be printed one after another. Is there any easy way to create sub-reports which following one after another. I can always create these reports serparately but I would like all of these to be together in one...

Hi, I am evaluating the reporting software. I have only used Crystal Reports and I have no idea how Cognos Imporomptu works. We normally use J2EE environment for developing software and would use the reporting tool to generate reports on the web. Does someone have any comparisons available...

Hi All, I have a situation where I need to accept about 10 parameteters. They are not mandatory, but if they are entered, I need to filter the records based on each parameter. Example. Param 1 : Compound Param 2 : Protocol Param 3 : Site I am currently doing it in Record Selection Formula...

I have a situation where I need to accept about 10 parameteters. They are not mandatory, but if they are entered, I need to filter the records based on each parameter. Example. Param 1 : Compound Param 2 : Protocol Param 3 : Site I am currently doing it in Record Selection Formula Editor. I...

I am getting an error when using an Oracle View which has a date column. ORA-01858 non-numeric value was found. This is really strange because the same query works in SQL*Plus and every other tool except Crystal. I am using CR 8.5 with Oracle 8.1.7.4 I found the following link on Crystal...

I have a strange problem with Crystal 8.5. I have few forms which are originally from Word. I have created a text box and pasted the word document inside the box. I am able to see it correctly in Cryustal Designer, able to edit the text character by character. However the users complain that the...

I want to create a report which is primarily unformatted columns from database (for the purpose of exporting it to Excel). I know that you can export report to excel but I have too many columns to fit on a page. I do not want to be limited by what is displayed on the screen. How can I tell...

I would like to print a concatenated "First Name" and "Last Name" with a space between. How can I achieve this? Thanks, Ashish

I have a situation. One of the views I am accessing only gets populated if I execute a stored procedure in the same session. How do I execute this in Crystal? Thanks for your time.

I am trying to print a report from a table which has the following columns i_case_id dt_date s_detail_1 s_detail_2 I want to print i_case_id once for the case (there could be multiple rows for the same case). The output should look like case ID Case Date detail1...

I am using cr 8.5. I have a requirement where I need to print multiple forms based on the number of records selected for the input criteria. I think I need to write my query in the main Report and then call the subreport to print one form per record but I do not know how do I go about doing...

Thanks for reading the question. I am having a problem trying to use dynamic conditions. I need to check if a certain field is NULL, if it is then I have use a different record selection. Crystal is saying that my syntax is incorrect. Here is what I am trying to do. if IsNull({?i_Compund_ID})...