Recent content by datenis

Hi, Resolved my own problem after looking at the query results in management studio and applying suppression formula.

Hi, I've got a parameter that I would like to use to search on multiple fields instead of using one parameter per field. The problem is that when I set the selection formula to Parameter = A.Field or B.Field or C.Field then I get A x B number of records returned. I have a grouping on...

I played around with this feature some more. I've changed the optional prompt property to true on the parameter and I was able to resolved this issue.

Looks like this option is only available in CR 2008. For those who are in the same boat as I am it is a property called 'Show on Panel' on the parameter.

Hi, I downloaded a trial version of CR server, and when I upload my reports to the server it prompts for a parameter value before actually generating the data for the report. I don't get this prompt if I run one of the reports in the sample folders. If I make a copy of the report from the...

Hi, I've downloaded a CR Server trial and uploaded some of my own reports written in XI. They generate properly, but when I click on the parameters panel on the side no fields are displayed, while the sample reports the parameters show up properly. Is there a way make the parameters show up...

I was trying to connect from a client machine. I'm able to connect to the database using PCC on the server. I'm able to see the contents on the X$FILE table for the database that I get the "no table" error. However if I enter the name exactly as shown on the entry in the X$FILE table I still...

I cannot do a select * from X$FILE since the table listings for that database is not displayed on that machine. On the other machines where I was able to make a database connection to the server, the X$FILE entries show only the file names. Thanks,

I want to connect to one of our client's machine using psql CC 8.7. First I tried to connect directly to the ddfs on the server, and I get this error: The Btrieve file directory is invalid[betrieve Error 35] I made sure that the user had read/write/delete access on the directory. No luck...

Hi lbass, unfortunately, the suggestion did not work. Any other ideas would be appreciated Thanks.

Hi, I have a report where the chart is based on the sum of a number from the group divided by a second number, for example the formula of formula field A would look like this: (SUM(YTDSALES,GROUP1)/X) When I try to generate a bar chart using this number, forumula field A is not displayed on...

Hi, I have a line chart and if I click on the "Show Numeric Scale" Under Chart Options -> Grid -> Group Axis -> General, the underlying trendline will not be displayed. How do I fix this issue? I'm using CR 10 Thanks in advance.

Hi, I have 2 problems. I'm using CR 10. 1. The X-Axis on the chart is based on a formula which returns a number. When the chart is displayed, 2 decimal places appear for each item on the X-Axis. I've tried to get rid of the decimal places by using Truncate(x), setting the number format on...

I figured if I want to do this I must write a command to query for the results first and then put it into the crosstab.

I see how this works. However, is it possible to get TOP N rows by TOP N columns? Example Rows: Customers Columns: Products Specifically I'd like to see on the crosstab the sales of top N customers on the top N Products that we sell. Thanks.