Search results for query: *

Thanks for the reply. Message received loud and clear and advice followed. It has been a long while but I understand the strong response. I actually have resolved this with a simple join.

I am developing SQL reports in Visual Studio 2005 and have written a report that processes the following records. 1. A case has 1 case record. 2. A case record has 1 or more related service records. 3. A case record has 1 or more related activity records. 4. A case record has 1 or more related...

I’m using CRM 4.0 and I want to pass an attribute value as a parameter to a url in an IFrame. It works fine with the parameter value hardcoded into the url e.g. the url on the iframe is set to -http://test/ISV/NewPersonDetails.aspx?PersonNo=999999 However I want to pass the attribute value...

It worked perfectly. Thank you so much.

I know a union will get all the ordered records followed by the total available. I would really appreciate it if you could show me how to query the data to get it in this format: Size No Ordered Total Available So I can then work out the %. Apologies if I am missing the obvious and many...

Thanks for the reply Duane. I have tried to add the total available by size to the record source of subreport 2 without any luck. Subreport 2 is built using the following SQL Query: SELECT Size, CompanyID, Count(CompanyID) AS [Ordered Total] FROM tblMonthlyOrders WHERE Ordered=1 GROUP BY...

My main report prints one record per page. In the detail section there are 2 continuous subreports. Subreport 1 shows how many items for sizes 1, 2 and 3 were available. Subreport 2 shows how many items for sizes 1, 2 and 3 were ordered. In subreport 2 the 3 sizes % ordered should be 100%. It...

Thank you! I cleaned up the data and that worked perfectly.

I have changed the code to: Select 42, b.RaceNumber, a.AssetID , b.DateOfBirth From tblTempValue a Left Join tblTextDOB b ON a.Value LIKE concat('%', b.RaceNumber) This works to a degree but I have just discovered that the data comes in with random spaces and commas...

I also wanted to say that inside my INSTR function I am attempting to link the Value field in the first table with the RaceNumber field in the 2nd table to pick up the DateOfBirth field from 2nd table. Can anyone help with the correct syntax? Thanks again.

Thank you r937.com. I am new to MySQl and I think it shows! Would really appreciate it if you could advise on how to amend my code to achieve the required results. I agree re multiple comma-delimited values. I inherited the table design. Thanks.

Hi. I have the following 2 input tables: 1. tblTempValue has 2 fields: Value (TEXT) and AssetID (BIGINT(20)) and holds the following values: Value AssetID 1,3,10 90 4 91 8 92 2 93 5 95 2. My lookup tblTextDOB has 2 fields: RaceNumber (VARCHAR(20)) and...

Thank you. The report is now working perfectly. Really appreciate the quick replies.

Sorry should have said: However moving subreport2 to a detail_b section puts the report rows out of alignment and this data will be downloaded into a spreadsheet. Is there any way I can create a formula in subreport1 in detail_a to access the value calculated in subreport2 in detail_b? Using...

Thanks for the prompt reply. That fixed the calculation problem. However adding a subreport2 puts the report rows out of alignment and this data will be downloaded into a spreadsheet. Is there any way I can create a formula in subreport1 to access the value calculated in subreport2. Using...

I have a problem calculating a formula using shared number variables and sub-reports. I have checked out FAQs and thread767-857392 but it still is not working properly. I am running CR10 using a Stored Procedure in SQL 2005. 1. I define 3 shared variables in the detail section of my main...

Thanks for the reply. I have tried printing the report once it has been closed as suggested and this makes no difference. Any other ideas?

Hi again HELP! Still having problems with this. I completely understand what should be happening with the code. To give more specifics I call the following function to print my continuous forms with detail sections of 8 inches x 4 inches each: Function SetReportMarginDefault(strReportName As...

Just a quick question about using the PrtMip property. I have written the code and have set DefaultSize to False as my paper size is 0.5cm longer than A4 so I want to ignore the size value in the detail section in Design view and use the values I assign in ItemSizeWidth and ItemSizeHeight. I...

Thanks for such a quick reply! I too have tried to manually define the the printer settings and do not get the settings prompt. The printer is an EPSON DFX-8500. I will try the coding option and let you know how I get on. Thanks again for the help it's much appreciated.