Recent content by samiam07

We are running BOE 4.2 on a Windows Server 2012 VM. All of the reports (4000+) have been created in Crystal Reports as a stand alone app and then published to BOE. We need a lot more CR licenses for the people who are demanding the ability to create their own reports. BOE 4.2 Launchpad, under...

Does anyone have any Web sites or leads about training courses for Advanced Level SSRS 2008 (R2)? Preferably on DVD or download. I've been working with SSRS for a couple of years and have had to make it jump through hoops to do some of the reports that were requested. Now it's time to find out...

Thank you, Thank you I came up with the same thing and couldn't believe it. Why was it written this way just to get the first of the month when all the dates in this field are by definition and default the first of some bloody month?????? Oh well! Whenever someone leaves a contract and some...

Using SQL Server 2008 R2 Trying to figure out out what date this statement produces with a starting date of mydate=10/1/2010 CONVERT(datetime, CONVERT(char(11), DATEADD(dd, - (DAY(DATEADD(mm, 1, drh1.mydate)) - 1), drh1.mydate), 101)) I've tried to break it down piece by piece and pulling...

Is there a way to change the order of the reports listed in the Solution Explorer window? When adding reports to a project, the rpt names appear in the order that they're added. We would like to see them in alpha order. Thanks,

SQL Server 2008R2, SSRS 2008R2 I found a page on the MS Technet called Creating a Data-Driven Subscription. This is exactly what we need. Now the problem. It appears that this only works with the Dev and Enterprise editions. We have the Standard edition in production. I'm not sure if we can...

SQL Server 2008, SSRS 2008 R2 I'm creating a report that shows 12 rolling months with rows of: Beginning Bal Receipts Outflows Ending Bal This will be exported to Excel. What they would like to be able to do is, in Excel, click on the Receipts cell and hyperlink to a xls tab in the...

Using SQL Server 2008 SP2, SSRS 2008 SP2 I have a working report with multiple tables, charts, etc. The end result is exactly what it should be....for a single client. We have almost 100 clients and growing, so I need to run this report for each client. I don't want to run one at time, nor is...

Thanks for the quick reply. The List(Tablix) appears to work, but gives an error like: >>Table2’ has a detail member with inner members. Detail members can only contain static inner members. Doing the same thing in a Table (also a Tablix) and deleting the detail row and using just the header...

Running SSRS 2008 R2, SQL Server 2008 I've created a report with multiple tables and a single value parameter for CoID. There are 4 different queries for the 8 tables on the report, so what I did was add a filter for each table for the CoID parameter. This works great.....however, Now I need...

Check out the HasValue() function in CR2008. It allows for a blank value in a parameter. It's new in 2008 and will cause errors if the report is created in 2008 and run in Xi.

What type of formulas are missing?

I've played around with this as well. I have only 275 values in the pick list and in v2008 the prompt will display 250 in batch 1 and the remainder in batch 2. We get this behavior even after making the registry entry 2000. It looks like something we're going to have to live with.

I opened it notepad and it’s a list of 1000 values and resaved with the same result. This batching thing is something in Crystal Reports 2008 and I can't find any reference to it anywhere, so far.

No there is just one parameter. Here's what I just tried. In Excel, create a list of 1000 numbers. Save as book1.txt, a plain text file. Open CR2008, Create a blank report with no database. Create a new parameter called My Parameter. Import book1.txt. Drop MyParameter into the Detail...