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 strongm 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. samiam07

    Crystal Report Enterprise and Licensing

    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...
  2. samiam07

    Advanced Training for SSRS

    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...
  3. samiam07

    Need help to intrepret SQL code

    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...
  4. samiam07

    Need help to intrepret SQL code

    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...
  5. samiam07

    How do create a Custom scale colour for a Gauge ?

    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,
  6. samiam07

    Data Driven Subscription

    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...
  7. samiam07

    Exporting to excel with hyperlinks

    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...
  8. samiam07

    Running a report for mulitple clients

    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...
  9. samiam07

    Multiple Values in Parameters

    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...
  10. samiam07

    Multiple Values in Parameters

    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...
  11. samiam07

    Parameters in Crystal Reports 2008.

    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.
  12. samiam07

    CR10 - Incomplete Report Definition

    What type of formulas are missing?
  13. samiam07

    Cascading Dynamic Prompts misbehaving?

    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.
  14. samiam07

    Short list of parameter values

    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.
  15. samiam07

    Short list of parameter values

    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...
  16. samiam07

    Short list of parameter values

    I've tried that. The default is supposed to be 1000. My list only has 275 values and should not be affected. Even after making the registry change, the prompt still show 2 batchs of values, one with approx 200 values and the other 75 values in the second batch. As a follow up. There are exact...
  17. samiam07

    Short list of parameter values

    CR2008 I created a dynamic parameter that has just 275 values in it. When I run the report and prompt the user, CR displays about 200 values and puts the rest in another batch that has to be selected before the values are available. I have Allow Multi Values = True and Allow Discrete Values =...
  18. samiam07

    Question about TransferSpreadsheet

    Transferring multiple tables/queries from Access to a single Excel workbook is something we do all the time. Here is a sample of the code to transfer 4 tables from Access to a single xls book called 'FileName'. Dim SheetName1 As String Dim SheetName2 As String Dim SheetName3 As String Dim...
  19. samiam07

    Combine Zipcodes into 1 field

    I have a table with states, countys and zips. Many counties have more than one zip. Some may have a hundred or more. This zip table has about 80k records. I need to create a table that has a state field, a county field and one field that has all the zips for that county separated by commas...
  20. samiam07

    Maximum limit for Crystal Report parameter choice box?

    I believe the limit is 1000. There is a registry hack that will let you change that limit, but I can't think of it off the top of my head. Try a search on Crystal Reports pick list limit

Part and Inventory Search

Back
Top