Search results for query: *

dim orpt as object orpt = new myReportName take a little more resources(i believe) but it does what you want :)

lbass, Its basically a letter that gets mailed telling someone what they owe us - and there can me multiple line items: Name Price Total Item 1 $20 $20 Item 2 $10 $30 I need that list at the top and bottom of the letter, which a bunch of wording between. Report Header -...

I've gotten the exact same error when the .net frame was 1) not installed 2) installed but had errors in case #2, uninstall the .net framework, reboot, install as admin (not using runas) Hope it helps.

Dim rpt as new rptData rpt.SetParameterValue(0, "Parameter 0 Value") rpt.SetParameterValue(1, "Parameter 1 Value") rpt.SetParameterValue(2, "Parameter 2 Value") ... etc

I've learned alot about CR in the past few months(working with it almost everyday). But my mind is coming up blank on this one. I'm using CR 10 and MSSQL 2000. I have my report and i need TWO details sections. One in the middle of the letter and one at the bottom (so it can be cut off). I've...

I wish you could edit posts on this message board... Looks like the record selection formula was it. Now how can I make my report? I guess i'll try it. Thank you synapsevampire!

I didnt know you could right click and browse data - thanks!! The data appears when i do that, and they are all correct too. There is something in the record selection formula - the top part of the report uses it - i'll try taking that out (but that would screw up the top portion of my report)...

synapsevampire, thank you so much for your time nad help - i've gotten it to pass the SP the procedure the parameters needed but now I have a different problem. if I put any data on the report from the SP the entire report goes blank - even the data that isnt being retrived from the SP. I can...

synapsevampire, Thanks for the link. I managed to create a union in the SQL command but i want to know howto pass it the parameters, it never prompts for them and the .properties object in VB.NET is read only - it would probably work but right now i have no clue where it is getting its...

Ok i've ben trying to get past this problem for a few days now, I went and bought CR10 and still cant get it the way i want it. Using an MSSQL 2000 DB I have 4 complex SQL statements i need to run - each needs 4 parameters. (the same four for each). I've tried a stored proecdure, but i...

dont forget to set SizeGripStyle to hide also disable maximize box as mentioned earlier

Hello, I'm looking for advice, hope this is the right place. I have this report which is a cash drawer auditing form. I'm having a hard time with it - i've been reading and my book doesnt help any - so i've come here (hope thats ok). Oh, i'm using CR9(that came with Visual Studio.net 2003)...

Well, unfortunately the easiest way that i know howto do this is to run my queries and just send the numbers as parameters. I cant figure out howto use the parameters in an SQL command.

This is what my SQL Command area looks like :( Picture

I am pretty sure CR version 9 is what comes with Visual Studio .NET, my version number for the DLL is 9.1.9800.0.... sorry if i confused anyone.

Crysal Reports 9(CR9) I think at least - its the development interface that comes with Visual Studio .NET 2003.

I cant seem to find howto add parameters from the SQL Command dialog - I do not have a "creat" button. I'll look into the derived tables, but that still requires me to use the SQL Command with parameters. I did state my db, it was at the very bottom, but nevertheless i'm using MS SQL server...

Here is a sample of my SQL: select amount_paid from tickets where receipt_number in (select receipt_number from receipts where register_number=@register and cashier=@cashier and receipt_date = @today); I run the same basic query on multiple tables - the idea being that i need to find the...

synapsevampire, Thanks - I had found the add command right as you posted this. That would work but apparently you cant have your crystal reports parameters in commands. The numbers I am using are sums of dollars from receipts from different tables. - I just know i can query for it in VB and...

I have some SQL queries that basically sum up numbers from a number of different tables - I need to display these numbers on my report but can find no way to use pure SQL in the report. Is it even possible? Should i run it in my VB app and pass the number as a parameter? Thanks for any help...