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 Mike Lewis 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. BeeBear2

    Evaluating data when a field is equal to a value then insert effective date of value

    Looks like the issue is you want your result to be either a Date Format if the first field = 130, or a Text format if its not. You need both result options to be the same type of field. Wrapping the date in a 'totext' makes them both text, but then you want to be able to format the result...
  2. BeeBear2

    Can you split a dynamic Cascading parameter between the main report and a sub report?

    Cancel this post - it was logged in error. half way through I figured out the answer
  3. BeeBear2

    Can you split a dynamic Cascading parameter between the main report and a sub report?

    Hi, I have a client who wants a drill-down report with subreports, with the main report selecting data for one, many or all 'Regions' within the State (of which there are 9), then when they click on one of the Regions once the report has generated (Report groups
  4. BeeBear2

    Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??

    Problem solved!! After much fiddling around with adding and removing single quotes and brackets and rearranging things - I had too many brackets around the entire result: Once I Removed the brackets around the param value after the IN, it worked Where PaymentDate BETWEEN {? StartDate} and...
  5. BeeBear2

    Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??

    Cascading parameter is not a problem lbass - the only issue is my WHERE clause not working for a multi-value selection on a string parameter.
  6. BeeBear2

    Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??

    Just to add another comment - I researched the error message at the end of my last post, and found that it may be to do with the '= All' section because the command didnt like it when I added more than one param value while using an '=' The fix on another page said to do this, but that doesn't...
  7. BeeBear2

    Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??

    Hi LB - Unfortunately for a dynamic cascading parameter you have to build the parameter from a table to get the cascading values correct. I have managed to do this, my issue is purely with the code in the Command not working in the WHERE clause. Hi Dell. I have seen your blog about this and...
  8. BeeBear2

    Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??

    Thanks for your help everyone. Ive got it working for a single parameter, but not for the multivalue parameter. What I have done is: 1. within Crystal Database Expert I have added the summary table RegionPostcodeMapping as a standalone table. Not linked to the command 2. I then built a...
  9. BeeBear2

    Passing Multi-Value Parameter result to Crystal Command Sql - Can it be done??

    Hi, I know that you can't create a multi value paramter in the Crystal Command, but is there a way where you can pass the result of a parameter selection EG create those parameters in Crystal not in Command and create a result formula similar to Join{?param}',') to create a string to use in an...
  10. BeeBear2

    Barcode Fonts missing in Crystal install

    Hi, So we are using Crystal 2016, and I need to write a report using Barcode 128B font. Only issue is, the Barcode fonts for display are not avaiable to select in the product. I used the Function BarcodeC128B which worked fine, but I still need to display the font as: Font...
  11. BeeBear2

    Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

    Darn! Thats what I thought. Ah well, will have to manage as it is because I dont think adding a second copy of the SR will work due to the excessive load. Thanks for your response.
  12. BeeBear2

    Passing Value from SubReport to Main Reports HEADER (eg above Subreport). Can this be done???

    Hi, So I am trying to work out if there is a way to pass a subreport value to the main report HEADER while the subreport is in the main report FOOTER. I know in theory you cant pass a value to a spot in the main report above the subreport, but I was hoping there was wealth of knowledge on here...
  13. BeeBear2

    Hiding a parameter in Crystal, while still populating it from the User ID in 3rd Party front end.

    Hi, Ok, this is a bit of a curly question. We're working on a project to convert some reports from an old system to crystal Reports (using version 2016). The reports will sit in a Crystal Server (2013), and will be called by a 3rd party front end selecting the report through a URL to the...
  14. BeeBear2

    Help Converting Datetime field in Oracle/Sql Stored Proc for passing a Date Parameter

    Hi, I'm using Oracle Sql 11g to create a stored procedure which I am then using to create a crystal report. My problem is with passing the Date Parameter through the stored proc. As Oracle wants to treat the date as a datetime, I can't get the parameter to work. Parameters are declared as...
  15. BeeBear2

    Adding "ALL" Value to Cascading/Dynamic Parameter???

    Hi Lbass, Silly me!!! Crystal decided to do the auto joins when I closed the Database Expert - I have set crystal to not do this now. Its bringing back data now. Now I just need to make it the right data. :-)
  16. BeeBear2

    Adding "ALL" Value to Cascading/Dynamic Parameter???

    Thanks LBass - timely as always! I managed to create the 2 command prompts, but after I saved the Database Expert selection (even without linking the parameters to the tables or even putting the paramter in the Seclect ), my report stopped returning data. deleting the command prompts didnt even...
  17. BeeBear2

    Adding "ALL" Value to Cascading/Dynamic Parameter???

    Hi everyone, I have come up against an issue that I can't work out with dynamic parameters. I have a parent parameter (Country), and a child parameter (City). Both parameter lists are created from the database summary table. My issue is I want to add an "ALL" option to the top of each list...
  18. BeeBear2

    whats the main differences between 2011 and 2015 Crystal Enterprise

    Hi, I'm going to start using Crystal Enterprise 2015, and Crystal Reports 2013 in a few weeks. I am used to using all versions of Crystal Reports/Enterprise up to and including CE and CR 2011 (XI). From what I've read there isn't much difference in Crystal Reports 2011 to 2013, but does the...
  19. BeeBear2

    Conditional Formatting one cell dependant on the combination of its value & a second cell value

    Hi, Using MS Excel 2010. I have an excel spreadsheet roster that I am trying to put some quick highlighting in to easily see if I'm missing a role for a particular day. Basically, I have one Row per day, and several columns of names along the top, so under each name I add a role. To the...
  20. BeeBear2

    How Do I automatically populate one sheet with the contents of 6 other sheets in the workbook?

    Ok, so I have now got Power Query installed on my machine, and your steps don't match to this, Maybe I should point out that I'm using MS Office 2010 (Excel Version 14.0.71). I don't have the "Get&Transform Function that you are talking about. Can you give me the step-by-step through Power...

Part and Inventory Search

Back
Top