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...
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
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...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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. :-)
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.