CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Page 38 of 39 FirstFirst ... 283536373839 LastLast
Results 556 to 570 of 580

Thread: Crystal Report

  1. #556
    Join Date
    Jul 2000
    Location
    Milano, Italy
    Posts
    7,726

    a Crystal Report Forum...

    Why don't they open a Crystal Report Forum?

    It would be really very useful!!
    sounds good. Let me suggest it to Brad
    ...at present time, using mainly Net 4.0, Vs 2010



    Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
    all the other wonderful people who made and make Codeguru a great place.
    Come back soon, you Gurus.

  2. #557
    Join Date
    Nov 2003
    Posts
    8

    Unhappy HOPE SOMEONE ONLINE CAN HELP ME NOW!!!

    HELLO, IF ANYBODY READ THIS MESSAGE NOW, WOUL DYOU PLEASE ANSWER ME QUICKLY...

    HOW TO PASS A SUMMARY FIELD IN SUBREPORT TO MAIN REPORT ? I NEED TO CALCULATE THE GRAND TOTAL OF SUMMARIZE FIELD IN SUB REPORT, AND SHOW IT TO MAIN REPORT!

    PLEASE NOTE THAT THE RECORD HAVE EACH GROUP. FIRST I WANT TO TOTAL THE SUM OF DETAIL IN SUB REPORT OF EACH GROUP, AFTER THAT THE GRAND TOTAL....

    THE SUM OF EACH GROUP AND THE GRAND TOTAL MUST BE ABLE TO BE VIEWED ON MAIN REPORT.....

    IT'S EASY TO LINK FROM MAIN REPORT TO SUB REPORT, BUT TO THE OPPOSITE....HOW TO PASS IT FROM SUB REPORT TO MAIN REPORT, IN CRYSTAL, NOT FROM VB... THANKS IN ADVANCE

  3. #558
    Join Date
    Mar 2004
    Posts
    3

    crystal report w/ mas90 and access database

    i am having a problem with a crystal report that at one point would run and now is giving me an error
    odbc error:canada][pvx odbc driver][fileio] table is not accesible
    after you hit ok on that
    the second error is
    error detected by database dll
    what i am trying to run is a crystal report from a mas90 database with an access table. if anyone can shed some light it would be greatly appreciated.
    thanks ralph

  4. #559
    Join Date
    Mar 2004
    Posts
    1

    Lightbulb Crosstab Report

    Hi All,

    This is my 1st time on this forum page.
    I really hope K.Babu or somebody could help me with crosstab reports.

    I've completed creating my crosstab reports but the only problem is how do i create column labels for my crosstab report.
    My report looks like this

    Job1 Job2 Job3 Total
    1 Anne 8 4 2 14
    240.00 120.00 60.00 420.00
    2 Joe 2 2 2 6
    60.00 60.00 60.00 180.00

    How do i create a label for 1 & Anne as "Emp No" & "Name".
    The total field is a summarized field so the word total is automatically generated, so how do i change it to "Total Hr & Total S$"

    I'm really looking forward to suggestion and help from anybody here.
    Thanks in advance.

  5. #560
    Join Date
    Feb 2004
    Posts
    30

    Talking awesome

    this single topic here is 1000 times better than the CrystalDecisions *support* forum .

  6. #561
    Join Date
    Mar 2004
    Posts
    3

    Post Deployment

    Hi,

    After deploying a VB.NET windows project with a CrystalReportViewer on the client's machine I'm getting the following error:

    "Cannot Find keycodev2.dll, or invalid keycode"

    Any help will be appreciated,

    thanks.
    mzainal

  7. #562
    Join Date
    Feb 2004
    Posts
    30

    Re: Deployment

    Originally posted by mzainal
    Hi,

    After deploying a VB.NET windows project with a CrystalReportViewer on the client's machine I'm getting the following error:

    "Cannot Find keycodev2.dll, or invalid keycode"

    Any help will be appreciated,

    thanks.
    mzainal
    take a look at this solution. I have the same problem as you, but it's your lucky day, I spend half a day to get it working after hunting for solution in the crystaldecisions support site.

    http://support.businessobjects.com/l...s/c2010681.asp

  8. #563
    Join Date
    Mar 2004
    Posts
    2

    New line

    Hi,
    I've a stupid question:
    How insert to string formula a NEW LINE?

    I tested Basic's

    "something" & vbCrLf & "something"

    C's backslash+n and I loooooooking foooor... and nothing...

    Specification:
    I've UnboundString field, where i need insert to EditFormula this:

    If {myTable.col1}="" then
    {myTable.col2}
    else
    {myTable.col2} + (damned new line) + {myTable.col1}
    ...

    Thanks
    Dusan

  9. #564
    Join Date
    Jul 2003
    Posts
    28

    Exporting Text files

    Hi,
    Is there any way to export .rpt files as text files. I am using crystal reports 9.0 and .Net framework..
    I want to export them dynamically in the code.
    I could able to export to pdf,doc and html..But not to text.

    Thanks,
    Ramesh

  10. #565
    Join Date
    Jul 2003
    Location
    Florida
    Posts
    651
    ramesh_cr:

    You should post your questions in the main Crystal Reports forum instead of in this huge thread (the forum was created because of it). It's easier for someone to find your question and help you if they don't have to look through 500+ posts. It also makes it easier to find the answer to your question before you post.

    That said, here's my best shot at an answer for you:

    In CR 8.5, each export type has it's own dll that needs to be deployed with the program. From my experience, just putting that dll in the correct location will populate the Export box on the report. In order to see the export box on the report, use the following line in your VB app:

    crReport.PrintWindowOptions.HasExportButton = True

    I'm not sure if CR 9 is the same, but it's a start. CR 8.5 includes a file called runtime.hlp that lists all the files you need to deploy your app. You can also search on Crystals website (http://support.businessobjects.com/search/advsearch.asp) or on another search engine such as www.google.com.

    Hope that helps!
    I'd rather be wakeboarding...

  11. #566
    Join Date
    Mar 2004
    Posts
    3

    Unhappy Multiple tables and databases.... 1 group

    Using multiple tables and 1 group
    Hi everyone.....

    I am using Crystal reports embedded in VS .NET but I am actually having problems with my principal report

    I´ve 2 DB, one DB is MySQL and the another is Access.

    I have a table in my access database called "TblSpot", this table contains spot info (its columns are spotName, productName,ClientName, spotURL, spotVersion,spotDurationn) actually this table contains only 17 data rows.

    I have a table in MySQL database called "TblSpotReproduction", it contains spot reproduction info (its columns are spotName. playerName, reproductionTime) also it has 150000 data rows.

    I tried to make a report grouped by SpotName with only TblSpotReproduction:

    SpotName <------ Init Group Header
    ---------------------------------------------
    playerName reproduction Time
    ---------------------------------------------------
    <---------End Group Header

    ALL DATA
    ..
    .
    .
    .
    .

    ----------------------------
    Group Foot

    Next group etc etc etc


    This report works perfectly. It shows the solution delayed but it works perfectly.

    But my client ask me to make a better report that include spot information. For that i´d to include the Access database. My new report must be like this:

    SpotName <------ Init Group Header
    spotURL
    spotVersion
    Client
    Product
    spotDuration
    ---------------------------------------------
    playerName reproduction Time
    ---------------------------------------------------
    <---------End Group Header

    ALL DATA
    ..
    .
    .
    .
    .

    ----------------------------
    Group Foot

    Next group etc etc etc

    My problem is that this reports never open, i think that the combination of 2 databases causes CR crash, maybe the combination between 150000 rows with 17 rows make a impossible JOIN. Friends told me I have to use sub-reports but i have no idea how to use them on the fly.

    P.D. Sorry for my really bad english.


    Thanks for advance-----

    Keylen

  12. #567
    Join Date
    Mar 2004
    Posts
    3

    Talking Me again

    Thanks i got the solution, i change the link in Visual Link Assistant

    Ba bye people

  13. #568
    Join Date
    Mar 2004
    Posts
    2

    Re: New line

    Stupid question, stupid answer... :-)

    chr(10), obviously...

  14. #569
    Join Date
    Mar 2004
    Posts
    3
    Hi Babu,

    i have a question about a runtime error that appears with the activeXviewer when i want to run a report through the browser.

    My Report has a subreport on it. The Report has an SQL-Stament as a datasource. The statement has a paremater-value in its where clause. Before running the report i set the value of the parameter-field depending on the selections i made. These selection are like filters.

    Now when i make some specific combinations of selections the following error occurs:

    Error occured on Server. -2147482963:
    Error in File c:\winnt\temp\{2824C0F2-A23B-4BA7-9239-D75C53D838A}.rpt
    The request could not be submitted for background processing.

    With some other combinations of selection the report works fine. I tested the database and the complet sql-statements but they were all ok. I have no idea anymore how i can solve the problem. Have you got an idea?

  15. #570
    Join Date
    Mar 2004
    Posts
    4

    Crystal Report Password in Database

    hi babu

    pls pls help me......

    where to write the code lines given by you to run crystal reports using a password protected database.

    i am using a database which is password protected. i am creating a DSN for Crystal Reports. If i do not give password while creating DSN, it asks for it while running the reports.

    can u help me in any way.... waiting anxiously for ur reply
    bye

Page 38 of 39 FirstFirst ... 283536373839 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured