Search results for query: *

Hello, I am using ColdFusion MX7 Report Builder. When I try to change the font of a basic text item such as a label and go to the font dropdown box, none of my Open Type fonts are available. Only True Type fonts can be selected. This is also the case in the Properties Font Name box. My Open...

Thanks kskid! This is great! I have one last level of complexity for the report (and then I'll leave you alone...I promise!). I also need to sort by projectno and perform subtotals on the change of each group. Since table 1 and table 2 may or may not have the same projectno, I'm not sure...

Hi kskid. Thanks for your help. The following is a sample of the data (this is customer account data): Table1 acctno date projectno other_fields... 111 4/21/05 9999 ... 222 4/19/05 8888 ... 111 4/12/05 9999 ... 111 4/13/05 7777 ... Table2...

Hello, I'm using CR9 with SQL Server 2000. Without creating a view, can someone tell me how I can show details of two different tables that are both filtered separately? I pass parameters to the report to limit the records by account number and date. For instance, table one is filtered by an...

As a first line of defense, you can add the following javascript onto your page so the user can't go back to a previous page: <script language="JavaScript"> <!-- window.history.forward(1); --> </script> You should also add the following on the page you don't want the user to go back to...

Something like this might help you split up the field into month and day: select left(yourdatefield,charindex('/',yourdatefield)-1) as month, substring(yourdatefield, charindex('/',yourdatefield), len(yourdatefield) - charindex('/',yourdatefield)+1) as day from yourtable where...

Hello, I've created an ActiveX component through VB6 that utilizes the acrobat type library (acrobat.tlb) to view and print pdf files. The problem I ran into is that it only works on machines with the full version of Acrobat loaded. Could I be missing something in using the type library? Is...

Sorry for the delayed response. This is driving me crazy. Can you tell me how to get to the datasource settings you described? I can't seem to find anything that lists "prompt the user for database logon when viewing". This only seems to happen on reports I create from scratch. When I use...

When you select a Max on an empty table, a NULL will be returned. You will never receive an EOF on that query. You might try doing something as follows: If isnull(objRS("NEXTIDVAL") Then intNewID = 1 Else intNewID = objRS("NEXTIDVAL") End If

Hello, I have a report consisting of several subreports that runs without any issues in the Designer. Once I publish the report to Microsoft CRM, I can also view it without any problems, but when I go to print it, I am asked to log into the database as if I wasn't already connected. This only...

Thank you! I will check out the utility. This could save a ton of time.

Hi Folks, Is there any way to save a ton of reports from either version 7 or 8.5 into version 9 without going into each report and doing a Save As? Thanks for your assistance.

Use a double apostrophe. select * from teste where name='Ricardo''s Pereira'

It would be a very similar query: SELECT date FROM table WHERE date > (getdate() - 30) GROUP BY date ORDER BY date You could also use distinct in that situation: SELECT distinct(date) FROM table WHERE date > (getdate() - 30) What exactly are you trying to do? This situation is different...

No, you're grouping by store and then by date so it won't limit the grouping to only one of the same store. Give it a try.

Something like this might work: SELECT store, date FROM table WHERE date > (getdate() - 14) GROUP BY store, date ORDER BY store

Thanks Sis. Worked perfectly and saved some aggravation.

Hello, Can someone please tell me how to sum a field name when it contains parentheses? My field name is "GT_Sum_(_new_line_COST_)" That's without the quotes and when I do SELECT max(GT_Sum_(_new_line_COST_)) I receive an error. Thanks in advance.

Thanks so much. Service Pack 3 did the trick!

Can you create a parameter field of value type string? I'm not sure the maximum length of the string type, but I've done a similar thing and it worked like a charm.