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 Chriss Miller 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: *

  1. ikirkland

    Altering colour of title in Graph (Crystal 9)

    Unfortunately, this doesnt work as it doesnt allow you to set the colour of the title, only the font size etc....
  2. ikirkland

    Altering colour of title in Graph (Crystal 9)

    Didn't want to do it that way to be honest, makes it harder to implement when you have more than subreport with graphs on and you wish to not show the graph if no records exist. If you did it that way then it would show the title. Just thought there may be a way to override the colour scheme...
  3. ikirkland

    Altering colour of title in Graph (Crystal 9)

    Hi, does anyone know how to change the colour of the title in a graph. I am using a basic line graph and I dont want my title to be in red, wish it to be in black.... Cheers, Ian
  4. ikirkland

    rounding problem when grouping

    I have a series of integer values that come in from an XML file. If I total these numbers up in excel they are different than they are in Crystal.NET. It seems to be rounding on the groups, I dont understand why. Does anyone know how to stop it rounding at unit level?
  5. ikirkland

    Any way that you can script off data from a table into insert tsql?

    seems to be in another language, any idea of the exact link???? - cant speak it unfortunately :(
  6. ikirkland

    Any way that you can script off data from a table into insert tsql?

    no, problem.... Very simple example: ClassificationID ClassificationCode ClassificationName ------------------------------------------------------------ 1 A_Code A_Name What I was looking to do was somehow create a script that would take the values in a...
  7. ikirkland

    Any way that you can script off data from a table into insert tsql?

    Hi, was wondering if you can write using t-sql or there are any tools to help get data out of a table into a file of insert statements. Any help would be greatly appreciated. Regards, Ian....
  8. ikirkland

    .NET DLL problem

    Hi, I have created a class type solution and included a crystal report into it. I was wondering if there is any way to reference it when creating a reportdocument without having to say where it is located, so you could compile the report into the dll.....
  9. ikirkland

    A exception handling question

    Any way that you can (rather than having the code twice) do this: catch e as overflowexception 'some code goes here catch e as argumentexception in some way like this: catch e as overflowexception, agumentexception 'some code goes here
  10. ikirkland

    How to ignore collation setttings

    Is there any way to ignore collation settings when you are running a query over 2 databases?? i.e. select * from PTS_SRV.PTS_staging.dbo.securityrg where FirstExternalSecurityCode in ( select assetSEDOLCode from ODSSRV.ODS.dbo.asset ) Produces the error: Server: Msg 446, Level 16, State 9...
  11. ikirkland

    can you combine 2 pdfs using the ReportDocument object?

    I have a bit of code that exports 1 pdf, but was wondering if I could add another crystal report into a pdf file that I am currently creating. Or is there a better way to do it? Your help would be appreciated... Dim crReportDocument As New ReportDocument() Dim crExportOptions...
  12. ikirkland

    restoration of masterdb logins on another sqlserver

    Is there any way to just bring across the logins from one master database on a server to another master database on another server. I am trying to implement a disaster recovery scenario and am having problems restoring to another name. Is the only way that it can be done to script off the...
  13. ikirkland

    Cannot resolve collation conflict for equal to operation

    I have a 6.5 database and a 2000 with a default installation. All I want to do is ignore the collation settings whilst doing a join between the 2 servers. what code do I need to place after (6.5 db) (2000 db) b.Name1 != a.Name1 -- presume it goes here any help would be appreciated....
  14. ikirkland

    strange ordering in enterprise manager

    I have a table with an identity, which is the primary key clustered and all of a sudden a select * (return all rows option) is bringing the data back not in an incremental fashion. Do I need to run any repair commands on the database, or reindex stuff??? Or even something else??
  15. ikirkland

    Showing page headers on every page of a subreport

    I was wondering how you get the page header to be shown in the main report if the subreport has more than 2 pages. It prints off the page header on the first page, but does not show it on the second page. I know that there will be a nifty solution to this but i am new to crystal. thanks for...
  16. ikirkland

    Is there a way to create a master report

    Is there any way to create a master report that contains about 5 other reports that are subreports? The reason I want to do this is that I have about 80 conbinations of a series of crystal reports that I want to combine into 1 report that can be displayed in a web browser. It would be...

Part and Inventory Search

Back
Top