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!

  • Congratulations dencom 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. jizzycrystal

    Parameters how do I allow a user to select one out of two parameters?

    I have set up two parameters and want to allow the user to select a value from either one or the other parameter but it is insisting that both parameters be selected. I have entered Par1 "OR" Par2 in the report selection but it is ignoring the "or" bit Thanks
  2. jizzycrystal

    Crystal BI launch pad can't see the menu bar (home, documents tab) properly

    Crystal BI launch pad can't see the menu bar (home, documents tab) properly I'm using internet explorer 11 Also when I open a document the name isn't visible on that menu bar. I have to scroll down. I can't widen by dragging either.
  3. jizzycrystal

    Using shared variable between a main report from an sql database and a sub report from an excel data

    Sub report: I created a formula called YTDFTE Whileprintingrecords; shared numbervar ytdxxx := {@YTDxxx} I then dragged into my sub report Then in main report I created a formula called TOTYTDFTE Whileprintingrecords; shared numbervar ytdxxx;ytdxxx I then dragged into main report. RESULT...
  4. jizzycrystal

    Main reports & sub reports

    Hi is it possible to add or subtract or create a formulae between a field from the main report and a field from the sub report? Thanks Jizzy
  5. jizzycrystal

    Error A summary has been specified on a non recurring field

    Hi I'm trying to add two formulaes: {@Prior YTD amt} + {@PriorYTDkfBUD} @Prior YTD amt: IF {nltran15zeverydb.trans_period} >= "01" and {nltran15zeverydb.nlyear} = "14" THEN {nltran15zeverydb.journal_amount} else IF {nltran15zeverydb.trans_period} >= "02" and {nltran15zeverydb.nlyear} =...
  6. jizzycrystal

    Suppressing Duplicate records in Crystal

    Hi I have a consolidated report that consolidates based on a master nominal code and pulls all records from various databases based on parameters defined. (Sage) It works great except for one nominal account. For this nominal it is duplicating all the records from all databases. I have tried...
  7. jizzycrystal

    Report won't open in BI launch pad CR 2011

    We have now moved to Crystal Reports 2011 (as the browser for CR XI won't work with windows server 2008) I installed CR Server 2011 on the server machine. I installed CR 2011 on my local machine. I created a new report in CR 2011 When I publish (now called "report upload wizard") a report to the...
  8. jizzycrystal

    Crystal Reports viewer/browser using windows server 2008

    We recently upgarded to windows server 2008. Now when a user opens the browser and clicks on a report they are asked for a user ID & password to the database which was never the case with windows server 2003. We have tried setting the ODBC configuration to both window authentication & then...
  9. jizzycrystal

    Will Crystal Reports XI work on windows server 2008?

    We have moved our Sage accounting package database to a windows 2008 server (used to be on windows 2003 server. Will Crystal Reports XI work on windows server 2008? Also will the Crystal viewer (url....enterprise115/infoview) work with windows server 2008?
  10. jizzycrystal

    Syntax for entering a parameter (that has a range) in a formula

    I am trying to get the total amount for all three values in my parameter range. My parameter range is period say 08 (start of range) to say period 10 (end of range). My parameters are fields from a table {nltran11.trans_period} My attempted formula is If {?period} = (['08' '09’ '10']) then...
  11. jizzycrystal

    Connection to database fails in crystal viewer

    My connection to the database works when I am developing the reports but if I try to view it in Crystal Viewer (url) it doesn't connect
  12. jizzycrystal

    How can I reduce the number of pages that my report prints on?

    I have a 100 page report (currently in landscape format) Is there any way to reduce the number of pages...perhaps by changing to portrait??? but need all rows and columns to fit ok.
  13. jizzycrystal

    How do I print all group levels including the detail in one go?

    Right now I can only print each drill down level at a time. Is there any way to print everything in one print job?
  14. jizzycrystal

    Instance Manager doesn't work

    Hi Instance manager doesn't track my users as they view on demand reports. Any ideas how I can track users viewing or logging on to crystal reports? Thanks
  15. jizzycrystal

    How do I get the Encyclopedia on the Header panel toolbar?

    How do I get the Encyclopedia on the Header panel toolbar?
  16. jizzycrystal

    Does anyone know if it is possible to have the navigation panel in Inf

    Does anyone know if it is possible to have the navigation panel in Infoview hiden when I login?
  17. jizzycrystal

    I don't have Encyclopedia on the Header panel toolbar

    How do I get the Encyclopedia on the Header panel toolbar?
  18. jizzycrystal

    How do I hide navigation panel in Infoview?

    Does anyone know if it is possible to have the navigation panel in Infoview hiden when I login?
  19. jizzycrystal

    Combining two reports from different databases

    Hi Is there any way to add two reports together? They have the same format but are from two different data sources. Can I use sub reports to do this? Thanks
  20. jizzycrystal

    How do I combine a SUM formula with an IF formula?

    I want to say: sum (if {@formula1} = 10 then {formula2})+(if{formula3}=12 then {formula5}) my syntax must be wrong...how do I lay it out? Thanks

Part and Inventory Search

Back
Top