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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: nlaliberte
  • Content: Threads
  • Order by date
  1. nlaliberte

    Formula Returning Wrong Value for Group Name

    I'm using Crystal XI on an OLE DB connection. This is the strangest bug I've ever encountered in a Crystal Report. Here is the situation: Group 2 has 'Use a Formula as a Group Name' selected. In that formula it states; IF {proc.group2_type_id} = 70 THEN IF {proc.group2_value} = -1 THEN "...
  2. nlaliberte

    Rogue Zero Displaying on Excel Export

    I'm using Crystal XI and an ODBC connection to a SQL server. This issue is that an excel export is displaying zeros in cells that are supposed to be NULL. These are summary fields in a total line that are conditionally set to suppress. These fields are dynamically set in the stored proc that...
  3. nlaliberte

    DATE instead of DATETIME parameter

    Good Morning I'm using Crystal XI and an ODBC connection to a SQL Server. I'm running a report off of a stored procedure that calls on a datetime parameter (@report_date). I would like to prompt the user for just a DATE, and leave out the timestamp, however once I connect to the procedure in...
  4. nlaliberte

    Resetting Page N of M

    Basically what I'm trying to accomplish is running what looks like multiple reports all in one shot. Each instance of the group should have it's own report, which means starting a new page and resetting the page number. However, the user would like to have a 'Page N of M' field in the header...
  5. nlaliberte

    Suppressing Parameter Prompts

    I'm using Crystal XI. What I'd like to do is conditionally suppress one of the parameter prompts based on the values selected in another paramter. The functionality is as such; The report has three sections and the user has the ability to pick any/all of these sections to display. IF only...
  6. nlaliberte

    Repeating Section without Groups or Data

    Good Afternoon, I'm using Crystal XI and an ODBC connection. I am working on a report that has a large section of static data, 'terms' if you may, that needs to be repeated 3 times, one after the other, per record. Maintaining these as 4 seperate sections could prove to be pretty tedious...
  7. nlaliberte

    Adding Unique Contstraint

    Good Afternoon, I have a simple relationship table that I need to add a contrainst to. The table is supposed to be a parent/child relationship, as well as the date the relationship is effective. See Below: CREATE TABLE relation ( child_id INT ,parent_id INT ,acq_date DATETIME ) We have...
  8. nlaliberte

    Criteria on Running Totals - Reset On Change Of

    I'm using Crystal XI. I'd like to put criteria on the 'On Change Of' in a running total. The report is run by two possible scenarios, 'run_by' 1 and 2. When 'run_by' = 1 I'd like the running total to never reset. However when it's run by 2 I'd like to reset on the change of my Group1 value...
  9. nlaliberte

    Failed to Retrieve Data from Database

    I'm using Crystal XI with an OLE DB connection to a SQL server. I'm getting the 'Failed to Retrieve Data from Database: Arithmetic overflow error converting numeric to data type varchar' error but the odd thing is I can still run the proc just fine in SQL Management Studio. The error only...
  10. nlaliberte

    Multiple Columns -- Down then Up

    I'm using Crystal XI and an OLE DB Connection. Basically I have a report that looks something like this. Report Header A Report Header B Report Header C Details Report Footer A Report Footer B The Report Headers and Footers are pretty important legal mumbo-jumbo, and it's very important...
  11. nlaliberte

    Keep Group Together within another Group

    I'm using Crystal XI and an ODBC Connection to a SQL Server. The issue I'm having is with a Group where 'Keep Together' is true is creating a blank page. Essentially Group 1 is the top group in the report, and each new Group 1 starts on a new page. I have Group 2 set to 'Keep Together' to...
  12. nlaliberte

    Variable Help...

    I'm using Crystal XI. I'm trying to use a variable to govern whether or not a group header appears on the next page with "(continued)" next to it. Basically the report is an activity log, with the activities being long strings that tend to run onto the next page. Our user would like the...
  13. nlaliberte

    Sorting Issue: Dash in sort value is skewing sort

    I'm using Crystal XI and an OLE DB connection to a SQL server. We have having problems with sorting a group. The values we are sorting all have a dash somewhere in the title, however it seems that the sort function in crystal is not functioning correctly. Below is a list of the groups in...
  14. nlaliberte

    Group Headers appearing with no details until the next page.

    I'm using Crystal XI. The issue here is with the Group Headers populating at the bottom of the page with no details below it. I would like to prevent this from happening but I can not use a 'Keep Group Together' because there are three levels of grouping and not all three are always used...
  15. nlaliberte

    Image Sizes not displaying correctly for certain users

    We're using Crystal XI and an OLE DB connection. Basically we are displaying a company logo in the top right of the page header. When I developed the report I inserted the image and left it in it's original size, 2.26" by 0.44". When the report is viewed through the UI via Crystal Report...
  16. nlaliberte

    Count with conditions

    I'm using Crystal XI and it's being fed from a SQL Server via an OLE DB connection. What I have is a data set that has a list of companies and the amount of dollars in their account. There are multiple types of accounts, therefor a company may be listed on more than one record. What I need...
  17. nlaliberte

    Pie Chart: Overlaping Data-Labels

    Good Morning, I am using Crystal XI. The issue I'm having is with the Data Labels and Values overlapping eachother. It is a full page pie chart with the pie size set to 'Large', marker size set to 'Medium'. I'm showing both the Data Labels and Values 'Outside Pie', and they have been...
  18. nlaliberte

    TOTEXT Formatting for negative numbers

    I'm using Crystal XI and a SQL Server connection. My issue surrounds a value that I have to display as a string. When this value is negative it displays with a dash in front, we would like it to display in parenthesis (accounting format). I can't find the correct formatting to use in my...
  19. nlaliberte

    Display Details in Two Columns?

    I'm using Crystal XI and a SQL Server via an ODBC connection. What I'd like to do is display my details section in two columns instead of one. The report this is for is a Contact report, and basically displays addresses like you would find on a mail envelope: Contact Company Address 1 Address...
  20. nlaliberte

    Format Strings! : Used on a data-set field

    I'm using Crystal XI and an OLE DB connection to a SQL Server. I want to know if it's possible to use a format string on a field in the data-set. I'm familiar with using a format string in a formula i.e.: totext({table.field1},"#,###.00") We would like to do this without having to create a...

Part and Inventory Search

Back
Top