Search results for query: *

I have the following SQL: select decode(grouping(r.status_desc)+grouping(r.status_code)+grouping(r.AUDIT_DEPT_ID),0, r.status_CODE, 'Total') status_code, decode(grouping(r.status_code)+grouping(r.STATUS_DESC)+grouping(r.AUDIT_DEPT_ID),0, r.AUDIT_DEPT_ID, NULL) AUDIT_DEPT_ID...

I have a grid with populated summary data which depends on drop down selection by departments. One column in this grid is hyperlink which send three different parameters to detail screen. I am using URL on the HTML side: NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.STATUS_DESC"...

I have a grid with populated summary data which depends on drop down selection by departments. One column in this grid is hyperlink which send three different parameters to detail screen. I am using URL on the HTML side: NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.STATUS_DESC"...

I have the following SQL: select decode(grouping(r.status_desc)+grouping(r.status_code)+grouping(r.AUDIT_DEPT_ID),0, r.status_CODE, 'Total') status_code, decode(grouping(r.status_code)+grouping(r.STATUS_DESC)+grouping(r.AUDIT_DEPT_ID),0, r.AUDIT_DEPT_ID, NULL) AUDIT_DEPT_ID...

I am using Crystal 9.0, Oracle DB. I need printable version of the report and I send it to .pdf. I have a field "Comments" which passing ok but.. If in this comments user write anything using double qouts it displays like &quot User Comment &quot instead of "User Comment". How can I fix it??

I send report to .pdf and instead of showing some comments using "Some comments" I get &quot;Some comments &quot; how can I fix it?? thank you

I have a crosstab which show number of projects and amount for different departments by Project Status. Looks like: Dep1 Dep2 dep3 Open $5000 $ 20 $0.00 7 2 0 On Hold $ 800 $0 $500 8 0 4..etc...

I have a report done on VB where user select number of different options of information he wants to see and he gets a report on HTML. But if he wants to print it he has on that page link to Printer friendly version(which is in Crystal). I need to be able to send this to Crystal as where clause...

I have SQL statement in Command which looks like Select a,b,c,d from atable where a = "parameter1" and b = "parameter2" and c = "parameter3" Is it possible to pass it to Crystal as one 'where clause' instead of passing three different parameters??

I use Crystal 9.0 and Oracle DB. Report works OK in Crystal but when I add to application I get a message: Unable to connect: incorrect log on parameters. I have a number of reports work perfectly with the same code and only this one give a problem. My code: Dim myParamValues As New...

I use Crystal 9.0, Oracle DB. When I need to send parameters from web page to Crystal I am using following code: Session("Val1") = dtBeginDate Session("Val2") = dtEndDate Response.Redirect("fp_monthly_pdf.aspx") I am looking for other possibilities to send parameters (not...

I am using Crystal 9.0 and Oracle DB. I have a report with information about each project# sitting in GH1a, GH1b, Details sections (a,b,c,d,e) and each sections of GF1a, GF1b, GF1c, GF1d, GF1e contain subreports with different info about this record. I have "Keep together" turn on everywhere in...

I am using Crystal 9.0 and Oracle DB. I have a report with information about each project# sitting in GH1a, GH1b, Details sections (a,b,c,d,e) and each sections of GF1a, GF1b, GF1c, GF1d, GF1e contain subreports with different info about this record. I have "Keep together" turn on everywhere in...

I have a report grouped by Project# where information about each project# sitting in GH1, Details section (a,b,c,d,e) and each sections of GF1a, GF1b, GF1c, GF1d, GF1e contain subreports with different info about this record. Some of records I am getting the following way: GH1 and Details on...

I am using Crystal 9.0, Oracle DB. I have a report grouped by month and I have a field BALANCE_DUE. I need to count how many records per month became with zero balance. I tried if {PACS_PROJECT_FINANCIAL.BALANCE_DUE} = 0 then 1 else 0 put this formula in detail and then count and put in GH...

I am using Crystal 9.0, Oracle DB. I have interesting problem. When I just drop a field (number) from db it normally show 0 when it is no amount but if I take this field and create a formula: if {FACTS_REPORTS_MAILOUT.RECEIPT_ADJ_TYPE} = "R" then {FACTS_REPORTS_MAILOUT.AMOUNT} and drop it on...

I have a report with three groups: Group1 by Project type Group2 by Open date Group3 by project Number. All data in GH3a and GH3b in GH1 I have Project Type name. Sometimes I have same Project type name I receive three or four times (because of grouped by open date), sometimes only once. I need...

I have string parameter ClosedDate (for example : user enter 07/30/2004) and I need it as a string(not date). Is it possible to put corresponding month name on the title of the report? If user select 7/30/2004 then on the title: for July, 2004...

I am doing a report in Crystal 9.0 against store proc in Oracle. I have a parameter BEGINDATE. When it is null it works ok, but when I try to put some date (7/1/2004 for example) it give me message:"Please enter a DateTime value. For example 'M/D/YYYY'". And this is exactly what I am doing. Can...

I need to combine multiple records into a single row in the report. For example: I want it to show like: Project# Provider# Date1, Date2, Date3 1111 2222 1/1/01 2/2/02 1/2/02 This is actually three different records (same project#, same Provider but each date - different...