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!
-
Can parameter values be assigned programmatically?
Made a call to BusinessObjects support and found a workable solution. The short answer: you cannot use a CR formula or function to populate a parameter field in the same report, because Crystal executes the SQL query before it evaluates the report formulas. This makes perfect sense, but my...- kubu
- Post #2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Can parameter values be assigned programmatically?
My report (CRXI) uses a command object with start date and end date parameter fields. I have CR functions that calculate these dates based on the current date. Is it possible to assign the results of these functions to the parameter fields at runtime? If so... how? Thanks! Mark- kubu
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
How can I limit the number of records (for testing)?
Thanks for your response. I understand the concept of limiting records in Crystal — e.g. using a record selection formula to limit by date. Again, the problem is that this is a very high-volume db. Even if I put something like {table.datefield} >= CurrentDate in the record selection, I'll...- kubu
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
How can I limit the number of records (for testing)?
Well, that's a valid question. Part of the challenge in this project is that I'm working with very unfamiliar data, no data dictionary, etc. As I gain a better understanding of how the data is related, this may be an option. So far, though, it appears that the tables use concatenated keys...- kubu
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
How can I limit the number of records (for testing)?
Sorry, but this is probably a real "noob" question. I'm new to CR (using CRXI with a BOXI server). I'm accustomed to writing my own report SQL as stored procedures, but this is not an option for my current project. I have an issue similar to the one posted by ddnh; that is, my reports...- kubu
- Thread
- Replies: 7
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Dynamically replicating tables
Here's another approach (though I'm sure it could be optimized). This should work for IE4+ browsers. My "Add Button" arrangement is kinda clunky, but whaddya expect for a quick hack? :P <html> <head> <title>Untitled</title> <script language="JavaScript"...- kubu
- Post #3
- Forum: Javascript
-
User control postback event -- Arrrggghhhhhh!
Thanks, Paul. I'll give this a go. My menu is a third party control (Infragistics UltraWebMenu), so I'll have to look at the JavaScript they're throwing behind it to see what's really going on. I have a hunch that you may be correct about the location='thisPage.aspx'; scenario. I know that I...- kubu
- Post #3
- Forum: Microsoft: ASP.NET
-
User control postback event -- Arrrggghhhhhh!
I have a simple horizontal menu in a user control (ascx) form that I use on several aspx pages. The menu has five options (we'll call them A, B, C, D & E). Options A & B are linked to different DIVs on the same aspx page. Options C thru E target different aspx pages. Here's my quandry: when...- kubu
- Thread
- Replies: 2
- Forum: Microsoft: ASP.NET
-
Combine event handling for separate DataGrids?
Thanks, both! Actually, Paul, I think netangel's solution will work for me, as my grids are static on the page rather than dynamically built. I guess I could have worded my question better (or at least simplified it somewhat). Essentially, all I need to know is what DataGrid fires the event...- kubu
- Post #4
- Forum: Microsoft: ASP.NET
-
Combine event handling for separate DataGrids?
I've got an .aspx page containing five DataGrids. I'd like to be able to handle the various events for these grids in common codebehind sub procedures. For example, I want to have a sub procedure called EditGridRow() in the codebehind, and give each <asp: datagrid> element in the .aspx page...- kubu
- Thread
- Replies: 3
- Forum: Microsoft: ASP.NET
-
A newbie question regarding the <xsl:apply-templates> element.
Thanks for your reply, uura. Your example really helped. It makes a little more sense to me now. I also posted this same question in Wrox's XSLT discussion forum (p2p.wrox.com), and for what it's worth, here's the answer I received: ------------------- Basically, it gives you a bit more... -
A newbie question regarding the <xsl:apply-templates> element.
I was reading Bob DuCharme's article titled "Sorting in XSLT" (http://www.xml.com/pub/a/2002/07/03/transform.html). I saw the following code that causes me some confusion: <xsl:template match="employees"> <xsl:apply-templates> <xsl:sort select="salary"/>... -
is it doable ?
tyris & flumpy: I'm also quite new to XSL/XML, and this problem piqued my curiosity. I decided to use this for practice/learning as it looked relatively easy. Ahh, appearances can be deceiving! Several hours and many approaches later, I still didn't have a solution. After a little more... -
Programmatically default a column to "text" rather than numbers?
Thanks, all, for your input! I was already aware of the methods mentioned, but I'm looking for a way to automate the process -- i.e., no user interaction. In other words... 1. the user double-clicks on the .csv file or loads the file from within Excel... 2. Excel somehow detects that this...- kubu
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
www.tek-tips.com as a VS tool
Kewl idea, Alcar. I think I'll do the same!- kubu
- Post #2
- Forum: Microsoft: ASP.NET
-
Programmatically default a column to "text" rather than numbers?
I'm a VB programmer, but I haven't done much with VBA and Office. Here's my problem: I have a report that users export to a .csv file. The first column of this report contains number strings. These numbers are identifiers that may begin with a leading zero (e.g., 05678). Excel converts...- kubu
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Framework SP1
No problems here. I downloaded the patch and installed it manually, though. FWI, I'm running W2K on a Pentium III. good luck, Mark- kubu
- Post #2
- Forum: Visual Basic (Classic)
-
Filtering problems
To filter your data, you can either create a DataView object, or use the Select() method of the DataTable class. Select() returns an array of DataRow objects. Here's a partial sample of how to use this feature: Dim cn as SqlConnection Dim da as SqlDataAdapter Dim ds as DataSet Dim row as...- kubu
- Post #2
- Forum: Visual Basic (Classic)
-
Debugging Error
Ken Make sure the "Debugger Users" group has been set up on the remote server and that you have been added to that group. I encountered this problem when trying to run the debugger on my local IIS. Mark- kubu
- Post #2
- Forum: Microsoft: ASP.NET
-
frames and switching pages... a related query!
Thanks to both of you! This gives me a few more avenues to explore. I'll be sure to keep you updated on my progress. Mark- kubu
- Post #4
- Forum: Microsoft: ASP.NET
