Recent content by willisa

I have asp.net applications and non asp.net applications running on one of my servers. Today all asp.net applications have just stopped working. All applications that are not ASP.Net applications are completely fine. From the users view the screen goes white and it looks like it is loading a...

OK, it doesnt quite act as I would like it to. It is showing the header on the first group total on the main report. Can someone tell me how to stop it from doing that

Could someone please explain something for me. I have a report with three groups. For the last group the total is shown but not the header and the detail. When I drill down into it originally only the detail would show and no page header. This is because I hadnt checked 'show all header on...

Hi I would like to suppress the report header whenever I drill down, however I dont want to suppress anything else (like the report option show all headers does) How do you do this using formulas. I have looked at a example in another query however, when I tried to replicate this it didnt work...

unfortunately I am doing this through crystal enterprise without building custom csp pages. So unless I did that its not going to work. Thanks for your time.

Have you done that before? I would have thought that by the time you string it together it would have been to late to send to the stored procedure. I will give it a go though. I am assuming you string the parameter together in the report header

Is there a way of passing multiple selection parameters selection to a stored procedure?

That is true about the verifying database thing, however every now and again crystal reports gets a real bug in its bonnet because in my case re verifying the database alone didn't work, I had to also delete the last formula I added that was based on the field that was having problems. Only...

I actually had a very similar thing happen, the way I fixed it was... I deleted the offending formula re verified the database and then re created teh formula and it seemed to fix it.

The wierd thing if I put in the following (take out the ifs)and make the selections this works. Which is what the resulting record selection formula wouldbe TRUE and {stp_get_filtered_portfolio.engagement_organisation} in {?engagement_office} and...

Because its based on a stored procedure its not showing that stuff on the record selection formula. EXEC anz_dw.dbo.stp_get_filtered_portfolio_no_responsibility 'Engagement_Organisation', 'All', 'All', 1 This is the stock standard stored procedure, and the three parameters that I am using to...

For starters you shouldn't have the words in range if you are using a discret value. You should have = only. Also if you are using in range the correct syntax is as follows. if date in (date1} then value else 0 Try on or the other depending on if you are testing a range of values of a single...

okay I have used this as my record selection formula, however I am not getting the result I want. If more than one of them is not &quot;All&quot; then it only filters by the first one thats not all and doesn't filter by the rest. Can you see where I am going wrong? if {?employee_office} <>...

Why is a parameter out of the question, is there a limit on the number of choices? as for string length there is a limit of 254 chars, 50 * 2 is only 100. If you were to use a parameter you could use not in{parameter} in your record selection formula. Also what are they viewing the report...

In the example above there is two parameters making up the record selection formula, however the one I am trying to do is based on five parameters. So I am really looking for another way of writing this sort of record selection formula.