Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: veronic
  • Content: Threads
  • Order by date
  1. veronic

    decode, grouping in sql question

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

    Need to send drop down box value/text to another page

    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"...
  3. veronic

    Passing drop down text/value to another page.

    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"...
  4. veronic

    grouping, rollup SQL question

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

    Problem with double quotes

    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??
  6. veronic

    Double quotations being improperly displayed

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

    Drill Down in CrossTab???

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

    Send SQL from web page to Crystal 9.0

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

    How to pass SQL where clause to report

    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??
  10. veronic

    Unable to connect: incorrect log on 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...
  11. veronic

    Parameters from VB to Crystal 9.0

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

    Cannot keep one record on one page

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

    Cannot keep last record together

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

    Cannot keep GH and GF on one page

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

    Count closed cases per month

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

    Number field show null instead of 0

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

    Formatting problems

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

    How to make Month Name out of String parameter

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

    Error: &quot;Please enter a DateTime value&quot;?

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

    Multiple records - single row

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

Part and Inventory Search

Back
Top