Recent content by ciscowiz

I didn't know that putting two datasources in the main was not supported. I don't think it would be feasible to go through and add the pubinfo code to all (over 200) views/SPs so I will try the subreport. Thanks Again!

synapse, I apologize for not being very clear with my issue. The "/" in "main view/stored procedure" is meant to be read as "OR". The reason I said main is because every report has atleast TWO views (one is v_pubinfo) or a Stored Proc. and a view (v_pubinfo). The two are NOT LINKED in the DB...

Barbara, Thanks for the help. I was thinking the same thing except do I need to use a subreport in the Report Header or can I just use the field/shared variable directly in the Report Header? We are trying to move away from subreports. Thanks, Bryan

I am using CR9 integrated into a VB.NET web app. All of our reports have a main view/stored procedure and a view called v_pubinfo which supplies personal company info such as Name, Address, and the 'logoletter' which is a character (d,f,g,t,etc.). We use the logoletter in the page header of...

Nevermind, got it. Just not thinking.

Alright guys I have the report displaying as I want EXCEPT for the sort order. Do you guys know how I can sort this report by date if my first two groups are GUIDs (Long unique ID)?

Thanks Again!

Synapse- I really appreciate your time and help. You have helped me countless times but I don't think I am being clear enough for you because I am pretty sure you know how to do this. It's still not working, it just keeps repeating Details-B for every record. The "Details-C" formula I dropped...

It's not working, it keeps repeating Detail-B even if Detail-C has no data.

I am using CR9. My report is as follows GH1 >> CustomerID - SUPPRESSED GH2 >> TransactionID - Various fields Detail-A- Conditionally Suppressed Detail-B - Essentially another "Header" section with NO DATA. I want this section to show up only once, IF there is any data in Detail-C Detail-C -...

I can't really remember. If you go to the Crystal support site and search for "export pdf" or something similar to that there is a fix where you have to install a hotfix and make a registry change. It is something like "Fieldclippings" and you set it to a value. I can't remember if that did it...

Nevermind got it.

I dunno I guess I'm stupid...I thought by moving my totals and subreport to the page footer it would screw up their values in relation to the group. Anyway, thanks it worked, I just had to create a conditional header to show up for additional pages. Is there anyway to determine if there is a...

Hello all - I am using CR9 with SQL Server 2000. My report is an invoice and has the details section split into A and B. B is suppressed based on a condition and A is to display the normal records. Group Footer is split as well with GF1-A holding a subreport. GF1-B essentially serves as a...

Oh i figured it out, I knew it was something simple: you just give the parameter the value of DBNull.Value in VB.NET. Thanks!